Bug report #21077
Form Value relation based on WFS layer
Status: | Closed | ||
---|---|---|---|
Priority: | Normal | ||
Assignee: | Alessandro Pasotti | ||
Category: | Web Services clients/WFS | ||
Affected QGIS version: | 3.5(master) | Regression?: | No |
Operating System: | Any | Easy fix?: | No |
Pull Request or Patch supplied: | Yes | Resolution: | fixed/implemented |
Crashes QGIS or corrupts data: | No | Copied to github as #: | 28895 |
Description
I´m trying to set up a form value relation using a connection based on WFS.
The problem is that the filter expression for field “elementer” in layer “v_greg_flader” : current_value('hovedelement_kode') = "hovedelement_kode" doesn’t return any values to the drop-down widget although there is matching values for “hovedelement_kode” in layer “d_basis_hovedelementer” for all possible values of the same field in Layer “d_basis_elementer”
• All layers are based on WFS
• Layer “v_greg_flader” is the main layer, which contains (among others) the fields “hovedelement_kode” and “element_kode”
• Layer “d_basis_hovedelementer” contains lookup values for field “hovedelement_kode” in layer “v_greg_flader”
• Layer “d_basis_hovedelementer” contains lookup values for field “element_kode” in layer “v_greg_flader”
• There is a 1:n relation between “d_basis_hovedelementer” and “d_basis_elementer” on common field “hovedelement_kode”
Can you help look into this problem. Attached is a project illustrating the problem.
Regards
Lene
Associated revisions
Fix WFS context fields variable
because the fields in the (spatialite) cached
iterator are not the same as the main iterator.
Fix #21077 - Form Value relation based on WFS layer (nothing to do with
value relations)
History
#1 Updated by Bo Thomsen almost 6 years ago
All version of QGIS 3.x is affected by this problem
#2 Updated by Alessandro Pasotti almost 6 years ago
- Operating System changed from Windows to Any
- Category changed from Forms to Web Services clients/WFS
- Status changed from Open to In Progress
- Affected QGIS version changed from 3.4.4 to 3.5(master)
#3 Updated by Alessandro Pasotti almost 6 years ago
- Pull Request or Patch supplied changed from No to Yes
PR https://github.com/qgis/QGIS/pull/8970 (it turned out that it has nothing to do with forms nor value relations)
#4 Updated by Alessandro Pasotti almost 6 years ago
- Status changed from In Progress to Closed
- % Done changed from 0 to 100
Applied in changeset qgis|38f05b597421975ed2b86b662ab21106cc3fd474.
#5 Updated by Giovanni Manghi almost 6 years ago
- Resolution set to fixed/implemented
#6 Updated by Bo Thomsen almost 6 years ago
Hey Alesandro -
It works as a charm in 3.5 :-)
Will the fix be backported to 3.4 (LTR) ??
#7 Updated by Alessandro Pasotti almost 6 years ago
Yes: see the "backport" tag in https://github.com/qgis/QGIS/pull/8970