Hello everyone,
I have two custom tables that have 1:N relationships as the below example:
What I want to achieve is below:
I want to create a fetch XML query that will detect the duplicates by the above ID column provided on the line-items table and filter based on the old creation date.
That means based on the above example provided, the fetchxml query should only return the record that has been created on "3/24/2022 10:00 PM".
The aim of this query is to bulk delete all the duplicates based on the above condition so the ID will not be static because I have thousands of rows that are duplicates.
Could you please provide an example and a solution to achieve the above requirements?
Any help is highly appreciated.
Best regards,
EBMRay