Feature request #15461

Relation reference widget: introduce unique constraint

Added by Andreas Neumann 7 months ago.

Status:Open Start Date:08/19/2016
Priority:Normal Due date:
Assigned to:Matthias Kuhn % Done:

0%

Category:Edit widget
Target version:Future Release - High Priority
Platform: Resolution:
Platform version: Pull Request or Patch supplied:No
Status info: Tag:

Description

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

Also available in: Atom