categories-postgresql.xql
DB Query file
Related Files
- packages/bug-tracker/www/admin/categories.tcl
- packages/bug-tracker/www/admin/categories.adp
- packages/bug-tracker/www/admin/categories-postgresql.xql
- packages/bug-tracker/www/admin/categories-oracle.xql
[ hide source ] | [ make this the default ]
File Contents
<?xml version="1.0"?> <queryset> <rdbms><type>postgresql</type><version>7.1</version></rdbms> <fullquery name="select_categories"> <querytext> select child.keyword_id as child_id, child.heading as child_heading, parent.keyword_id as parent_id, parent.heading as parent_heading, case when child.keyword_id is null then 0 else (select count(*) from bt_bugs where project_id = :package_id and content_keyword__is_assigned(bug_id, child.keyword_id, 'none')) end as num_bugs, (select content_keyword__is_leaf(parent.keyword_id)) as is_leaf, (select count(*) from bt_default_keywords where project_id = :package_id and parent_id = parent.keyword_id and keyword_id = child.keyword_id) as default_p from cr_keywords parent left outer join cr_keywords child on (child.parent_id = parent.keyword_id) where parent.parent_id = :project_root_keyword_id order by parent.heading, child.heading </querytext> </fullquery> </queryset>