This must have been asked before but I cannot find it.
I would like to design the following search:
DATE > 1/1/16 AND
DATE < 12/31/16 AND
Type = Production AND
Project = Y OR X
I’m having issues figuring out how to incorporate the last line.
You could do all of that by using the ALL operator type.
But for the Project query, just do exactly what you have:
Project contains Y OR X
The Y OR X part goes into the field for the Project search rule.
It only works with simple searches though.
E.g. Movie Title contains Hunger OR Terminator
The OR must be in uppercase and only one word on either side of the OR.
That works, thanks! May I suggest that this gets documented in the Search Help Topic?
A feature request:
- The plus sign on the “All” line appends an And line to the bottom of the argument list
- The plus sign on each search row adds an OR line that expands the argument bubble; i.e. the horizontal lines that separate each line move down to accommodate the additional argument
OR (ha ha)
- The plus sign on the “Any” line appends an OR line
- The plus sign on each search row adds an AND line in the same way as above
Good idea. I just added it to the Search topic in the online user manual.
That control to configure the Search Rules is a built-in control and it functions the way it does. I can tell it to allow mixing and matching ANDs and ORs, but that also requires I support that at the “back-end”, which I don’t right now.
.
