Hello everyone,
I have an interactive grid which read, write and delete in a collection (method : https://madwithapex.blogspot.com/2017/06/apex-collections-with-interactive-grid.html)
I would like to check if there are duplicate values in a column of this IG.
I created a validation on this interactive grid. The validation type is No rows returned, and always checked.
The query is :
SELECT
C001,
COUNT(*)
FROM
APEX_COLLECTIONS
WHERE
COLLECTION_NAME = 'COLLECTION_MEMBRES_PROJET'
GROUP BY
C001
HAVING
COUNT(*) > 1
Simple query.
I noticed that once I add a duplicate value, I can't even delete its line, nor add a new line with a new value.
How could I prevent adding duplicate values in this column (C001) ?
Thank you for your light