workflow::case::fsm::get_info_not_cached (private)

 workflow::case::fsm::get_info_not_cached case_id \
    [ parent_enabled_action_id ]

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

Used internally by the workflow id to get FSM case info from the database.

Parameters:

case_id (required)

parent_enabled_action_id (optional)

Author:

Peter Marklund

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

Testcases:

No testcase defined.

Source code:

    if { $parent_enabled_action_id eq "" } {
        db_1row select_case_info_null_parent_id {} -column_array row
    } else {
        db_1row select_case_info {} -column_array row
    }

    return [array get row]

Generic XQL file:

<fullquery name="workflow::case::fsm::get_info_not_cached.select_case_info">
    <querytext>
      select c.case_id,
             c.workflow_id,
             c.object_id,
             s.state_id,
             s.short_name as state_short_name,
             s.pretty_name as pretty_state,
             s.hide_fields as state_hide_fields
      from   workflow_cases c,
             workflow_case_fsm cfsm left outer join
             workflow_fsm_states s on (s.state_id = cfsm.current_state) 
      where  c.case_id = :case_id
      and    cfsm.case_id = c.case_id
      and    cfsm.parent_enabled_action_id = :parent_enabled_action_id
    </querytext>
</fullquery>

<fullquery name="workflow::case::fsm::get_info_not_cached.select_case_info_null_parent_id">
    <querytext>
            select c.case_id,
                   c.workflow_id,
                   c.object_id,
                   s.state_id,
                   s.short_name as state_short_name,
                   s.pretty_name as pretty_state,
                   s.hide_fields as state_hide_fields
            from   workflow_cases c,
                   workflow_case_fsm cfsm left outer join
                   workflow_fsm_states s on (s.state_id = cfsm.current_state) 
            where  c.case_id = :case_id
            and    cfsm.case_id = c.case_id
            and    cfsm.parent_enabled_action_id is null
    </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