workflow::case::get_id (public)

 workflow::case::get_id -object_id object_id \
    -workflow_short_name workflow_short_name

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

Gets the case_id from the object_id which the case is about, along with the short_name of the workflow.

Switches:

-object_id (required)

The object_id which the case is about

-workflow_short_name (required)

The short_name of the workflow.

Returns:

The case_id of the case. Returns the empty string if no case could be found.

Author:

Lars Pind <lars@collaboraid.biz>

Testcases:

No testcase defined.

Source code:

    set found_p [db_0or1row select_case_id {}]
    if { $found_p } {
        return $case_id
    } else {
        error "No matching workflow case found for object_id $object_id and workflow_short_name $workflow_short_name"
    }

Generic XQL file:

<fullquery name="workflow::case::get_id.select_case_id">
    <querytext>
      select case_id
      from   workflow_cases c, 
             workflows w
      where  c.object_id = :object_id
      and    w.workflow_id = c.workflow_id
      and    w.short_name = :workflow_short_name
    </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