workflow::impl::role_assignee_pick_list::current_assignees::get_pick_list (public)

 workflow::impl::role_assignee_pick_list::current_assignees::get_pick_list \
    case_id object_id role_id

Defined in packages/workflow/tcl/implementation-procs.tcl

Return the list of current assignees for this case and role

Parameters:

case_id
object_id
role_id

Partial Call Graph (max 5 caller/called nodes):

Testcases:

No testcase defined.

Source code:

    set workflow_id [workflow::role::get_workflow_id -role_id $role_id]
    
    return [db_list select_current_assignees {}]

XQL Not present:

PostgreSQL, Oracle

Generic XQL file:

<fullquery name="workflow::impl::role_assignee_pick_list::current_assignees::get_pick_list.select_current_assignees">
    <querytext>
        select distinct m.party_id
        from   workflow_case_role_party_map m, 
               workflow_cases c
        where  m.role_id = :role_id 
        and    m.case_id = c.case_id
        and    c.workflow_id = (select workflow_id from workflow_cases where case_id = :case_id)
    </querytext>
</fullquery>

packages/workflow/tcl/implementation-procs.xql