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
(defaults to"f"
) (optional)- -user_bugs_only_p
(defaults to"f"
) (optional)- 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