defect Duplicate rows in user selection on ICF from simplelist

[Berto2002]

User sees this when selecting from simplelist in portal: two occurrences of the same row

Simplelist only has one for that item:

Have seen this before but never reported so I don't think this is a new defect

Both must work since we don't get them failing to select.

[James Ainsworth]

Hi Berto,

Thanks for your post.

So far we have not been able to replicate your issue.  Are you able to look at the h_sys_lists table to see if a duplicate for this item exists there?

[Berto2002]

In a cruel twist of timing yesterday we had a change to remove that item from the list...

However, with the query

SELECT * FROM h_sys_lists
where h_listname = "Software non-LOB" AND h_name LIKE "Avaya%"

We do see two rows, one with a h_language and one without:

Is that expected when the list only has one entry:

For "adobe% it is even more pronounced and we have 3 rows in DB for each real row in the Simplelist in most cases:

As we have lost the original case I guess my question is whether what we are seeing in the DB with multiple rows for Simplelists is expected behaviour?