Feature request #16879

Expression editor: add a list of available relations and tables in the project

Added by Andreas Neumann 4 months ago. Updated 4 months ago.

Status:Closed
Priority:Normal
Assignee:Nyall Dawson
Category:Expressions
Pull Request or Patch supplied:No Resolution:
Easy fix?:No

Description

It would be good if the epxression editor could show a list of:

a) relations (group could be called "Relations")

b) other tables (group could be called "Tables")

Just like the "Fields and values" group, it would be a list of existing relations and tables.

Otherwise it is a bit complicated spelling relation names and table names correctly.

The relation_aggregate expression and the get_feature function would be much easier to use with this enhancement. I would also assume that in the future, there will be more expression functions that make use of other tables and relations.

Associated revisions

Revision 878ee5c0
Added by Nyall Dawson 4 months ago

Add items for project map layers and relations to expression builder

Allows easy insertion of map layer IDs and relation IDs into
expressions. Numerous expression functions now utilise these,
so it makes sense to allow them to be easily inserted.

Fix #11680, #16879

Sponsored by Andreas Neumann

Revision ae806ad1
Added by Nyall Dawson about 2 months ago

Add items for project map layers and relations to expression builder

Allows easy insertion of map layer IDs and relation IDs into
expressions. Numerous expression functions now utilise these,
so it makes sense to allow them to be easily inserted.

Fix #11680, #16879

Sponsored by Andreas Neumann

History

#1 Updated by Andreas Neumann 4 months ago

The relation names and table names should be copied with single quotes around them, to be useable in the expressions.

#2 Updated by Nyall Dawson 4 months ago

  • Assignee set to Nyall Dawson

I'll tackle this - I'd also find this very useful.

#3 Updated by Harrissou Santanna 4 months ago

related to #11680

#4 Updated by Nyall Dawson 4 months ago

  • % Done changed from 0 to 100
  • Status changed from Open to Closed

Also available in: Atom PDF