Assigning Query Conditions

When you add a field to the Query Builder Conditions tab, the Assign Condition dialog box appears for that field.

To assign

  1. Open Query Builder.
  2. Click the Conditions tab
  3. Add a condition statement.

The Assign Condition dialog box opens.

  1. Select an Operator.
  2. In the Value Is box, enter a value or click Browse to select a value.

If you selected "In" as an operator, the values must have quotation marks around each entry.

  1. Select Case Sensitive Compare to use capitalization as part of the condition.

If you are using Microsoft SQL Server, the Case Sensitive Compare option is not applicable. All queries are case insensitive.

  1. If necessary, select Use Value as a Literal.
  2. Click OK.

Related Topics

Query Builder Overview

Query Builder 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.