Folks,
Trying to figure out the different table relationships and the postgres
psql ....
Canned Report #6 is throwing an error:
Report execution failed: ERROR: column "modified" does not exist
The report SQL:
SELECT p.value AS __color__,
t.milestone AS __group__,
(CASE status
WHEN 'closed' THEN 'color: #777; background: #ddd; border-color:
#ccc;'
ELSE
(CASE owner WHEN '$USER' THEN 'font-weight: bold' END)
END) AS __style__,
id AS ticket, summary, component, status,
resolution,version, t.type AS type, priority, owner,
changetime as _modified, time AS _time, reporter AS _reporter
FROM ticket t, enum p
WHERE p.name=t.priority AND p.type='priority'
ORDER BY (milestone IS NULL), milestone DESC, (status = 'closed'),
(CASE status WHEN 'closed' THEN modified ELSE (-1)*p.value END)
DESC
Best Regards,
Joe
________________________________________________________________________________________
Joseph H. Dayney | Contract Software Engineer | RR Donnelley
630W 1000N | Logan, UT 84321 | (: 435-755-4278 | È: 801-608-1052 | Ê:
435-755-4210 | *: [EMAIL PROTECTED]
This email and any files transmitted with it are confidential and intended
solely for the use of the individual or entity to whom they are addressed.
Any unauthorized review, use, disclosure or distribution is prohibited. If
you are not the intended recipient, please contact the sender by reply
e-mail and destroy all copies of the original message.
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Trac
Users" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/trac-users?hl=en
-~----------~----~----~----~------~----~------~--~---
