Hi, the Bookings[Room] contain EnumLIST is there a way can can query into a list?
(SELECT(Bookings[Rooms],AND([_THISROW].[Checkin]<=[Checkin],[_THISROW].[Checkout]>[Checkin]))
SELECT(Bookings[Rooms],AND([_THISROW].[Checkin]<[Checkout],[_THISROW].[Checkout]>=[Checkout]))
SELECT(Bookings[Rooms],AND([_THISROW].[Checkin]>=[Checkin],[_THISROW].[Checkout]<=[Checkout]))
SELECT(Bookings[Rooms],AND([_THISROW].[Checkin]<=[Checkin],[_THISROW].[Checkout]>=[Checkout]))
)
from the code above I got this as a result
instead I want out come as one list.
Please help
Solved! Go to Solution.
In your expression, that I allow myself to indent in order to add more readability:
SPLIT(
SELECT(Bookings[Rooms],
AND([_THISROW].[Checkin]<=[Checkin],
[_THISROW].[Checkout]>[Checkin]))
)
+ SPLIT(
SELECT(Bookings[Rooms],
AND([_THISROW].[Checkin]<[Checkout],
[_THISROW].[Checkout]>=[Checkout]))
)
+ SPLIT(
SELECT(Bookings[Rooms],
AND([_THISROW].[Checkin]>=[Checkin],
[_THISROW].[Checkout]<=[Checkout]))
)
+ SPLIT(
SELECT(Bookings[Rooms],
AND([_THISROW].[Checkin]<=[Checkin],
[_THISROW].[Checkout]>=[Checkout])))
)
There are various things that attract my attention. If you donโt mind, I would like to provide some corrections/improvements to it:
So, your expression would become:
SELECT(Bookings[Rooms],
OR(
AND([_THISROW].[Checkin]<=[Checkin],
[_THISROW].[Checkout]>[Checkin]
),
AND([_THISROW].[Checkin]<[Checkout],
[_THISROW].[Checkout]>=[Checkout]
),
AND([_THISROW].[Checkin]>=[Checkin],
[_THISROW].[Checkout]<=[Checkout]
),
AND([_THISROW].[Checkin]<=[Checkin],
[_THISROW].[Checkout]>=[Checkout]
)
)
)
For reference:
Here:
https://community.appsheet.com/search?q=merge%20enumlist
Can you change the category of your post into โQuestionsโ please ? It is more relevant.
Thank you ! This really help!
Thank you @Aurelien
I ended up using SPLIT() to each Select then Add them up later like this.
SPLIT(SELECT(Bookings[Rooms],AND([_THISROW].[Checkin]<=[Checkin],[_THISROW].[Checkout]>[Checkin])))+ SPLIT(SELECT(Bookings[Rooms],AND([_THISROW].[Checkin]<[Checkout],[_THISROW].[Checkout]>=[Checkout])))+ SPLIT(SELECT(Bookings[Rooms],AND([_THISROW].[Checkin]>=[Checkin],[_THISROW].[Checkout]<=[Checkout])))+ SPLIT(SELECT(Bookings[Rooms],AND([_THISROW].[Checkin]<=[Checkin],[_THISROW].[Checkout]>=[Checkout])))
)
In your expression, that I allow myself to indent in order to add more readability:
SPLIT(
SELECT(Bookings[Rooms],
AND([_THISROW].[Checkin]<=[Checkin],
[_THISROW].[Checkout]>[Checkin]))
)
+ SPLIT(
SELECT(Bookings[Rooms],
AND([_THISROW].[Checkin]<[Checkout],
[_THISROW].[Checkout]>=[Checkout]))
)
+ SPLIT(
SELECT(Bookings[Rooms],
AND([_THISROW].[Checkin]>=[Checkin],
[_THISROW].[Checkout]<=[Checkout]))
)
+ SPLIT(
SELECT(Bookings[Rooms],
AND([_THISROW].[Checkin]<=[Checkin],
[_THISROW].[Checkout]>=[Checkout])))
)
There are various things that attract my attention. If you donโt mind, I would like to provide some corrections/improvements to it:
So, your expression would become:
SELECT(Bookings[Rooms],
OR(
AND([_THISROW].[Checkin]<=[Checkin],
[_THISROW].[Checkout]>[Checkin]
),
AND([_THISROW].[Checkin]<[Checkout],
[_THISROW].[Checkout]>=[Checkout]
),
AND([_THISROW].[Checkin]>=[Checkin],
[_THISROW].[Checkout]<=[Checkout]
),
AND([_THISROW].[Checkin]<=[Checkin],
[_THISROW].[Checkout]>=[Checkout]
)
)
)
For reference:
User | Count |
---|---|
37 | |
26 | |
21 | |
19 | |
16 |