Expression Dialog

This dialog is used to build SQL expressions for use in displaying Themes or Labels in the GeoPlan Window.

Show me

The dialog is displayed when the Edit button is clicked in the Edit Expressions dialog.

Type an expression in manually (using the Field Type and the Field boxes to insert the fields required).

Alternatively, click the Builder >> button. This displays a set of buttons representing the operators that can be included in the expression.

Field	Description
Object Type	Dropdown list of network objects
Field Type	Dropdown list of data fields applicable to network object selected in the Object Type box. Selecting a Field Type from the list defines which fields will be available in the Field dropdown list : <normal>: default. Will show fields related to the object type in the Field dropdown list. flags: will show flag fields in the Field dropdown list. Flags for an object can be treated as an array, where the array contains two fields - value and name. network: will show network id and name fields in the Field dropdown list which allow queries to be carried out across networks sim: will show results fields in the Field dropdown list.
Field	Dropdown list of data fields applicable to parameter selected in the Field Type box. Selecting a Field from the list inserts the field in the query. When Field Type is set to <normal>, fields related to the selected Object Type will be displayed.
Display Flag Fields check box	Check the Display Flag Fields box to include flag fields in the Field dropdown list.
Display precision	Select the number of decimal places to be shown when displaying the results of the SQL expression in labels.
Builder	Click Builder >> to display a set of buttons representing the operators that can be included in the query. Click Finish << to close the builder.