workflow::case::fsm::get_state_info_not_cached (private)

 workflow::case::fsm::get_state_info_not_cached case_id \
    parent_enabled_action_id all_p

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

Gets all state info from the database, include sub-action state.

Parameters:

case_id (required)

parent_enabled_action_id (required)

all_p (required)

Returns:

a list of (action_id, current_state) tuples. The top-level state is the one that has action_id empty.

See Also:

• workflow::case::fsm::get_state_info

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

Testcases:

No testcase defined.

Source code:

    if { $all_p  } {
        return [db_list_of_lists select_state_info {}]
    } else {
        if { $parent_enabled_action_id eq "" } {
            return [db_string null_parent {
                select current_state
                from   workflow_case_fsm
                where  case_id = :case_id
                and    parent_enabled_action_id is null
            }]
        } else {
            return [db_string null_parent {
                select current_state
                from   workflow_case_fsm
                where  case_id = :case_id
                and    parent_enabled_action_id = :parent_enabled_action_id
            }]
        }
    }

Generic XQL file:

<fullquery name="workflow::case::fsm::get_state_info_not_cached.select_state_info">
    <querytext>
      select cfsm.parent_enabled_action_id,
             cfsm.current_state as current_state_id
      from   workflow_case_fsm cfsm 
      where  cfsm.case_id = :case_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