bug_tracker::assignee_get_filter_data_not_cached (public)

 bug_tracker::assignee_get_filter_data_not_cached \
    -package_id package_id -workflow_id workflow_id \
    -action_id action_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

-workflow_id

(required)

The workflow we're interested in

-action_id

(required)

The action we're interested in

-user_id

(optional)

User id for optional filtering for logged in user

-admin_p

(defaults to "f") (optional)

-user_bugs_only_p

(defaults to "f") (optional)

Returns:

list-of-lists with assignee 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::assignee_get_filter_data_not_cached.select">
    <querytext>
      select p.first_names || ' ' || p.last_name as name,
             crum.user_id,
             count(b.bug_id) as num_bugs
      from   bt_bugs b,
             workflow_case_assigned_actions aa left outer join
             workflow_case_role_user_map crum on (crum.case_id = aa.case_id and crum.role_id = aa.role_id) left outer join
             persons p on (p.person_id = crum.user_id)
      where  aa.workflow_id = :workflow_id
      and    aa.action_id = :action_id
      and    aa.object_id = b.bug_id
             [bug_tracker::user_bugs_only_where_clause]
      group  by p.first_names, p.last_name, crum.user_id
    </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