Hi,
I have to list pages that have a custom field named date, which basically is a date as textstring.
I have two tables. One table should show all pages where the date in the field is larger than the current date (so all future entries). (custom_field="archivedate > <cms:date format='Y-m-d' />")
The other table should show all pages where the date in the field is smaller than the current date (so all past entries).
(custom_field="archivedate < <cms:date format='Y-m-d' />")
This all works fine.
However, I need to apply an additional rule to the table where all future entries are shown: That table should also show all pages, where a different custom field called status has the value "open", regardless of the date field.
I know I can use AND to pipe several custom field checks (with |), but there does not seem to be an OR operator?
I have to list pages that have a custom field named date, which basically is a date as textstring.
I have two tables. One table should show all pages where the date in the field is larger than the current date (so all future entries). (custom_field="archivedate > <cms:date format='Y-m-d' />")
The other table should show all pages where the date in the field is smaller than the current date (so all past entries).
(custom_field="archivedate < <cms:date format='Y-m-d' />")
This all works fine.
However, I need to apply an additional rule to the table where all future entries are shown: That table should also show all pages, where a different custom field called status has the value "open", regardless of the date field.
I know I can use AND to pipe several custom field checks (with |), but there does not seem to be an OR operator?