workflow::case::timed_actions_sweeper (public)

 workflow::case::timed_actions_sweeper

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

Sweep for timed actions ready to fire.

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

Testcases:

No testcase defined.

Source code:

    set enabled_action_ids [db_list select_timed_out_actions {}]
    
    foreach enabled_action_id $enabled_action_ids {
        workflow::case::action::execute  -no_perm_check  -enabled_action_id $enabled_action_id
    }

Generic XQL file:

<fullquery name="workflow::case::timed_actions_sweeper.select_timed_out_actions">
    <querytext>
        select enabled_action_id
        from   workflow_case_enabled_actions
        where  execution_time <= current_timestamp
        and    completed_p = 'f'
    </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