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
user_id
Author:
Peter Marklund

Partial Call Graph (max 5 caller/called nodes):
%3 workflow::case::flush_cache workflow::case::flush_cache (private) workflow::case::get_user_roles_not_cached workflow::case::get_user_roles_not_cached workflow::case::flush_cache->workflow::case::get_user_roles_not_cached workflow::case::flush_cache0 workflow::case::flush_cache0 (private) workflow::case::flush_cache0->workflow::case::get_user_roles_not_cached workflow::case::get_user_roles workflow::case::get_user_roles (public) workflow::case::get_user_roles->workflow::case::get_user_roles_not_cached db_list db_list (public) workflow::case::get_user_roles_not_cached->db_list

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

[ hide source ] | [ make this the default ]
Show another procedure: