How to add Date scope on Target system in synchronization editor?

Any response on this is highly appreciated. Thanks!

What type of connector is it exactly? The database connector for the Microsoft SQL server?

yes, DB connector

If we talk about the Microsoft SQL Server, you may want to put this in your system filter (assuming that the date in UPDATEDATE is in UTC format).

UPDATEDATE >= DateAdd(day,-1,GETUTCDATE())

Hello!

I have the same question, but in my case I'm on One Identity Manager On Demand 9.2 and the connector is for Success Factor HR. Can you help me?

Thanks a lot,
Lucrezia

Hi Lucrezia,

in case of Success Factor HR you are talking about a SCIM connection?

regards,

   Tino

Hello Tino,

thanks for the answer.
Yes, we set up the connector on Starling.

Hi Lucrezia,

if the usage of revision counter in SCIM connector based on property meta.lastmodified is not a solution you may create a variable in your synchronization project, lets say the name is "yesterday", and the value is "2024-05-01". Having this in place you are able to create a scope filter (as "system filter") like this:

meta.lastmodified gt $yesterday$

This filter will be part of the URI getting the object list and is processed on server site.

To have always the right value on the variable you could create a scheduled process at table DPRSystemVariable and set the date string each day at 00:01 am.

regards,

   Tino

Hi Lucrezia,

if the usage of revision counter in SCIM connector based on property meta.lastmodified is not a solution you may create a variable in your synchronization project, lets say the name is "yesterday", and the value is "2024-05-01". Having this in place you are able to create a scope filter (as "system filter") like this:

meta.lastmodified gt $yesterday$

This filter will be part of the URI getting the object list and is processed on server site.

To have always the right value on the variable you could create a scheduled process at table DPRSystemVariable and set the date string each day at 00:01 am.

regards,

   Tino

Hello Tino

Great solution.
But what if, instead of setting the DPRSystemvariable by process change it into a scripted variable
Return DateTime.Today.AddDays(-1).ToString("yyyy-MM-dd HH:mm:ss"))

If haven't tried it but just an idea. Would this also work?

Regards,
Niels

Good point Niels. Should work as well.

Hi all,

the system filters in scope filter definition is not able to process scripts. The one and only chance is accessing variables.

Thank you everyone for the support. Just out of curiosity I tried the solution Niels suggested, but unfortunately, as Tino said, it didn't work.

I solved by using the DPRSystemVariable with a scheduled process that updates its value daily. 

Lucrezia