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 connectorClosed

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

This is how the grid on the Conditions tab will appear 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 connectorClosed

Query Builder would select 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 will appear 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 parenthesesClosed

Query Builder would select the record if the contact’s status is active AND the account’s revenues are greater than or equal to $10000. The record would also be 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 will appear 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   OR
    Contact.Account.Revenue equal or less than 500 True ) END

Example 4: Using multiple conditional statements including "NOT"Closed

Query Builder would select the record if the contact’s status is NOT inactive AND the account’s revenues are greater than or equal to $10000. The record would also be 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 will appear 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

Related Topics

Adding and Editing Conditions

 

 

What's New in this Release

 

For a list of new features, see the What's New In This Release topic.

Contact us:

This documentation was developed by Infor CRM User Assistance. For content revisions, questions, or comments, contact the Infor CRM writers at documentation@infor.com.