How to check duplicate value in list type field with 2 records which is linked to same parent record

[Sirisha Navudu2]

Hi ,

In my requirement i have a list type field in a custom table . So if user selects any one value same as the other record in list type multi selection , both linked to same parent record. How to find and notify/restrict update in this case.

please provide suggestions

Thanks in Advance

[shyamkumar VK]

@Sirisha Navudu2  , Can you please elaborate your requirement

in order to find duplicates and abort you need to use Before Insert BR 

query your child table with parent ID and if duplicates exists then use abort action and Abort the insertion

Regards,

Shyamkumar

[Sirisha Navudu2]

Hi Shyamkumar,

Since it is a list type field , and more than 1 child record , how to compare with each child record and find duplicate. could u help me with the code . or is there other way ,where we can restrict selection , using reference qualifier . how to give that in a reference qualifier . 

Regards,

Sirisha

[Sirisha Navudu2 · Accepted solution]

Hi ,found a solution for the above requirement using ArrayUtil.

Regards,

Sirisha