Report Wizard Parameter Fields Tab

Report Wizard Parameter Fields Tab

 

Search

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

 

Search Type 

Special Character 

Example Search 

Example Results 

AND

space

Fred Smith

Match if a field contains both words in any order. Acts like AND. This search phrase is true for both Fred Smith and Smith Fred.

OR

pipe

Fred | Smith

Match if a field contains either word. Acts like OR. This search phrase is true for Fred or Smith.

AND OR

spaces and pipe

Fred Smith | Mary Jones

Match if a field contains both Fred and Smith in any order or if the field contains both Mary and Jones in any order.

Exact Phrase

double 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.

Wildcard

underscore or question mark

Fred_Smith 
Fred?Smith

A single wild character. This would match for Fred Smith, but also matches FredQSmith.

Multiple Wildcard

percent or asterix

Fred%Smith
Fred*Smith

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