Allow user to select from unique field values when building expressions (filter tool, etc)

[michael_team]

When building an expression (e.g. [Store Type] in ("Supermarket", "C-Store", "Gas Station") ) when the user selects the field variable, provide all the unique values in that field so user can double-click and add them to the expression, without having to look and see what values are in the table, what data type (shows quotes if string) and manually type the values, which can lead to errors.

This functionality is currently available in GIS programs such as ArcGIS and Quantum GIS (QGIS).

[sphwillis]

Yes - like in ESRI too. so much easier especially when values have trailing/leading spaces!

[RachelW]

This is possible with the new expression editor with autocomplete text in Formula and Filter. We plan to add the new expression editor to more tools next year.