What is wrong with this Session Relevance

Content Authoring
1

I am trying to pull some action info based on the start date & end date of action but start date is creating problem, whenever I am removing start date from filter its generating record.

Not Working - bes actions whose ((state of it ="Expired" as string) AND (start date of it >= "04 apr 2020" as date) AND (end date of it <= "15 apr 2020"))

Working - bes actions whose ((state of it ="Expired" as string) AND (end date of it <= "15 apr 2020" as date))

I have tested them with session relevance & restAPI call both are showing same results.

2

Actions are not required to have start times nor end times… so you are probably hitting an existence issue.
Suggest:

bes actions whose ((state of it ="Expired" as string) AND ((start date of it >= "04 apr 2020" as date) | (not exists start date of it)) AND ((end date of it <= "15 apr 2020") | (not exists end date of it)))

2 Likes