• State Not Answered
  • Locked Locked
  • Replies 1 reply
  • Subscribers 94 subscribers
  • Views 2817 views
  • Users 0 members are here
Options
Related
This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

Filtering scope in Synchronization Editor

MChernyshev
over 5 years ago

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?

Parents
  • 0 over 5 years ago

    Hello,

    sounds like a database on the other end. How about "sysdate < End_Date" as system filter? If possible you should prefer system filters over object filters. When using system filters the filtering is done by the connected system. When using object filters filtering is done after loading all data.

Reply
  • 0 over 5 years ago

    Hello,

    sounds like a database on the other end. How about "sysdate < End_Date" as system filter? If possible you should prefer system filters over object filters. When using system filters the filtering is done by the connected system. When using object filters filtering is done after loading all data.

Children
No Data