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

-user_bugs_only_p (optional, defaults to "f")

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