bug_tracker::assignee_get_options (public)

 bug_tracker::assignee_get_options [ -workflow_id workflow_id ] \
    [ -include_unknown ] [ -include_undecided ]

Defined in packages/bug-tracker/tcl/bug-tracker-procs.tcl

Returns an option list containing all users that have submitted or assigned to a bug. Used for the add bug form. Added because the workflow api requires a case_id. (an item to evaluate is refactoring workflow to provide an assignee widget without a case_id)

Switches:

-workflow_id (optional)

-include_unknown (optional, boolean)

-include_undecided (optional, boolean)

Partial Call Graph (max 5 caller/called nodes):

Testcases:

No testcase defined.

Source code:

   
    set assignee_list [db_list_of_lists assignees {}]

    if { $include_unknown_p } {
        set assignee_list [concat { { "Unknown" "" } } $assignee_list]
    } 
    
    if { $include_undecided_p } {
        set assignee_list [concat { { "Undecided" "" } } $assignee_list]
    } 
    
    return $assignee_list

Generic XQL file:

<fullquery name="bug_tracker::assignee_get_options.assignees">
    <querytext>
       select acs_object.name(p.party_id) || ' (' || p.email || ')'  as label,
	party_id from  parties p
	where party_id in (select distinct(party_id) from workflow_case_role_party_map,
				workflow_cases
				where workflow_case_role_party_map.case_id = workflow_cases.case_id
				and workflow_cases.workflow_id = :workflow_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