FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

Trac report

 
Post new topic   Reply to topic     Forum Index -> Site
View previous topic :: View next topic  
Author Message
Carlos



Joined: 19 Mar 2004
Posts: 396
Location: Canyon, TX

PostPosted: Fri Dec 09, 2005 3:59 pm    Post subject: Trac report Reply with quote

Brad,
there seems to be a problem with all the "All tickets by milestone" reports. I thought it was only for DDL, so I created a new ticket there (http://trac.dsource.org/projects/ddl/ticket/21) (which Pragma already solved), but the problem also exists with Mango (http://trac.dsource.org/projects/mango/report/6) and Build (http://trac.dsource.org/projects/build/report/6), so the problem seems to be with Trac.
Back to top
View user's profile Send private message Yahoo Messenger MSN Messenger
brad
Site Admin


Joined: 22 Feb 2004
Posts: 490
Location: Atlanta, GA USA

PostPosted: Fri Dec 09, 2005 5:04 pm    Post subject: Reply with quote

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
View user's profile Send private message
jcc7



Joined: 22 Feb 2004
Posts: 657
Location: Muskogee, OK, USA

PostPosted: Thu Dec 15, 2005 7:06 pm    Post subject: Reply with quote

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
View user's profile Send private message AIM Address
brad
Site Admin


Joined: 22 Feb 2004
Posts: 490
Location: Atlanta, GA USA

PostPosted: Thu Dec 15, 2005 7:28 pm    Post subject: Reply with quote

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
View user's profile Send private message
jcc7



Joined: 22 Feb 2004
Posts: 657
Location: Muskogee, OK, USA

PostPosted: Thu Dec 15, 2005 11:26 pm    Post subject: Reply with quote

Thanks, that fixed it. Smile
Back to top
View user's profile Send private message AIM Address
Display posts from previous:   
Post new topic   Reply to topic     Forum Index -> Site All times are GMT - 6 Hours
Page 1 of 1

 
Jump to:  
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