Context variables
Context variables can be used in the sourceParams element in the SQL
expression to get the lookup value selected by the user. For example, to filter the results in
the Department lookup, you can use the
CONTEXT_team_NAME context variable to get the team name selected by the user in the Team lookup.
Note: Context variables should not be used directly in the
source SQL as that
would create a SQL injection vulnerability. The sourceParams element is
encoded and therefore protected from SQL injection.This table lists the context variables that are available for substitution for work details and premiums:
| Context variable | Example |
|---|---|
| CONTEXT_department_ID | 1 |
| CONTEXT_department_NAME | DEPT A |
| CONTEXT_docket_ID | 1201 |
| CONTEXT_docket_NAME | AUTODOCKET |
| CONTEXT_endHundredTime | 0001 |
| CONTEXT_flag1..10 | true |
| CONTEXT_hourtype_ID | 5013 |
| CONTEXT_hourtype_NAME | EL_SICK_PEN |
| CONTEXT_isWorkDetail | true |
| CONTEXT_job_ID | 3 |
| CONTEXT_job_NAME | COMPUTER TECHNICIAN |
| CONTEXT_minutes | 1 |
| CONTEXT_project_ID | 1203 |
| CONTEXT_project_NAME | AUTOPROJECT_REPORT |
| CONTEXT_rate | 53 |
| CONTEXT_startHundredTime | 0000 |
| CONTEXT_team_ID | 54 |
| CONTEXT_team_NAME | MOB_DEPT_A |
| CONTEXT_timecode_ID | 5216 |
| CONTEXT_timecode_NAME | AA AAR CODE1 DENIED |
| CONTEXT_udf1..10 | 123 Main Street |
| CONTEXT_workSummaryId | 3016568 |
This table lists the context variables that are available for substitution for elapsed times:
| Context variable | Example |
|---|---|
| CONTEXT_department_ID | 1 |
| CONTEXT_department_NAME | DEPT A |
| CONTEXT_docket_ID | 1201 |
| CONTEXT_docket_NAME | AUTODOCKET |
| CONTEXT_flag1..10 | true |
| CONTEXT_hourType_ID | 5012 |
| CONTEXT_hourType_NAME | EL_SICK_APP |
| CONTEXT_job_ID | 11 |
| CONTEXT_job_NAME | SUPERVISOR |
| CONTEXT_minutes | 1 |
| CONTEXT_ovrDate | 20181221 144754 |
| CONTEXT_project_ID | 1201 |
| CONTEXT_project_NAME | AUTOPROJECT |
| CONTEXT_team_ID | 54 |
| CONTEXT_team_NAME | MOB_DEPT_A |
| CONTEXT_timecode_ID | 5216 |
| CONTEXT_timecode_NAME | AA AAR CODE1 DENIED |
| CONTEXT_udf1..10 | 123 Main Street |