Modify ↓

Opened 11 years ago

Closed 11 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 11 years ago.
screen print

Download all attachments as: .zip

Change History (3)

Changed 11 years ago by Arlene M Kliewer

Attachment: REPORT_ActiveTickets.png​ added

screen print

comment:1 Changed 11 years ago by falkb

Owner: changed from Christopher Paredes to falkb
Status: new → 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 11 years ago by falkb

Resolution: → worksforme
Status: assigned → closed

timeout

Modify Ticket

Change Properties
Set your email in Preferences
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.

Attachments ↑ Description ↑
 
Note: See TracTickets for help on using tickets.