Questions tagged [relation]
The relation tag has no usage guidance.
22
questions with no upvoted or accepted answers
6
votes
0
answers
273
views
QGIS N:M relations - possibility to edit multiple features?
I have a working QGIS project with multiple relations and all is well until I try the Toggle multi edit mode for N:M relations. I'm working with QGIS 3.10+ (3.14.16) and Windows and PostGIS.
Is it ...
3
votes
0
answers
79
views
Using get_feature() function on layer while editing in QGIS
In QGIS, I am trying to update a feature based on entries made on a nested form (relation).
Considering:
Layer1 has Field1 that should capture the value of Field 2, and field in Layer2
Layer2 is ...
2
votes
0
answers
77
views
QGIS Layer field expression in Polymorphic Relation evaluates to NULL
In QGIS 3.34.3, according to the doc:
Layer expression evaluates to a unique identifier of the layer. This can be the layer name @layer_name, the layer id @layer_id, the layer’s table name decode_uri(...
2
votes
0
answers
32
views
QGIS not showing cascading relations in identify
I have 3 tables that are related as shown in figure below:
I added two relaltions. The first one between Table1 and Table2 and the other one between Table2 and Table3 as shown in figure below:
On ...
2
votes
0
answers
32
views
Displaying more than 100 entries in Relation Reference Widget dropdown in QGIS
I am using QGIS 3.28, and I've encountered an issue with the Relation Reference Widget. In the form view, the dropdown menu of the Relation Reference Widget only displays 100 entries.
Is there a way ...
2
votes
0
answers
98
views
QGIS Relation reference widget performance
I have a relation 1:1 on a table with limited parcels (ca 2000 rows) related to huge table on national level (ca 22 million rows), PostgreSQL 14 with PostGIS. Smaller table is used with view to show ...
2
votes
0
answers
194
views
How to list relationed objects on QGIS expression for HTML tips
I have two layers with an 1-N relationship
The parent layer, "RADAR" is a point layer, while the child layer, "FAIXA_RADAR" is a tabular without geometry layer.
To make feature ...
2
votes
0
answers
75
views
QGIS Hidden attributes not hidden in Relations
I have a PostGIS view, which a referencing layer for another layer for many to one relation in QGIS. I have hidden the following fields id, table_name, oid of the postgis view so that the user would ...
1
vote
0
answers
72
views
How to set up a filter in a value relation of a child of a parent-layer depending on attributes in parent layer
I have a 1:n relation between (postgresql-) parent-layer "parentlayer" and a child-layer "childlayer" based on parent-layer-field "pl_uuid" referencing child-layer-field &...
1
vote
0
answers
55
views
QGIS values from 1:n related table to parent attribute table
I'm confused since I don't really get the difference between a form and a table in QGIS. I've successfully created multiple one to many relations between my parent shapefile and child excel sheets ...
1
vote
0
answers
50
views
QGIS: Update parent attribute based on most recent child
To describe the situation, I have parent geopackage layer for 'Trees' which is related to a child geopackage table 'tree_inspections'. So each tree can have many inspections. I use a foreign key '...
1
vote
0
answers
41
views
QGIS: Value relation forms
Is it possible to set default value to parent, based on child entry? I know how to do it from parent to child, but I want to do it in reverse. I have two CSV files with values. First I want to edit ...
1
vote
1
answer
82
views
QGIS relation reference widget shows an empty list instead of values
I'm trying to set up a QField project to entry data from a bird watch project.
I have a few layers which I would like to connect with the ID of the tour.
I am using relation reference widgets.
The ...
1
vote
0
answers
108
views
Merging queries to return ways/nodes that are within relations matching criteria using Overpass API
Motivation - I am currently processing a number of relations matching criteria and then doing an additional query to get all the ways/nodes within those relations. .
Goal - I'm trying to simplify this ...
1
vote
1
answer
29
views
Show selection of point in relation of a vector field?
I have two files,
vector "streets"
a series of point "civic numers" or "address"
I want to select a random street and have the field selection of the relative civic ...