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.

You can use Task Substitution Strings to pass information about a task instance 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	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	The task id
APEX$TASK_SUBJECT	The task subject
APEX$TASK_STATE	The task's current state
APEX$TASK_OUTCOME	The task outcome Only populated for tasks in the Completed state
APEX$TASK_CREATED_ON	The timestamp for task creation in YYYY-MM-DD"T"HH24:MI:SS.FF3TZH:TZM format.
APEX$TASK_INITIATOR	The user who initiated the task Defaults to the logged in user unless a different value is explicitly specified in the Human Task - Create Page Process
APEX$TASK_DUE_ON	The timestamp for the task due date, in YYYY-MM-DD"T"HH24:MI:SS.FF3TZH:TZM format
APEX$TASK_OWNER	The user who currently owns the task
APEX$TASK_RENEWAL_COUNT	The number of times a task has been renewed
APEX$TASK_MAX_RENEWAL_COUNT	The maximum number of times a task can be renewed according to the expiration policy in the task definition
APEX$TASK_PREVIOUS_ID	The previous id for a task Links an expired task to the renewed task If task T1 is expired and T2 is the renewed task, then APEX$TASK_PREVIOUS_ID of T2 is the ID of task T1 (T1.id)