[Solved] Code to check for duplicates in database and only displaying the newest on repeater (based on updated date)

Ask the community
,
15

Have you considered using a hook? Specifically the Before Insert hook would allow you to get in there and flag the records already in the collection with the same CopyOwner and Location values before inserting the new record.

Of course, this would require you to first manually run a one-time routine on the collection to flag the “old records” to get it up-to-date. Make sense?