Filtering Workspace Data - Developer Documentation
Skip to content

Filtering Workspace Data

The Filters panel allows you to create and use queries to filter the data before saving it to a dataset.

Filter Query Terminology

The Filters panel uses "rules" and "groups" to create queries and filter data. It may help to clarify certain terms used on the Filters panel.

  • Rules are the individual expressions that are sent to the query engine.
  • Groups organize these expressions so that the And/Or expressions can be applied appropriately. Groups allow you to set parentheses around the rules and expressions so they are executed in the correct logical order.

Additional Filter Operators

The query builder uses operators to filter records in various ways. Operators specify conditions in a statement and serve as conjunctions for multiple conditions in a statement. There are currently five operators available in Predictive Learning as shown in the following illustration.

Filter Operators

Filter Operators Example

Operators can be used in conjunction with rules and groups to create complex queries as shown in the following illustration:

conjunction with rules

Filters Panel Buttons and Icons Descriptions

The following table describes the buttons and icons on the Filters panel.

Button/Icon... Purpose... Click this button to...
And Or Operator selector Set the operator for the rule or group. The operator must be consistent within a group.
Rule Add rule Add a row and create a rule for the query.
Group Add group Add a row and create a group of nested items with a rule.
Delete Delete row Delete the row from the query.
Reset Reset Filters panel Clear all selections and begin again.
Cancel Cancel transaction Cancel the transaction, discard all entries, and exit the Filters page.
Previous Go to previous page Go back to the previous tab or page.
Move row Move row Move the row up or down and rearrange the order.
Drop-down Open drop-down list Open the drop-down list of options to select.

How to Filter Data

Data filtering can include multiple rules and groups. As you make selections in the query builder, the Query field responds to your input and, additionally, you can make changes in the Query field itself. If your syntax is correct, when you click out of the Query field, the query builder updates with the changes.

Follow these steps to filter your data before saving it to a dataset:

  1. Click the Filters tab on any PrL page, or select Next of the Schema page, to navigate to the Filters page.
  2. Select an entry from the first field's drop-down list.
  3. Select an operator from the second field's drop-down list, and enter a value in the third field.
  4. Select And or Or to specify the relationship between fields.
  5. Click Add Rule to specify individual data elements to include.
  6. Click Add Group to specify more than one data element and group them together.
  7. Click Next or click the Preview tab to view the data with the filters you specified on the Filters page.

Filter Query Example

The following illustrates a sample query using the Filter query builder.

Fileter query builder

Last update: June 15, 2023

Except where otherwise noted, content on this site is licensed under the Development License Agreement.