workflow::case::get_enabled_action_ids_not_cached (public)

 workflow::case::get_enabled_action_ids_not_cached case_id \
    [ trigger_type ]

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

Used internally by the workflow API only. Goes to the database to get the enabled actions for the case.

Parameters:

case_id (required)

trigger_type (optional)

Testcases:

No testcase defined.

Source code:

    if { $trigger_type eq "" } {
        return [db_list select_enabled_actions {
            select ena.enabled_action_id
            from   workflow_case_enabled_actions ena
            where  ena.case_id = :case_id
            and    ena.completed_p = 'f'
        }]
    } else {
        return [db_list select_enabled_actions {
            select ena.enabled_action_id
            from   workflow_case_enabled_actions ena,
                   workflow_actions a
            where  ena.case_id = :case_id
            and    a.action_id = ena.action_id
            and    ena.completed_p = 'f'
            and    a.trigger_type = 'user'
            order  by a.sort_order
        }]
    }

Generic XQL file:

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