Feature request #16879

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

Added by Andreas Neumann over 7 years ago. Updated over 7 years ago.

Status:Closed
Priority:Normal
Assignee:Nyall Dawson
Category:Expressions
Pull Request or Patch supplied:No Resolution:
Easy fix?:No Copied to github as #:24778

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 over 7 years 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 7 years 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 over 7 years 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 over 7 years ago

  • Assignee set to Nyall Dawson

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

#3 Updated by Harrissou Santanna over 7 years ago

related to #11680

#4 Updated by Nyall Dawson over 7 years ago

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

Also available in: Atom PDF