Inside a business component

Platform allows to specify SQL instructions including binding variables.

These binding variables are always defined using the notation:

:XXX

where XXX is the variable name, always in upper case.

These variables will be automatically replaced by the corresponding values available at user session level.

The user session is composed of a set of variables:

• predefined variables, automatically set by Platform, when the user logs on

• custom variables, defined using the addCustomApplUserVars server-side javascript method

• input parameters, passed to the business component, defined in the business component definition window (input pars subfolder)

The predefined variables are:

Variable name	Description
:APPLICATION_ID	application identifier
:BASE_URL	server base url
:COMPANY_ID	company identifier (used in case the app supports partitioned data)
:SITE_ID	site identifier
:USERNAME	current user
:UUID or :DEVICE_ID	device id, i.e. a unique identifier for a specific device (more specific than the username)
:LANGUAGE_ID	current user
:DOCUMENTS_DIR	absolute path within the mobile device, where files are stored;it is a folder inside the “customFiles” default app folder.
:TODAY	current date
:NOW	current date+time
:YEAR	current year
:GPS_LATITUDE	current latitude
:GPS_LONGITUDE	current longitude
:GPS_ALTITUDE	current altitude
:GPS_SPEED	current speed
:APP_VERSION	current app versione
:LAST_SYNC_DATE	last sync date