I'd like to create a query where some filter parameters (coming from the request token) are optional.
E.g. what I'd like to do:
- List pages with creation date less then the request parameter "endDate"
- If there is no "endDate" parameter, list all pages
Now the first one is simple and works (a content type filter and a tokenized filter on CreationDate in a single group), but if there is no parameter present, nothing is displayed. Actually I get an ADOException "The conversion of a varchar data type
to a datetime data type resulted in an out-of-range value." from ProjectionManager ln 109. I guess this is because the inserted date is 2999-12-31 22:59:59...
Adding an additional group that would just fetch all the pages doesn't help.
Is this possible without separate queries for the two scenarios? Thanks in advance.