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

[qgib]

Author Name: Andreas Neumann (@andreasneumann)
Original Redmine Issue: 16879

Redmine category:expressions
Assignee: Nyall Dawson

---

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.

[qgib]

Author Name: Andreas Neumann (@andreasneumann)

---

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

[qgib]

Author Name: Nyall Dawson (@nyalldawson)

---

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

---

• assigned_to_id was configured as Nyall Dawson

[qgib]

Author Name: Harrissou Santanna (@DelazJ)

---

related to #19924

[qgib]

Author Name: Nyall Dawson (@nyalldawson)

---

Applied in changeset 878ee5c.

---

• done_ratio was changed from 0 to 100
• status_id was changed from Open to Closed