CNFS IQ - How to Add, Edit, or Remove a Condition

Adding a Condition

Editing a Condition

Removing a Condition

-

Adding a Condition

The Query Conditions panel is where you specify conditions that limit the selection of data from your database. The results of your query include only the data that satisfies the conditions you specify.

Use either of the following methods below to add a condition to your query.

Method 1

This method lets you find and select the exact column you want to add the condition to. Repeat this procedure for each column you want to add a condition to:

  1. In the Query Conditions panel, click  or select this link: [Add new condition].

  2. From the displayed menu, select the column you want to apply the condition to.

The condition expression is displayed in the Query Conditions panel. An expression contains three elements: the column name, an operator, and a value. For example:

  1. To add the condition to the column, complete these steps:

a. Click the Operator link (see previous illustration) and select the desired operator from the menu.

The operators listed in the menu depend on the type of data contained in the column.

The operator is added to the condition.

b. Click the Value link (see previous illustration) and type a value or values for the condition.

The condition you specified is now added to the selected column.

Method 2

This method automatically adds a condition to each column that is currently selected in the Result Columns panel.

Because this method adds a condition to each selected column, you may need to remove the conditions you do not want to apply.

  1. In the Column Picker panel, select the columns you want to include in your query.

The names of the columns are added to the Result Columns panel.

  1. At the bottom of the panel, click .

For each column you selected, a condition expression is displayed in the Query Conditions panel. For each column, the condition expression may vary, depending on the types of data in the column. However, each expression contains three elements: the column name, an operator, and a value. For example:

  1. To add the condition, complete these steps:

a. Click the Operator link (see previous illustration) and select the desired operator from the menu.

The operators listed in the menu depend on the type of data contained in the column.

The operator is added to the condition.

b. Click the Value link (see previous illustration) and type a value or values for the condition.

The condition you specified is now added to the selected column.

-

Editing a Condition

A condition expression contains three elements: the column name, an operator, and a value. For example:

To edit a condition, you can change any of these three elements.

        To change the column, click the Column link (see previous illustration) and select a different column from the list.

        To change the operator, click the Operator link (see previous illustration) and select the desired operator from the menu.

The operators listed in the menu depend on the type of data contained in the column.

        To change a value, click the Value link (see previous illustration) and type a new value in the displayed text field.

-

Removing a Condition

To remove a condition from a column:

  1. In the Query Conditions panel, position your cursor on the column whose condition you want to remove.

  2. Slide your cursor to the right until you see this button: . Click the button.

The condition is removed immediately and is no longer applied to the column's data.

Have more questions? Submit a request

Comments

0 comments

Please sign in to leave a comment.