Skip to main content

Predefined variables supported by Platform

JAVASCRIPT

There is a series of predefined variables automatically set by Platform after the logon of the user and that can be accessed by any client side javascript action:

  • username
  • languageId
  • applicationId
  • siteId
  • companyId

SQL BUSINESS COMPONENTS

Similar variables are supported on the server-side, within SQL business components and they can be referred using the : symbol before them and they are always expressed as upper case variables:

  • USERNAME – username of the logged user
  • :LANGUAGE_ID – the current language, binded to the logged user
  • :APPLICATION_ID – the current application identifier
  • :TODAY – a date without time
  • :NOW – a date+time
  • :COMPANY_ID
  • :COMPANY_ID_AS_NUM (to use only in case the COMPANY_ID is a number, it is automatically converted in a number)
  • :SITE_ID
  • :YEAR
  • :MONTH
  • :DAY – day of the month
  • :DOW – day of week