Previous Topic Next Topic

Expressions Dialog

The Expressions dialog helps you compose the filter conditions for a query dataset. It appears when you select to compose a condition and differs for filter condition and record level security condition.

When the dialog is used to compose the filter conditions for a query or a dataset created from a query, it contains three tabs: Real Name, Subquery and Field Value. The Subquery tab is available only when defining filter for a query.

Real Name

• When defining a query filter, this tab lists the tables added in the query with all their columns, as well as the parameters and valid formulas of these columns in the same catalog data source as the query.
• When defining a dataset filter, this tab lists the tables added in the data resource on which the dataset is created with all their columns, as well as the parameters and valid formulas of these columns in the same catalog data source as the data resource.

double-click the required field to create the filter on it.

The following symbols at the bottom allow you to modify the expression according to your requirements.

• +
  Adds numbers or fields together in the Expression menu.
• -
  Subtracts numbers or fields together in the Expression menu.
• *
  Multiplies numbers or fields together in the Expression menu.
• /
  Divides numbers or fields together in the Expression menu.
• =
  Equates fields together
• "
  Places quotations on long character strings or name that have blanks in them. For example, you should place quotes on values such as "New York" or "Washington DC")
• ||
  Allows you to place fields together in the same Expression menu. For example, "New York" || "Washington DC")
• ( )
  Places your fields in parentheses

Subquery

This tab allows you to create a subquery to use in the query filter by editing a query or creating a new query.

• Edit Subquery
  Opens the Query Editor to edit the query.
• New Subquery
  Creates a new subquery here.

Field Value

This tab is disabled when the Expressions dialog is opened while setting the filter field. It lists all column names of the related table, in which the field to be filtered is. Check the column name of the field to be filtered, select OK, then the values of the field will be displayed. Choose the required value and select Set to use it to filter the field.

When the dialog is used to compose the conditions for a record level security policy, it contains two tabs: Mapping Name and Value.

Mapping Name

This tab lists the tables/views/synonyms, queries and hierarchical data sources in the current catalog data source with all their columns, as well as the parameters and valid formulas of these columns in the catalog data source, and the special field User Name.

Double-click the required field to add it to the condition.

Value

This tab is disabled when the Expressions dialog is opened while setting the field on which to build the condition. When a column is used for a condition, you can obtain the values of the column as follows: select the column in the Mapping Name tab, select the Value tab and the values of the selected column will be listed. double-click a value to set it as the value of the condition.

Previous Topic Next Topic