Feature request #16040

Filter relation reference widget by expressions

Added by Regis Haubourg 5 months ago. Updated 5 months ago.

Status:Closed
Priority:Normal
Assignee:-
Category:Forms
Pull Request or Patch supplied:No Resolution:
Easy fix?:No

Description

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


Related issues

Related to QGIS Application - Bug report #10900: python filter expression don't work on "value relation" Closed 07/16/2014

History

#1 Updated by Regis Haubourg 5 months ago

For the record, it is possible in value relation widget . See #10900
but that one can not allow user to click on a map object.

#2 Updated by Matthias Kuhn 5 months 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.

#3 Updated by Regis Haubourg 5 months ago

  • Status changed from Open to Closed

Good idea Matthias, this is much more elegant.
I open a dedicated feature request.

Also available in: Atom PDF