[Qgis-user] linking n to 1 data

Matthias Kuhn matthias at opengis.ch
Sun Jan 24 07:30:49 PST 2016


Hi,

There are a number of things to be done to properly support different
usecases:

*Join / Aggregate functions support in expressions*

Some sort of join possibility should be added to expressions (similar to
the get_feature function) and some aggregate functions. E.g.

    join( "otherlayer"."name", ',' ) RIGHT JOIN otherlayer ON
otherlayer."id" = this."fk"

to create a string like "A,B,C" from three linked entries with name A, B
and C.

Or

    average( "otherlayer"."population" ) RIGHT JOIN otherlayer ON
otherlayer."id" = this."fk"

etc...

*Relation support for print composer*

Create tables with information from related entries based on the current
atlas feature.

Other ideas? I'm sure there is a lot more to be done :-)

Matthias
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20160124/db5c6812/attachment.html>


More information about the Qgis-user mailing list