[Qgis-user] Using expression dialog to access attributes from a relation.

[Stefan Giese (WhereGroup)]

Hi Andrew,
you can use the relation_aggregate expression to concatenate the child 
items, something like:
relation_aggregate('my_relation','concatenate', "child_attribute", 
concatenator:=',')
just see the help for relation_aggregate in the expression builder.

bests regards
Stefan

---
Mit freundlichen Grüßen
Stefan Giese
Projektleiter/Consultant
***************************************************
Where2B Konferenz 2018
13. Dezember 2018 im Universitätsclub Bonn
Anmeldung & Infos: https://where2b-conference.com/
***************************************************
WhereGroup GmbH & Co. KG
Schwimmbadstr. 2
79100 Freiburg
Germany

Fon: +49 (0)761 / 519 102 - 61
Fax: +49 (0)761 / 519 102 - 11

stefan.giese at wheregroup.com
www.wheregroup.com
Amtsgericht Bonn, HRA 6788
-------------------------------
Komplementärin:
WhereGroup Verwaltungs GmbH
vertreten durch:
Olaf Knopp, Peter Stamm
-------------------------------

Am 2018-12-13 17:11, schrieb Andrew Bell:
> I have spatial layer and non-spatial layer set up as a relation QGIS
> 3.4.  The non-spatial layer is the child.
> 
> I'm trying create a display pop-up for the spatial layer that sources
> attributes and values from the relation layer.
> 
> I can see the relation is an option in the expression dialog but at
> the moment I cannot see how I'm going to bring through field names and
> values from this other table.
> 
> Has anyone done this and have any pointers they could share?
> 
> Many thanks
> 
> Andrew
> _______________________________________________
> Qgis-user mailing list
> Qgis-user at lists.osgeo.org
> List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user