Hi team,
we have a requirement to enter a multiple Account Numbers from a Editable grid. but has to validate the entry when there is a duplicate row.
I have tried using contains function but not able to solve. please help
Discussion posts and replies are publicly visible
What exactly does "duplicate" mean for you?
What did you try with the contains function?
If there is same account number entry in the grid for two rows, the validations has to throw duplicate entry
contains(ri!accountList,fv!item), the current item value in the row
There are a few options to implement this.
In general, for a given row, you want to check whether the same value is used in the OTHER rows. So a validation could be like:
contains(remove(ri!accountList.accountNumber, fv!index), fv!row.accountNumber)
This is probably not exactly working code, but it shows how to implement the described idea.