25.1.10.3 Passing in Workflow Participants

A common requirement is to let the page or workflow activity that creates a workflow pass in the list of task assignees as an input parameter.

This is easy to accomplish by defining a parameter – for example named P_ASSIGNEE_LIST – and referencing it in an expression consisting of just the bind variable:

:P_ASSIGNEE_LIST

Of course, you could also use it in a SQL Query, but in that case you need to return one row per case-sensitive username supplied. For example, if the input value is a colon-separated list of usernames, you could use the SQL Query option with the query:

select column_value
from apex_string.split(:P_ASSIGNEE_LIST,':')

Caution:

Participant usernames are case-sensitive. If :APP_USER returns DAVID, then use DAVID.