Report Wizard Parameter Fields Tab


If a parameters tab includes a search field, then you can use special search characters here.


Search Type Special Character Example Search Example Results 
ANDspaceFred SmithMatch if a field contains both words in any order. Acts like AND. This search phrase is true for both Fred Smith and Smith Fred.
ORpipeFred | SmithMatch if a field contains either word. Acts like OR. This search phrase is true for Fred or Smith.
AND ORspaces and pipeFred Smith | Mary JonesMatch if a field contains both Fred and Smith in any order or if the field contains both Mary and Jones in any order.
Exact Phrasedouble quotes"Fred Smith" (not usable everywhere)

Search for the exact enclosed phrase. This search phrase is true for Fred Smith, but not for Smith Fred. Everything inside double quotes is taken literally. So "|" would search for a pipe. There is no way to search for double quotes.

This syntax is not supported everywhere in Projector.

Wildcardunderscore or question markFred_Smith 
Fred?Smith
A single wild character. This would match for Fred Smith, but also matches FredQSmith.
Multiple Wildcardpercent or asterix

Fred%Smith
Fred*Smith

Multiple wild characters. This would match for FredSmithFred SmithFredQSmith and Fred Jonathan Smith.