Hello. Can you explain one thing with IDM? We have a table Assignment in OEBS. There are 20000 records. Some of employees have several similar records like the example below:
ID START_DATE END_DATE
210152 49512 147991 49512-2 20387 25451 60 320 Y N N N N 09.08.16 31.01.17
210152 49512 147991 49512-2 20387 25451 60 320 Y N N N N 01.02.17 31.12.18
We'd like to modify scope in synchronization manager with object filter ''Current_date < END_DATE" (Current_date is our custom property with constant type "Current date UTC") to remove all records with expired date. And it works for simple records, but similar records like above are not filtered. In Browse we can see them. The question is how can we filter these similar records?