Modify

#10936 closed task (worksforme)

REPORT: Active Ticket query help

Reported by: akliewer99 Owned by: falkb
Priority: normal Component: SimpleMultiProjectPlugin
Severity: normal Keywords:
Cc: Trac Release: 1.0

Description

Can you provide the proper SQL syntax for the "Active Tickets" report screen?

I'm not sure how to join the tables in my sql statement. Thanks again for your time! Arlene Kliewer :) Sacramento, CA

Attachments (1)

REPORT_ActiveTickets.png (411.6 KB) - added by akliewer99 22 months ago.
screen print

Download all attachments as: .zip

Change History (3)

Changed 22 months ago by akliewer99

screen print

comment:1 Changed 22 months ago by falkb

  • Owner changed from crossroad to falkb
  • Status changed from new to assigned

Could you try to use a ticket query instead of SQL? I think it's also possible in that "Active tickets" and this level of access should be more appropriate (because it e.g. uses the ticket cache):

query:?status=!closed
&
col=id
&
col=summary
&
col=project
&
col=component
&
col=version
&
col=milestone
&
col=priority
&
col=type
&
col=status
&
order=priority

comment:2 Changed 21 months ago by falkb

  • Resolution set to worksforme
  • Status changed from assigned to closed

timeout

Add Comment

Modify Ticket

Action
as closed The owner will remain falkb.
The resolution will be deleted. Next status will be 'reopened'.
Author


E-mail address and user name can be saved in the Preferences.

 
Note: See TracTickets for help on using tickets.