Hi everyone,
I am currently building a shift scheduling system and need to filter out users who are on vacation during a specific shift.
The standard logic to check for overlapping date ranges is:
Vacation Start <= Shift End AND Vacation End >= Shift Start.
The Challenge:
In the Data Scope / Filter UI, the vacation data is linked via a relation (urlaubs-fk). Because a user can have multiple vacations, this field returns an array of dates , not a single date.
I am trying to compare this array against a single date coming from the “Parent Popup Record” (the shift dates). The standard <= and >= operators don’t seem to work correctly when comparing an array to a single value.
My Approach / Question:
Is there a way in the NocoBase filter UI to use an “Exists” or “Any” logic? Basically, I want to say: “Filter records where AT LEAST ONE of the related vacation records matches the overlap condition”.
Or is the recommended approach to solve this using a Rollup/Formula field first?
Any advice or best practices would be highly appreciated!
