bug_tracker::version_get_filter_data_not_cached (public)

 bug_tracker::version_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 package (project) to select from

-user_id

(optional)

-admin_p

(defaults to "f") (optional)

-user_bugs_only_p

(defaults to "f") (optional)

Returns:

list-of-lists with fix-for-version 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::version_get_filter_data_not_cached.select">
    <querytext>
        select v.version_name,
               b.fix_for_version,
               count(b.bug_id) as num_bugs
        from   bt_bugs b left outer join 
               bt_versions v on (v.version_id = b.fix_for_version)
        where  b.project_id = :package_id
               [bug_tracker::user_bugs_only_where_clause]
        group  by b.fix_for_version, v.anticipated_freeze_date, v.version_name
        order  by v.anticipated_freeze_date, v.version_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