diff options
author | bbaetz%student.usyd.edu.au <> | 2002-08-12 12:42:42 +0000 |
---|---|---|
committer | bbaetz%student.usyd.edu.au <> | 2002-08-12 12:42:42 +0000 |
commit | 61ddf0a32846fdf2607043d94af1a0a86b80f6fc (patch) | |
tree | 714517b4c6b9e33b10a12aa5a4b99641bcafefef /Bugzilla/Bug.pm | |
parent | 17b301e76d886afd5be8f4e9919afb4446e49405 (diff) | |
download | bugs-61ddf0a32846fdf2607043d94af1a0a86b80f6fc.tar bugs-61ddf0a32846fdf2607043d94af1a0a86b80f6fc.tar.gz bugs-61ddf0a32846fdf2607043d94af1a0a86b80f6fc.tar.bz2 bugs-61ddf0a32846fdf2607043d94af1a0a86b80f6fc.tar.xz bugs-61ddf0a32846fdf2607043d94af1a0a86b80f6fc.zip |
Bug 43600 - Convert products/components to use ids instead of names.
Initial attempt by jake@bugzilla.org, updated by me
r=joel, preed
Diffstat (limited to 'Bugzilla/Bug.pm')
-rwxr-xr-x | Bugzilla/Bug.pm | 9 |
1 files changed, 6 insertions, 3 deletions
diff --git a/Bugzilla/Bug.pm b/Bugzilla/Bug.pm index df7a91553..d73bc536f 100755 --- a/Bugzilla/Bug.pm +++ b/Bugzilla/Bug.pm @@ -111,13 +111,16 @@ sub initBug { my $query = " select - bugs.bug_id, alias, product, version, rep_platform, op_sys, bug_status, - resolution, priority, bug_severity, component, assigned_to, reporter, + bugs.bug_id, alias, products.name, version, rep_platform, op_sys, bug_status, + resolution, priority, bug_severity, components.name, assigned_to, reporter, bug_file_loc, short_desc, target_milestone, qa_contact, status_whiteboard, date_format(creation_ts,'%Y-%m-%d %H:%i'), groupset, delta_ts, sum(votes.count) - from bugs left join votes using(bug_id) + from bugs left join votes using(bug_id), + products, components where bugs.bug_id = $bug_id + AND products.id = bugs.product_id + AND components.id = bugs.component_id group by bugs.bug_id"; &::SendSQL(&::SelectVisible($query, $user_id, $usergroupset)); |