Data Scope Condition Group by "Meet 'No' conditions in the group"

English Forum Feature Request
1

I’m faced by a problem I’m struggling to solve with the Data Scope editor.
Essentially a booking system to show available assets for a given date range.
I need to show a list of records (Assets) whose relation’s (Booking) Start and End dates fall outside a date range (New Booking Start/End).

As the Data Scope only has Any & All condition groups, if one of the records relations passes the conditions then the list is showing the Asset as available.
With a “Meet No conditions in the group”, I can easily do conditions that exclude booked assets. IE an Asset will only be shown if no related Booking overlaps the New Booking dates.

As this query is dependant on the New Bookings Start/End dates, I don’t think I can work around this with an SQL Collection or a database view

2

Currently, there isn’t a great fit for scenarios like “booking by time range.”

3

Hey, thanks for getting back to me.
The more I think about it, it does seem like a problem for a “not in” subquery type thing. Which I can see being very difficult to implement in a UI.
I’ll have a think, and see if I can get some sort of horrible hack with a database view and some generated date series or something crazy.