Changes between Version 1 and Version 2 of TicketQuery

Timestamp:

Sep 14, 2021, 8:35:18 AM (3 years ago)

Author:

trac

Comment:

--

TicketQuery

@@ -1 +1 @@
 = !TicketQuery Wiki Macro
 
-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 !TicketQuery macro lets you display ticket information anywhere that accepts WikiFormatting.
+The query language used by the `[[TicketQuery]]` macro is described in the [TracQuery#QueryLanguage TracQuery] page.
 
 == Usage
@@ -8 +8 @@
 [[MacroList(TicketQuery)]]
 
-== Example
+== Examples
 
 ||= **Example** =||= **Result** =||= **Macro** =||
@@ -48 +48 @@
 || `[[TicketQuery(status=closed,resolution=fixed,count)]]` ||
 |-----------------------------------------------------------
+||=Number of untriaged tickets (milestone unset): =||\
+|| **[[TicketQuery(status!=closed,milestone=,count)]]**||\
+|| `[[TicketQuery(status!=closed,milestone=,count)]]` ||
+|-----------------------------------------------------------
 ||=Total number of tickets: =||\
 || **[[TicketQuery(count)]]**||\
@@ -59 +63 @@
 || **[[TicketQuery(created=thismonth..,count)]]**||\
 || `[[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: =||\
@@ -78 +106 @@
 |-----------------------------------------------------------
 
-== Using the `[[TicketQuery]]` Macro
+=== Format: list
 
-The [trac:TicketQuery TicketQuery] macro lets you display lists of tickets matching certain criteria anywhere you can use WikiFormatting.
-
-Example:
 {{{
 [[TicketQuery(version=0.6|0.7&resolution=duplicate)]]
@@ -90 +115 @@
   [[TicketQuery(version=0.6|0.7&resolution=duplicate)]]
 
-Just like the [wiki:TracQuery#UsingTracLinks query: wiki links], the parameter of this macro expects a query string formatted according to the rules of the simple [wiki:TracQuery#QueryLanguage ticket query language]. This also displays the link and description of a single ticket:
 {{{
 [[TicketQuery(id=123)]]
@@ -98 +122 @@
   [[TicketQuery(id=123)]]
 
-A more compact representation without the ticket summaries is:
+=== Format: compact
+
 {{{
 [[TicketQuery(version=0.6|0.7&resolution=duplicate, compact)]]
@@ -106 +131 @@
   [[TicketQuery(version=0.6|0.7&resolution=duplicate, compact)]]
 
-If you wish to receive only the number of defects that match the query, use the `count` parameter:
+=== Format: count
+
 {{{
 [[TicketQuery(version=0.6|0.7&resolution=duplicate, count)]]
@@ -114 +140 @@
   [[TicketQuery(version=0.6|0.7&resolution=duplicate, count)]]
 
-A graphical use of the macro is with the `format=progress` attribute:
+=== Format: progress
+
 {{{
 [[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)]]
+This is displayed as:
+  [[TicketQuery(milestone=0.12.8&group=type,format=progress)]]
+
+=== Format: table
+
+You can choose the columns displayed in the table format (`format=table`) using `col=<field>`. You can specify multiple fields and the order they are displayed by placing pipes (`|`) between the columns:
+{{{
+[[TicketQuery(max=3,status=closed,order=id,desc=1,format=table,col=resolution|summary|owner|reporter)]]
+}}}
+
+This is displayed as:
+[[TicketQuery(max=3,status=closed,order=id,desc=1,format=table,col=resolution|summary|owner|reporter)]]
+
+==== Full rows
+
+In ''table'' format you can specify full rows using `rows=<field>`:
+{{{
+[[TicketQuery(max=3,status=closed,order=id,desc=1,format=table,col=resolution|summary|owner|reporter,rows=description)]]
+}}}
+
+This is displayed as:
+[[TicketQuery(max=3,status=closed,order=id,desc=1,format=table,col=resolution|summary|owner|reporter,rows=description)]]
 
 ----
-See also: TracQuery, TracTickets, TracReports, TracGuide
+See also: TracQuery, TracTickets, TracReports