Parentheses group filter criteria statements and provide the structure necessary to perform complex queries. Parentheses are necessary only if both of the following conditions apply:

  1. The query includes three or more filter criteria statements.
  2. The query uses both AND and OR operators to link criteria statements

    Note: Parentheses are located at the bottom of the query along with AND and OR operators. Except for ALTRU, parentheses are located above the "Include Records Where" box. 
Example QueryWhich conditions for ( ) apply?
Constituents who've given a gift of $500
or more to the Capital Campaign
Gift Amount greater than or equal to $500
AND Campaign Description equals Capital Campaign
Neither
South Carolina constituents who either have a constituent code of Board Member or a gift amount of at least $1000State equals South Carolina

AND (Constituency Code equals Board Member
OR Gift Amount greater than or equal to $1,000)
Both


( ) are necessary
1099 vendors with invoices greater than $6001099 Vendor equals Yes

AND Invoice amount greater than $600
Neither
Georgia 1099 vendors with invoices greater than $6001099 Vendor equals Yes

AND State/Province equals Georgia
AND Invoice amount greater than $600
First only
1099 vendors with invoices greater than $600 or total of invoices over $10001099 Vendor equals Yes
AND
(Invoice amount greater than $600 OR Total invoice amount* greater than $1000)
 
Both


( ) are necessary
Current students who are offspring of alum or attended a specific schoolCurrent status equals Current Student

AND (Parent is alum equals Yes OR Education School name equals Lowcountry Day School)
 
Both


( ) are necessary

Note: Be careful when placing your parenthesis in the query. Changing the location of the parenthesis changes the record selection. For example, if we use the queries above where parenthesis were required and then change the location of the parenthesis, the query results also change:

Original Results Original QueryNew QueryNew Results
South Carolina constituents who either have a constituent code of Board Member or a gift amount of at least $1000State equals South Carolina AND (Constituency Code equals Board Member OR Gift Amount greater than or equal to $1,000)( State equals South Carolina AND Constituency Code equals Board Member ) OR Gift Amount greater than or equal to $1,000South Carolina constituents who are also Board Members or any constituent with a gift amount of at least $1000
1099 vendors with invoices greater than $600 or total of invoices over $10001099 Vendor equals Yes AND (Invoice amount greater than $600 OR Total invoice amount* greater than $1000)
 
( 1099 Vendor equals Yes AND
Invoice amount greater than $600 ) OR Total invoice amount* greater than $1000
1099 vendors with invoices greater than $600 or any vendor with total of invoices over $1000
Current students who are offspring of alum or attended a specific schoolCurrent status equals Current Student AND (Parent is alum equals Yes OR Education School name equals Lowcountry Day School)
 
(Current status equals Current Student AND
Parent is alum equals Yes ) OR Education School name equals Lowcountry Day School
Current students who are offspring of an alum or any student that attended a specific school

*Note: Finding the total of multiple invoices requires using summary fields (BB132446).