[midPoint] Code based resource delineation filter

[King, Robert]

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?
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.evolveum.com/pipermail/midpoint/attachments/20240226/ff92efcb/attachment.htm>