17#include "moc_qgsrelationreferencesearchwidgetwrapper.cpp"
28#include <QStringListModel>
54 if ( fkeys.isEmpty() )
61 Q_ASSERT( fieldPairs.count() == fkeys.count() );
62 for (
int i = 0; i < fieldPairs.count(); i++ )
64 if ( fieldPairs.at( i ).referencingField() ==
layer()->fields().at(
fieldIndex() ).name() )
88 return fieldName +
" IS NULL";
90 return fieldName +
" IS NOT NULL";
92 const QVariant v =
value();
96 switch ( v.userType() )
98 case QMetaType::Type::Int:
99 case QMetaType::Type::UInt:
100 case QMetaType::Type::Double:
101 case QMetaType::Type::LongLong:
102 case QMetaType::Type::ULongLong:
107 return fieldName +
" IS NULL";
108 return fieldName +
'=' + v.toString();
113 return fieldName +
" IS NOT NULL";
114 return fieldName +
"<>" + v.toString();
122 return fieldName +
"='" + v.toString() +
'\'';
124 return fieldName +
"<>'" + v.toString() +
'\'';
144 mWidget->setEnabled( enabled );
155 onValuesChanged( QVariantList() <<
value );
158void QgsRelationReferenceSearchWidgetWrapper::onValuesChanged(
const QVariantList &values )
160 if ( values.isEmpty() )
169 const QVariant
value = values.at( 0 );
183 if ( exp == nullValue )
189 str = QStringLiteral(
"%1 = '%3'" )
191 exp.replace(
'\'', QLatin1String(
"''" ) )
204 mWidget = qobject_cast<QgsRelationReferenceWidget *>( editor );
216 const bool fetchLimitActive =
config( QStringLiteral(
"FetchLimitActive" ),
QgsSettings().
value( QStringLiteral(
"maxEntriesRelationWidget" ), 100,
QgsSettings::Gui ).toInt() > 0 ).toBool();
217 if ( fetchLimitActive )
222 if (
config( QStringLiteral(
"FilterFields" ), QVariant() ).isValid() )
233 mWidget->
setRelation( relation,
config( QStringLiteral(
"AllowNULL" ) ).toBool() );
static QString nullRepresentation()
Returns the string used to represent the value NULL throughout QGIS.
static QString quotedColumnRef(QString name)
Returns a quoted column reference (in double quotes)
QgsField at(int i) const
Returns the field at particular index (must be in range 0..N-1).
Map canvas is a class for displaying all GIS data types on a canvas.
QgsRelationManager * relationManager
static QgsProject * instance()
Returns the QgsProject singleton instance.
Q_INVOKABLE QgsRelation relation(const QString &id) const
Gets access to a relation by its id.
Represents a relationship between two vector layers.
QList< QgsRelation::FieldPair > fieldPairs() const
Returns the field pairs which form this relation The first element of each pair are the field names o...
This class is a composition of two QSettings instances:
static bool isNull(const QVariant &variant, bool silenceNullWarnings=false)
Returns true if the specified variant should be considered a NULL value.
Represents a vector layer which manages a vector based data sets.
QList< QgsRelation > referencingRelations(int idx) const
Returns the layer's relations, where the foreign key is on this layer.