bug_tracker::component_get_filter_data_not_cached (public)
bug_tracker::component_get_filter_data_not_cached \ -package_id package_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 project 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 component 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::component_get_filter_data_not_cached.select"> <querytext> select c.component_name, c.component_id, count(b.bug_id) as num_bugs from bt_bugs b, bt_components c where b.project_id = :package_id and c.component_id = b.component_id [bug_tracker::user_bugs_only_where_clause] group by c.component_name, c.component_id order by c.component_name </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