Bug report #22062

value relation widget - drive down lists, wrong saved values

Added by jose macau over 5 years ago. Updated over 5 years ago.

Status:Open
Priority:Normal
Assignee:-
Category:Edit widget
Affected QGIS version:3.6.2 Regression?:No
Operating System: Easy fix?:No
Pull Request or Patch supplied:No Resolution:
Crashes QGIS or corrupts data:No Copied to github as #:29876

Description

using the example here https://www.northrivergeographic.com/archives/qgis-3-2-drive-down-lists-aka-value-relation-widget
with filter expression:

“fk” = current_value(‘type’)

the drive down list is correct, according type and subtype auxiliary tables.

but when the user submits a new feature to the point layer, the results in table are allways the same (the first subtype), like this:

fid type subtype
1 1 1
2 1 1
3 2 1
4 2 1
5 2 1
X X 1

History

#1 Updated by Giovanni Manghi over 5 years ago

  • Resolution deleted (fixed/implemented)
  • Category changed from Editing to Edit widget
  • Subject changed from value relation widget - drive down lists to value relation widget - drive down lists, wrong saved values

#2 Updated by jose macau over 5 years ago

found!

the problem happens only if the primary key field is used as the "key column" in configuration widget

Also available in: Atom PDF