Build Expression window (for SQL expressions and scripts)

Use the Build Expression window to enter text or create a SQL expression or script which Alloy Navigator will run to query the database.

  • Expression Type - specifies the type of your input:

    • Text - static text optionally combined with placeholders for dynamic content.

    • SQL expression - a single SQL SELECT statement

    • SQL script - a SQL script containing Transact-SQL statements.

  • Unnamed text field - the text, SQL expression, or SQL script.

  • Category, Item, Subitem - panes of the Select Placeholder window, where you can choose a placeholder that will be replaced with the actual field value or macro value at runtime.

  • Insert - inserts the selected placeholder into the text, SQL expression, or script.

Build Expression window (for lookup filed filters)

If you want to filter out specific values from the drop-down list displayed on the Action Form, use the Build Expression window to create your custom SQL filtering expression.

  • Unnamed text field - the filtering expression in the form of a SQL ”WHERE” clause (without the word WHERE).

  • Select Template - opens the Select Filter Template window, where you can choose one of ready-to-use filter templates. When there is a filter template that suits your needs, select it and then assign parameter values using the Assign Filter Parameters window.

  • Category, Item, Subitem - panes of the Select Placeholder window, where you can choose a placeholder that will be replaced with the actual field value or macro value at runtime.

    • Category > Lookup Fields - This category appears only when you create filter expressions. Unlike other categories such as Object Field, the Lookup Fields category contains not placeholders for field values, but field names (or column names) of the object records that appear in the filtered drop-down list. To insert a field name into your SQL expression, select Lookup Fields > [FieldName] and click Insert.

  • Insert - inserts the selected placeholder or field name into the filtering expression.

  • TIP: When configuring a filter for a customizable lookup list such as Category or Type, you can use tags that you have assigned to list items.