All user specific JobRouter system variables and global configurations are being solved in the initialization queries. In addition, it is possible to resolve the filter values for initialization queries if these were defined in the initialization query with square brackets.
Global configuration as placeholder
If you want to use a value from a global configuration for a query in JobSelect, you can address it using [jrc_<JRGLOBALCONFIGURATION.setting>] in the query.
Example:
SELECT column1, column2, column3 FROM exampleTable WHERE column1='[jrc_personalJobDataStatusCanceled]'
JobRouter System Variables as Placeholders
If you want to use user-related data for a query in JobSelect, you can use JobRouter system variables.
Example:
SELECT username FROM JRUSERS WHERE username='[jr_username]'
The following JobRouter system variables are available for selection:
JobRouter system variable |
Description |
|---|---|
[jr_username] |
Username |
[jr_email] |
Email address |
[jr_fullname] |
Full name |
[jr_lastname] |
Last name |
[jr_prename] |
First name |
[jr_department] |
Department |
[jr_phone] |
Telephone |
[jr_fax] |
Fax |
[jr_supervisor] |
Supervisor |
[jr_language] |
Language of the user |
[jr_user_defined1] |
User defined field 1 |
[jr_user_defined2] |
User definied field 2 |
[jr_user_defined3] |
User definied field 3 |
[jr_user_defined4] |
User definied field 4 |
[jr_user_defined5] |
User definied field 5 |
[jr_date_format] |
Date format 1: TT.MM.JJJJ 2: TT/MM/JJJJ 3: MM/TT/JJJJ 4: JJJJ-MM-TT |
[jr_decimal_separator] |
Decimal separator of the user |
[jr_thousands_separator] |
Thousands separator of the user |
Additional JobRouter system variables as placeholders
There are other JobRouter system variables available, such as
JobRouter system variable |
Description |
|---|---|
[jr_date] |
System date Example: 2019-05-28 |
[jr_time] |
System time Example: 08:12:04 |
[jr_date_time] |
System date with system time Example: 2019-05-28 08:12:04 |
