Duplicate list values in Agile 9.3.5
Will Agile allow duplicate list values?
I have created a list which has around 10k values. I uploaded the values and took care that there is no duplicate. Now I see that there are many values which are duplicated. Is it a bug in Agile.
The schema does not prevent duplicate values in the table, as the index is on the parent list ID, the ID (and not the text) of the list value itself and on the language ID. Are you seeing the duplicates when you try to select a value for the attribute? Or when you view the list itself? Note that since Agile allows multiple languages to be used, each one has a distinct value since whatever the string value is would/could be different in each language.
When you manually enter the list values using the Java client, it does check whether you are entering any duplicate values. How did you upload the list of values? Are some of them “deleted”, as those would not be visible to users anyway.
So you see duplicate values when you are trying to select a value for the attribute from the drop-down list. Do you see them when you check on the list in the Java client?
Look at the database, and see if they actually exist. It is possible that some have a trailing blank or something like that, making them not really a duplicate (although it certainly looks like it). In the Java client, find the list parent ID for the attribute. Then execute the following query :
select entryid, ‘<‘ || entryvalue || ‘>’, langid, active from listentry where parentid = <the value you found> order by entryvalue, langid, active;
This should show you if there really are duplicate values. Note that ACTIVE tells you the status of the value itself – 0 = enabled, 1 = disabled (cannot be selected), 2 = deleted (cannot be seen). You can then set the “duplicate” ones as either disabled or deleted in the Java client (open the list itself, and modify as needed), and things should be good. I would recommend setting them as deleted.