Feature request #6361
Edit widget “Unique values”
| Status: | Open | ||
|---|---|---|---|
| Priority: | Normal | ||
| Assignee: | - | ||
| Category: | Edit widget | ||
| Pull Request or Patch supplied: | No | Resolution: | |
| Easy fix?: | No | Copied to github as #: | 15629 |
Description
There is a possibility in the layer properties window, Fields tab to define Edit widgets. One of them is just opposite what the name suggest – “Unique values”. In most DBMS unique is UNIQUE – no duplication is allowed. The name of this widget should be changed.
By the way – there is also a widget “UUID generator”. Funny! UUID means Universally Unique IDentifier.
History
#1
Updated by zirneklitis - over 11 years ago
May be “_Value Collection_” is more appropriate name for the given widget.
#2
Updated by Nathan Woodrow over 11 years ago
zirneklitis - wrote:
In most DBMS unique is UNIQUE – no duplication is allowed
This is what happens. If you are using a database based provider for a layer it will do a GROUP BY to return the unique values for that column. I have never had it return a item more then once.
Funny! UUID means Universally Unique IDentifier.
Not sure what the issue is. The widget is a Universally Unique Identifier generator.
#3
Updated by zirneklitis - over 11 years ago
The problematic name is for widget “Unique values”. The “UUID generator” was mentioned to point to the quite opposite use of the word “unique” into the same window. The “UUID generator” works as expected. No the same with “Unique values”.
When the widget “Unique values” is chosen with editable option on, any value could be entered. Look at the example of entered values:
id,N,10,0 kods,C,3
1 AAA
2 AAB
1 AAC
4 AAA
1 AAA
4 AAC
4 AAC
As You can see, there is no uniqueness.
When the widget “Unique values” is chosen with editable option off, only existing values could be chosen.
#4
Updated by Paolo Cavallini almost 10 years ago
- Category set to Edit widget
#5
Updated by Giovanni Manghi almost 7 years ago
- Easy fix? set to No