bug_tracker::category_get_filter_data_not_cached (public)
bug_tracker::category_get_filter_data_not_cached \ -package_id package_id -parent_id parent_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
- -parent_id
(required)- The category type's keyword_id
- -user_id
(optional)- -admin_p
(defaults to"f"
) (optional)- -user_bugs_only_p
(defaults to"f"
) (optional)- Returns:
- list-of-lists with category 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::category_get_filter_data_not_cached.select"> <querytext> select kw.heading, km.keyword_id, count(b.bug_id) from cr_keywords kw join cr_item_keyword_map km using (keyword_id) left outer join bt_bugs b on (b.bug_id = km.item_id) where kw.parent_id = :parent_id and b.project_id = :package_id [bug_tracker::user_bugs_only_where_clause] group by kw.heading, km.keyword_id order by kw.heading </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