workflow::case::role::get_assignees_not_cached (private)

 workflow::case::role::get_assignees_not_cached case_id role_id

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

Proc used only internally by the workflow API. Retrieves role assignees directly from the database.

Parameters:

case_id
role_id

Author:

Peter Marklund

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

Testcases:

No testcase defined.

Source code:

    set result {}
    db_foreach select_assignees {} -column_array row {
        lappend result [array get row]
    }
    return $result

Generic XQL file:

<fullquery name="workflow::case::role::get_assignees_not_cached.select_assignees">
    <querytext>
        select m.party_id,
               p.email,
               acs_object.name(m.party_id) as name
        from   workflow_case_role_party_map m,
               parties p
        where  m.case_id = :case_id
        and    m.role_id = :role_id
        and    p.party_id = m.party_id
    </querytext>
</fullquery>

packages/workflow/tcl/case-procs.xql

PostgreSQL XQL file:

packages/workflow/tcl/case-procs-postgresql.xql

Oracle XQL file:

packages/workflow/tcl/case-procs-oracle.xql