[midPoint] Code based resource delineation filter

[Gustavo J Gallardo]

Hi Robert,
I assume your Oracle table has DATE columns for 'start date' and 'end date'.
Maybe I'm missing something obvious, but I would create a view and resolve
the 'start time'<=SYSDATE and 'end time'>=SYSDATE in that view.


Regards,

Gustavo

On Mon, Feb 26, 2024 at 2:00 PM King, Robert via midPoint <
midpoint at lists.evolveum.com> wrote:

> I am attempting to use a database table connector to import an
> organization into midPoint.  The database is an Oracle backend.  The
> records in the database are roughly this:
>
>
>
> [ ID ][ org code ][ title ][ start date ][ end date ][ parent org code ]
>
>
>
> I want to filter out all of the records where the start and end dates are
> invalid.
>
>
>
> I have tried using activation status and lifecycle state to remove
> entries.  Neither of these approaches have worked.  They do not prevent
> entries from populating the organization tree.  I think the only method I
> have left is to use resource connector delineation filtering.
>
>
>
> The problem I am currently struggling with, is how to do a comparison
> between end date and the current time.  Has anyone had any experience with
> delineation filtering using point in time dates?
> _______________________________________________
> midPoint mailing list
> midPoint at lists.evolveum.com
> https://lists.evolveum.com/mailman/listinfo/midpoint
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.evolveum.com/pipermail/midpoint/attachments/20240226/28d0fd08/attachment-0001.htm>