Modify

Opened 4 years ago

Closed 4 years ago

#10936 closed task (worksforme)

REPORT: Active Ticket query help

Reported by: Arlene M Kliewer 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 Arlene M Kliewer 4 years ago.
screen print

Download all attachments as: .zip

Change History (3)

Changed 4 years ago by Arlene M Kliewer

Attachment: REPORT_ActiveTickets.png added

screen print

comment:1 Changed 4 years ago by falkb

Owner: changed from Christopher Paredes to falkb
Status: newassigned

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 4 years ago by falkb

Resolution: worksforme
Status: assignedclosed

timeout

Modify Ticket

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

Add Comment


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

 
Note: See TracTickets for help on using tickets.