Changes between Version 1 and Version 2 of TicketQuery

Timestamp:

Jul 17, 2018, 2:11:03 PM (6 years ago)

Author:

trac

Comment:

--

TicketQuery

@@ -2 +2 @@
 
 The !TicketQuery macro lets you display information on tickets within wiki pages.
-The query language used by the `[[TicketQuery]]` macro is described in [TracQuery#UsingtheTicketQueryMacro TracQuery] page.
+The query language used by the `[[TicketQuery]]` macro is described in [TracQuery#QueryLanguage TracQuery] page.
 
 == Usage
@@ -60 +60 @@
 || `[[TicketQuery(created=thismonth..,count)]]` ||
 |-----------------------------------------------------------
+||=Number of closed Firefox tickets: =||\
+|| **[[TicketQuery(status=closed,keywords~=firefox,count)]]**||\
+|| `[[TicketQuery(status=closed,keywords~=firefox,count)]]` ||
+|-----------------------------------------------------------
+||=Number of closed Opera tickets: =||\
+|| **[[TicketQuery(status=closed,keywords~=opera,count)]]**||\
+|| `[[TicketQuery(status=closed,keywords~=opera,count)]]` ||
+|-----------------------------------------------------------
+||=Number of closed tickets affecting Firefox and Opera: =||\
+|| **[[TicketQuery(status=closed,keywords~=firefox opera,count)]]**||\
+|| `[[TicketQuery(status=closed,keywords~=firefox opera,count)]]` ||
+|-----------------------------------------------------------
+||=Number of closed tickets affecting Firefox or Opera: =||\
+|| **[[TicketQuery(status=closed,keywords~=firefox|opera,count)]]**||\
+|| `[[TicketQuery(status=closed,keywords~=firefox|opera,count)]]` ||
+|-----------------------------------------------------------
+||=Number of tickets that affect Firefox or are closed and affect Opera: =||\
+|| **[[TicketQuery(keywords~=firefox,or,status=closed,keywords~=opera,count)]]**||\
+|| `[[TicketQuery(status=closed,keywords~=opera,or,keywords~=firefox,count)]]` ||
+|-----------------------------------------------------------
+||=Number of closed Firefox tickets that don't affect Opera: =||\
+|| **[[TicketQuery(status=closed,keywords~=firefox - opera,count)]]**||\
+|| `[[TicketQuery(status=closed,keywords~=firefox -opera,count)]]` ||
+|-----------------------------------------------------------
 ||=Last 3 modified tickets: =||\
 ||**[[TicketQuery(max=3,order=modified,desc=1,compact)]]**||\
@@ -106 +130 @@
   [[TicketQuery(version=0.6|0.7&resolution=duplicate, compact)]]
 
-Finally, if you wish to receive only the number of defects that match the query, use the `count` parameter:
+If you wish to receive only the number of defects that match the query, use the `count` parameter:
 {{{
 [[TicketQuery(version=0.6|0.7&resolution=duplicate, count)]]
@@ -114 +138 @@
   [[TicketQuery(version=0.6|0.7&resolution=duplicate, count)]]
 
+A graphical use of the macro is with the `format=progress` attribute:
+{{{
+[[TicketQuery(milestone=0.12.8&group=type,format=progress)]]
+}}}
+
+For example for one of the upcoming milestones, bars are shown by ticket type:
+[[TicketQuery(milestone=0.12.8&group=type,format=progress)]]
+
 ----
 See also: TracQuery, TracTickets, TracReports, TracGuide