Feature request #16040
Filter relation reference widget by expressions
|Pull Request or Patch supplied:||No||Resolution:|
|Easy fix?:||No||Copied to github as #:||23955|
Relation reference widget does not allow to spatially filter potential related features. (that widget [[https://issues.qgis.org/attachments/9427/emeded_form_relationreferenz.jpg]] )
Filtering by expression instead of simple fields would allow to call functions such as
intersects( $geometry , geomFromWKT( $current_canvas_extent ))
That would allow a dropdown list reduced to a few neighbouring features. Currently it loads the whole layer, and can kill QGIS.
a native checkbox to filter by canvas would be also good for average users
#2 Updated by Matthias Kuhn over 4 years ago
I would propose to solve this on a broader perspective (i.e. not only for the relation reference widget) and introduce a new "search feature(s)" widget that allows for searching features based on attributes or location. This widget would be opened with a separate button (like the select from canvas button now).
The combobox on the other hand shouldn't load all the options (if there are more than ~100 there is no longer any point in doing so) but have an autocompleter that works with requests on the data source and proposes matches based on this.
#4 Updated by Regis Haubourg about 4 years ago
- Status changed from Closed to Open
- Description updated (diff)
I reopen that feature request, because the alternate proposal - adding another button - does not seem so nice to me, it's a lot of new clicks. A dedicated search dialog could be interesting too by adding richer search possibilities (like the select by Value dialog for instance), but I would say it's the advanced use case.
My need for classical apps would only be to filter the dropdown list using expressions, and nearest neighbor / distance computation + a rubberband on hover synced between the combobox and the map canvas.