View previous topic :: View next topic |
Author |
Message |
Carlos
Joined: 19 Mar 2004 Posts: 396 Location: Canyon, TX
|
|
Back to top |
|
|
brad Site Admin
Joined: 22 Feb 2004 Posts: 490 Location: Atlanta, GA USA
|
Posted: Fri Dec 09, 2005 5:04 pm Post subject: |
|
|
I'll take a look and patch Trac code as well as all the projects. Ideally, I'd like to talk to the guys and get the fix put into the Trac trunk.
Thanks,
BA |
|
Back to top |
|
|
jcc7
Joined: 22 Feb 2004 Posts: 657 Location: Muskogee, OK, USA
|
Posted: Thu Dec 15, 2005 7:06 pm Post subject: |
|
|
I've found a similar problem (thus I'm posting in the same topic).
When I choose "{6} All Tickets By Milestone (Including closed)"
( http://trac.dsource.org/projects/tutorials/report/6 ), I get an error message: Code: | Report execution failed: column "modified" does not exist |
Perhaps it's caused by the fact that I don't have any active tickets or perhaps it's caused because I don't have any milestones, but it seems ticked-off about something. And there is a ticket in the system ( http://trac.dsource.org/projects/tutorials/ticket/1 ), so it can't be caused by an utter lack of tickets.
Elephant has the same issue, so I guess I don't need to feel singled out: http://trac.dsource.org/projects/elephant/report/6 |
|
Back to top |
|
|
brad Site Admin
Joined: 22 Feb 2004 Posts: 490 Location: Atlanta, GA USA
|
Posted: Thu Dec 15, 2005 7:28 pm Post subject: |
|
|
replace the SQL statement for Report 6 with this:
Code: |
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 changetime ELSE (-1)*CAST(p.value AS INT) END) DESC
|
|
|
Back to top |
|
|
jcc7
Joined: 22 Feb 2004 Posts: 657 Location: Muskogee, OK, USA
|
Posted: Thu Dec 15, 2005 11:26 pm Post subject: |
|
|
Thanks, that fixed it. |
|
Back to top |
|
|
|
|
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
|
Powered by phpBB © 2001, 2005 phpBB Group
|