Feature request #15461

Relation reference widget: introduce unique constraint

Added by Andreas Neumann about 7 years ago. Updated about 6 years ago.

Assignee:Matthias Kuhn
Category:Edit widget
Pull Request or Patch supplied:No Resolution:fixed/implemented
Easy fix?:No Copied to github as #:23387


In the relation reference widget it is possible to add new values without having to open the linked table first (comfortable).

We would, however, like to have a unique constraint on the "display expression"/"display column" to avoid double entries.

We need to discuss several options how to achieve this:

a) having a separate "value list manager" that takes care of it, but can also handle other stuff, like renaming/deleting values

b) Using the existing QGIS constraint mechanism (haven't found a way to check a newly entered value against other already existing values in the table though)

c) introducing a new "built in" Unique constraint on a table column


#1 Updated by Regis Haubourg over 6 years ago

Hi Andreas and Matthias. This seems done in master. Should we close the issue?

#2 Updated by Giovanni Manghi over 6 years ago

  • Easy fix? set to No

#3 Updated by Andreas Neumann about 6 years ago

  • Resolution set to fixed/implemented
  • Status changed from Open to Closed
  • Description updated (diff)

closing this, because it is implemented in QGIS 3.x

Also available in: Atom PDF