Expression Builder Dialog Box

AdminStudio 2023 | 25.0 | Application Manager

Edition:Application Manager is included with AdminStudio Professional and Enterprise Editions.

The Expression Builder dialog box, available by clicking Build Expression on the Where Clause panel in the Rules Wizard (when creating a new user-defined ACE) or from the Where Clause Tab of the ACE Rule Properties Dialog Box (when editing a user-defined ACE), allows you to build simple Where clause expressions for Application Catalog user-defined ACEs.

Set values for the following options:

Expression Builder Dialog Box Properties

Option	Description
Table Columns	This list is populated from the table columns in the table defined in the Rules Wizard General Information panel. Select the table column used in this Where clause.
Comparison Operator	Pick an operator to use for comparison in the Where clause. You can pick from the following: • = (Equal To) • <> (Not Equal To) • > (Greater Than) • < (Less Than) • >= (Greater Than or Equal To) • <= (Less Than or Equal To)
Constant	This constant can be a numerical value or string value. The property label will change based on the expected constant type. This value is compared against the data in the specified table. Note:When using the Expression Builder dialog box to create a Source and Target Packages custom ACE to compare the value of a column in the source table to the value of a column in the target table, you can select the first table column name from the Table Columns list. However, you have to manually enter the second table column name in the Constant text box. When doing so, enter the table column name using the same syntax that is used in the Table Columns list: [Source].[ColumnName] or [Target].[ColumnName]. See Creating a Custom/Source and Target Packages ACE.
Expression Operator	If there is more than one expression in the Where clause, you can specify an operator to join the current expression to the previous expression.

Tip:When you are constructing simple expressions, it is helpful to use the Expression Builder dialog box, but you are not limited to the formatting options that the Expression Builder provides to you. If you know how to write Where clauses in SQL, you can use significantly more powerful expressions by entering them directly in the Where Clause text box on the Where Clause panel of the Rules Wizard or on the Where Clause tab of the ACE Rule Properties Dialog Box.