Re: [Qgis-user] Using expression dialog to access attributes from a relation.
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.gi...@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@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] Using expression dialog to access attributes from a relation.
Yeah, You can do this with the relation_aggregate function. It aggregates values from all related records using a field or expression. Ive only used the "concatenate" aggregate for returning strings from the related table but there are other options if you want to return an average, sum, string length, etc. I think the help covers the use pretty well, but if you run into trouble I can give more specific help, Andrew ‐‐‐ Original Message ‐‐‐ On Thursday, December 13, 2018 8:11 AM, Andrew Bell wrote: > 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@lists.osgeo.org List info: https://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
[Qgis-user] Using expression dialog to access attributes from a relation.
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@lists.osgeo.org List info: https://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
