SST Operations Bridge Administration Guide, Version 1.1

Views 85
3. The New SQL-based View dialog box is displayed. The General tab page is the default page displayed.
Enter the name for the View and description (optional) in the View Name and Description boxes,
respectively.
Figure 8-27 New SQL-based View Dialog Box - General Tab page
’
4. Click on the SQL tab in the New SQL-based View dialog box to access the corresponding tab page. The
SQL query supports substitution parameters like %city%, %terminal id%, and %Fiid%.
Figure 8-28 New SQL-based View Dialog Box - SQL Tab Page
NOTE: If a column is of character data type, you must specify single quotes around the substitution parameter.
For example, the Terminal id column can be specified as ‘%terminal id%’.
NOTE: The SQL-based Local View (in Custom Tab) does not support the Mapped Columns available under
Data Mapping.
Views