workflow::case::get_user_roles_not_cached (private)

 workflow::case::get_user_roles_not_cached case_id user_id

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

Used internally by the workflow Tcl API only. Goes to the database to retrieve roles that user is assigned to.

Parameters:

case_id (required)

user_id (required)

Author:

Peter Marklund

Testcases:

No testcase defined.

Source code:

    return [db_list select_user_roles {}]

Generic XQL file:

<fullquery name="workflow::case::get_user_roles_not_cached.select_user_roles">
    <querytext>
      select distinct role_id
      from   workflow_case_role_user_map
      where  case_id = :case_id
      and    user_id = :user_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