Query Builder Statement Connectors

Use connectors to indicate the end of the final conditional statement and how to interpret multiple conditional statements:


Connector	Use
END	At the end of the last conditional statement.
AND	When you have more than one conditional statement and you want to select the record only if it meets the conditions in both statements.
OR	When you have more than one statement and you want to select the record if it meets either condition in either statement.

When you add the first conditional statement to the grid, Query Builder automatically inserts END as the connector. As you add conditional statements, AND is inserted in the previous statement and END is moved to the last statement. To change the connector, click the drop-down arrow and select an option from the list. The last conditional statement must have END as the connector.

Example 1: Using "AND" as your statement connector

Query Builder selects the record if the contact’s status is active AND the account’s revenues are greater than or equal to $10000.

This is how the grid on the Conditions tab appears for this example:


Not	(	Field	Operator	Value	Case Sens	)	And/Or
		Contact.Status	equal to	active	False		AND
		Contact.Account.Revenue	equal or greater than	10000	True		END

Example 2: Using Contact.Status "OR" as your statement connector

Query Builder selects the record if the contact’s status is active OR the account’s revenues are greater than or equal to $10000.

This is how the grid on the Conditions tab appears for this example:


Not	(	Field	Operator	Value	Case Sens	)	And/Or
		Contact.Status	equal to	active	False		OR
		Contact.Account.Revenue	equal or greater than	10000	True		END

Example 3: Using multiple conditional statements within parentheses

Query Builder selects the record if the contact’s status is active AND the account’s revenues are greater than or equal to $10000. The record is also selected if the contact’s status is active AND the revenue is less than or equal to $500.

This is how the grid on the Conditions tab appears for this example:


(	Field	Operator	Value	Case Sens	)	And/Or
	Contact.Status	equal to	active	False		AND
(	Contact.Account.Revenue	equal or greater than	10000	True		OR
	Contact.Account.Revenue	equal or less than	500	True	)	END

Example 4: Using multiple conditional statements including "NOT"

Query Builder selects the record if the contact’s status is NOT inactive AND the account’s revenues are greater than or equal to $10000. The record is also selected if the contact’s status is NOT inactive AND the revenue is less than or equal to $500.

This is how the grid on the Conditions tab appears for this example:


Not	(	Field	Operator	Value	Case Sens	)	And/Or
NOT		Contact.Status	equal to	inactive	False		AND
	(	Contact.Account.Revenue	equal or greater than	10000	True		OR
		Contact.Account.Revenue	equal or less than	500	True	)	END