Hi ,
We have one requirement that need to fetch the data based on below conditions.
Case1 : in Job information portlet suppose if the manager or title will update with Past effective date with last modified>last run date Ex: Record updated Jun 4,2020 but effective from may 1,2020.
Case2 : In job information portlet any record will modified on past date but effective from current date.
Record updated on may 20,2020 but will be effective from Jun 6,2020.
please kindly suggest me a query to solve the above conditions.
Regards,
Abdul.