[Qgis-user] 1 to many relationship does not allow to display the many

[Janneke van Dijk]

Hi Harrissou,
Thanks for the quick response - indeed, I indicated the assetid which is 
a unique value. That did not solve the problem, alas...
Janneke

On 19/09/2019 17:31, DelazJ wrote:
> Hi Janneke,
>
> Maybe you need a field that would uniquely identify the 170 asset rows 
> (their primary key). You can use an ID field of your asset layer or 
> construct one with row_number function?
>
>
> Regards,
> Harrissou
>
> Le jeu. 19 sept. 2019 à 16:10, Janneke van Dijk 
> <janneke.qgis at gmail.com <mailto:janneke.qgis at gmail.com>> a écrit :
>
>     Dear list,
>
>     I have a parent - child relationship set up between a table
>     location (1,
>     the parent) and a table assets (many, the child). The location table
>     contains geometry, the asset table does not. I would like to be
>     able to
>     display each record in the asset table with the corresponding
>     geometry
>     of the location table - so if there are 3 assets at a certain
>     location,
>     I would like to display 3 points (each with identical geometry).
>
>     What I can do with the DB manager is:
>
>     select location_point.geom, asset_point.assetid, location_point.fid
>     from asset_point cross join location_point on
>     asset_point.locationid =
>     location_point.fid
>
>     this query yields 170 records, corresponding with the number of
>     records
>     in the assets table. When I load as a new layer, the result is a
>     table
>     with 170 records, but 100 filtered (the total number of locations). I
>     chose assetid to be the unique id (which it is).
>
>     Is that expected behaviour? How else can I display all the records in
>     the assets table (instead of only the 100 that are filtered now)?
>     I know
>     I can do it in Postgres but for my purpose now I don't want to go
>     there.
>
>     Any insights deeply appreciated!
>
>     Janneke
>
>
>     _______________________________________________
>     Qgis-user mailing list
>     Qgis-user at lists.osgeo.org <mailto: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
>

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