BackPrevious Topic Next TopicNext

Expressions

The Expressions dialog helps you compose the filter conditions for a query dataset. It appears when you select Choose button to compose a condition.

The dialog varies for defining filter condition or 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

Expressions dialog - Real Name tab

  • 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

Expressiongs dialog - Subquery tab

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

Expressions dialog - Field Value tab

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. Select 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.

Back to top


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

Expressions dialog - Mapping Name tab for record level security

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

Expressions dialog - Value tab for record level security

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.

Back to top

BackPrevious Topic Next TopicNext