Inside a business component
Last updated
Last updated
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