Edgewall Software
Home
Trac
Trac Hacks
Genshi
Babel
Bitten
Home
Download
Documentation
Mailing Lists
License
FAQ
Search:
Login
Preferences
Help/Guide
About Trac
Wiki
Timeline
Roadmap
Browse Source
View Tickets
New Ticket
Search
Context Navigation
+0
Start Page
Index
History
Editing TicketQuery
Adjust edit area height:
8
12
16
20
24
28
32
36
40
Edit side-by-side
** Note: this page documents the version 1.0 of Trac, see [[0.12/TicketQuery]] if you need the previous version ** = !TicketQuery Wiki Macro = The query language used by the `[[TicketQuery]]` macro is described in [TracQuery#UsingtheTicketQueryMacro TracQuery] page. == Usage == [[MacroList(TicketQuery)]] == Example == ||= **Example** =||= **Result** =||= **Macro** =|| |----------------------------------------------------------- ||=Number of [query:status=new&milestone= Triage tickets]: =||\ ||**[[TicketQuery(status=new&milestone=,count)]]**||\ || `[[TicketQuery(status=new&milestone=,count)]]` || |----------------------------------------------------------- ||=Number of new tickets: =||\ ||**[[TicketQuery(status=new,count)]]**||\ || `[[TicketQuery(status=new,count)]]` || |----------------------------------------------------------- ||=Number of reopened tickets: =||\ ||**[[TicketQuery(status=reopened,count)]]**||\ || `[[TicketQuery(status=reopened,count)]]` || |----------------------------------------------------------- ||=Number of assigned tickets: =||\ ||**[[TicketQuery(status=assigned,count)]]**||\ || `[[TicketQuery(status=assigned,count)]]` || |----------------------------------------------------------- ||=Number of invalid tickets: =||\ ||**[[TicketQuery(status=closed,resolution=invalid,count)]]**||\ || `[[TicketQuery(status=closed,resolution=invalid,count)]]` || |----------------------------------------------------------- ||=Number of worksforme tickets: =||\ ||**[[TicketQuery(status=closed,resolution=worksforme,count)]]**||\ || `[[TicketQuery(status=closed,resolution=worksforme,count)]]` || |----------------------------------------------------------- ||=Number of duplicate tickets: =||\ ||**[[TicketQuery(status=closed,resolution=duplicate,count)]]**||\ || `[[TicketQuery(status=closed,resolution=duplicate,count)]]` || |----------------------------------------------------------- ||=Number of wontfix tickets: =||\ ||**[[TicketQuery(status=closed,resolution=wontfix,count)]]**||\ || `[[TicketQuery(status=closed,resolution=wontfix,count)]]` || |----------------------------------------------------------- ||=Number of fixed tickets: =||\ ||**[[TicketQuery(status=closed,resolution=fixed,count)]]**||\ || `[[TicketQuery(status=closed,resolution=fixed,count)]]` || |----------------------------------------------------------- ||=Total number of tickets: =||\ ||**[[TicketQuery(count)]]**||\ || `[[TicketQuery(count)]]` || |----------------------------------------------------------- ||=Number of tickets reported **or** owned by current user: =||\ ||**[[TicketQuery(reporter=$USER,or,owner=$USER,count)]]**||\ || `[[TicketQuery(reporter=$USER,or,owner=$USER,count)]]` || |----------------------------------------------------------- ||=Number of tickets created this month: =||\ ||**[[TicketQuery(created=thismonth..,count)]]**||\ || `[[TicketQuery(created=thismonth..,count)]]` || |----------------------------------------------------------- ||=Last 3 modified tickets: =||\ ||**[[TicketQuery(max=3,order=modified,desc=1,compact)]]**||\ || `[[TicketQuery(max=3,order=modified,desc=1,compact)]]` || |----------------------------------------------------------- {{{#!th rowspan=2, style="text-align: left;" Details of ticket #1: }}} {{{#!td style="border-bottom: 0;" }}} {{{#!td `[[TicketQuery(id=1,col=id|owner|reporter,rows=summary,table)]]` }}} |- {{{#!td colspan=2, style="border-top: 0;" [[TicketQuery(id=1,col=id|owner|reporter,rows=summary,table)]] }}} |----------------------------------------------------------- ---- See also: TracQuery, TracTickets, TracReports, TracGuide
Note:
See
WikiFormatting
and
TracWiki
for help on editing wiki content.
Change information
Your email or username:
E-mail address and name can be saved in the
Preferences
Comment about this change (optional):
Note:
See
TracWiki
for help on using the wiki.