19.6.13 Substitution Strings and Bind Variables for Tasks

Substitution Strings are used to pass information about a task to an Oracle APEX page.

Task Substitution Strings are used to pass information about a task to an APEX Page. For example, you might want to show different regions in the Task Details page depending on the task's priority or the date a task was created.

Substitution Strings are configured in the Task Definition.

Table 19-7 Substitution Strings for Task Definition Actions

Substitution String Syntax	Description
APEX$TASK_PK	If a primary key column has been defined, this bind variable contains the primary key value. APEX$TASK_PK can also be used as a bind variable in any PL/SQL query used by Task Definition Actions and Task Definition Participants. When used as a bind variable, the syntax is :APEX$TASK_PK
APEX$TASK_ID	This substitution string contains the id of the task for which this action is defined.
APEX$TASK_SUBJECT	This substitution string contains the subject of the task for which this action is defined.
APEX$TASK_STATE	This substitution string contains the current state of the task for which this action is defined.
APEX$TASK_OUTCOME	This substitution string contains the outcome of the task for which this action is defined. This variable is populated only for tasks in Completed state.
APEX$TASK_CREATED_ON	Contains the timestamp of the task creation, in the YYYY-MM-DD"T"HH24:MI:SS.FF3TZH:TZM format.
APEX$TASK_INITIATOR	Contains the user who has initiated the task. This value defaults to the logged-in user if not explicitly specified as part of the Human Task - Create Page Process type.
APEX$TASK_DUE_ON	Contains the timestamp of when this task is due, in the YYYY-MM-DD"T"HH24:MI:SS.FF3TZH:TZM format.
APEX$TASK_OWNER	Contains the user to whom the task is currently assigned.