Global Variables Tab

Top Previous Next

Overview

In addition to system scripting variables, InFocus supports custom variables for use in advanced query applets like SQL Query, Custom Reports and Dashboard Queries Manager.

Created in Global Settings, these variables are assigned a value is inserted into the query at execution.

Global Variables are referenced in queries using the following syntax: **@variable@**.

Field Descriptions

•	Variable Name

•	Value - Default value for the variable. Note, value should be formatted according to the field type (e.g int = plain text (5), varchar = single-quote text ('LJC01'), etc.)

•	Variable - Automatically builds the the variable, with added syntax (e.g. @variable@)