I have an entity, ace_job, with two date fields, ace_dateinprogress and ace_datecompleted.
I have thousands of records where the date value contained ace_dateinprogress comes after the date value contained in ace_datecompleted. This is obviously a problem because ace_dateinprogress should never hold a date that comes before ace_datecompleted.
I need to perform an advanced find in the Dynamics 365 UI to retrieve all the records where ace_dateinprogress > ace_datecompleted, so I know which records need to be cleaned up and corrected.
If I write the fetch xml outside of Dynamics 365 to retrieve these records I can do it as shown below.
<fetch mapping="logical" version="1.0">
<entity name="ace_job">
<all-attributes />
<filter>
<condition attribute="ace_dateinprogress" operator="gt" value="ace_datecompleted" />
</filter>
</entity>
</fetch>
My problem is that I need to do this inside of Dynamics 365 so I can bulk update the results. Unfortunately, there appears to be no way via advanced find to query "where Date in Progress > Date Completed"
Is there a way to choose Date in Progress > Date Completed in the filter?
