Re: Text Reports query

On Thu, 27 Nov 2003 16:14:38 -0600
Russell Valentine <russ-98fVsw/2eqlQihsdzhub5di2O/[email protected]> wrote:

> I have a few
> questions about the advanced query search.


Alright I found a problem. Sorry, I got confused because it was doing
"resolved_d.name as resolution" in the select then doing "left join on
resolve_d on resolve_d.id = resolution" however the resolution you where
using was bugs.resolution.

I hope this will fix it and you see data.


Russell Valentine

--- advancedquery.inc.php~      2003-11-27 20:34:02.000000000 -0600
+++ advancedquery.inc.php       2003-11-27 20:31:14.000000000 -0600
@@ -335,8 +335,8 @@
                . "\n priority_d.name AS priority, status_d.name AS status, resolve_d.name AS resolution, u1.name AS assigned, u2.name AS reporter ,  "
                . "\n to_char(to_date(creation, 'YYYYMMDDHH24MISS'), 'Mon/DD/YY') AS creation, "
                . "\n to_char(to_date(modified, 'YYYYMMDDHH24MISS'), 'Mon/DD/YY') AS modified "
-               . "\n from bugs,products,components,versions,status_d,priority_d,severity_d, users u1, users u2 "
-               . "\n left join resolve_d on resolve_d.id = resolve_d.name "
+               . "\n from products,components,versions,status_d,priority_d,severity_d, users u1, users u2, bugs"
+               . "\n left join resolve_d on bugs.resolution = resolve_d.id "
                . "\n where status_d.id = status and bugs.severity = severity_d.id and priority = priority_d.id "
                . "\n and bugs.product = products.pid and component = components.cid and version = versions.vid "
                . "\n and u1.uid = bugs.assigned and u2.uid = bugs.reporter "

_______________________________________________
Anthill-workers mailing list
Anthill-workers-+mQDA36h6dWw5LPnMra/[email protected]
http://vmlinuz.ca/mailman/listinfo/anthill-workers

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.3 (GNU/Linux)

iD8DBQE/xrSlO0EDJO5MgRYRArqlAJsEOuJ2Cb8kOSzWOdB+SXokdr0HhgCdHKfE
fBSmH+9XyIGR8LyrtfYMUeU=
=Mfi5
-----END PGP SIGNATURE-----