bug_tracker::state_get_filter_data_not_cached (public)

 bug_tracker::state_get_filter_data_not_cached -package_id package_id \
    -workflow_id workflow_id [ -user_id user_id ] [ -admin_p admin_p ] \
    [ -user_bugs_only_p user_bugs_only_p ]

Defined in packages/bug-tracker/tcl/bug-tracker-procs.tcl

Switches:

-package_id (required)

The package (project) to select from

-workflow_id (required)

The workflow we're interested in

-user_id (optional)

-admin_p (optional, defaults to "f")

-user_bugs_only_p (optional, defaults to "f")

Returns:

list-of-lists with state data for filter

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

Testcases:

No testcase defined.

Source code:

    return [db_list_of_lists select {}]

Generic XQL file:

<fullquery name="bug_tracker::state_get_filter_data_not_cached.select">
    <querytext>
      select st.pretty_name,
             st.state_id,
             count(b.bug_id)
      from   workflow_fsm_states st,
             bt_bugs b,
             workflow_cases cas,
             workflow_case_fsm cfsm
      where  st.workflow_id = :workflow_id
      and    cas.workflow_id = :workflow_id
      and    cas.object_id = b.bug_id
      and    cfsm.case_id = cas.case_id
      and    st.state_id = cfsm.current_state
             [bug_tracker::user_bugs_only_where_clause]
      group  by st.state_id, st.pretty_name, st.sort_order
      order  by st.sort_order
    </querytext>
</fullquery>

packages/bug-tracker/tcl/bug-tracker-procs.xql

PostgreSQL XQL file:

packages/bug-tracker/tcl/bug-tracker-procs-postgresql.xql

Oracle XQL file:

packages/bug-tracker/tcl/bug-tracker-procs-oracle.xql