Changes between Version 1 and Version 2 of TicketQuery
- Timestamp:
- Jan 30, 2019, 11:46:21 PM (5 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
TicketQuery
v1 v2 1 1 = !TicketQuery Wiki Macro 2 2 3 The !TicketQuery macro lets you display ticket information anywhere that accepts WikiFormatting.4 The query language used by the `[[TicketQuery]]` macro is described in the [TracQuery#QueryLanguageTracQuery] page.3 The !TicketQuery macro lets you display information on tickets within wiki pages. 4 The query language used by the `[[TicketQuery]]` macro is described in [TracQuery#UsingtheTicketQueryMacro TracQuery] page. 5 5 6 6 == Usage … … 8 8 [[MacroList(TicketQuery)]] 9 9 10 == Example s10 == Example 11 11 12 12 ||= **Example** =||= **Result** =||= **Macro** =|| … … 48 48 || `[[TicketQuery(status=closed,resolution=fixed,count)]]` || 49 49 |----------------------------------------------------------- 50 ||=Number of untriaged tickets (milestone unset): =||\51 || **[[TicketQuery(status!=closed,milestone=,count)]]**||\52 || `[[TicketQuery(status!=closed,milestone=,count)]]` ||53 |-----------------------------------------------------------54 50 ||=Total number of tickets: =||\ 55 51 || **[[TicketQuery(count)]]**||\ … … 63 59 || **[[TicketQuery(created=thismonth..,count)]]**||\ 64 60 || `[[TicketQuery(created=thismonth..,count)]]` || 65 |-----------------------------------------------------------66 ||=Number of closed Firefox tickets: =||\67 || **[[TicketQuery(status=closed,keywords~=firefox,count)]]**||\68 || `[[TicketQuery(status=closed,keywords~=firefox,count)]]` ||69 |-----------------------------------------------------------70 ||=Number of closed Opera tickets: =||\71 || **[[TicketQuery(status=closed,keywords~=opera,count)]]**||\72 || `[[TicketQuery(status=closed,keywords~=opera,count)]]` ||73 |-----------------------------------------------------------74 ||=Number of closed tickets affecting Firefox and Opera: =||\75 || **[[TicketQuery(status=closed,keywords~=firefox opera,count)]]**||\76 || `[[TicketQuery(status=closed,keywords~=firefox opera,count)]]` ||77 |-----------------------------------------------------------78 ||=Number of closed tickets affecting Firefox or Opera: =||\79 || **[[TicketQuery(status=closed,keywords~=firefox|opera,count)]]**||\80 || `[[TicketQuery(status=closed,keywords~=firefox|opera,count)]]` ||81 |-----------------------------------------------------------82 ||=Number of tickets that affect Firefox or are closed and affect Opera: =||\83 || **[[TicketQuery(keywords~=firefox,or,status=closed,keywords~=opera,count)]]**||\84 || `[[TicketQuery(status=closed,keywords~=opera,or,keywords~=firefox,count)]]` ||85 |-----------------------------------------------------------86 ||=Number of closed Firefox tickets that don't affect Opera: =||\87 || **[[TicketQuery(status=closed,keywords~=firefox - opera,count)]]**||\88 || `[[TicketQuery(status=closed,keywords~=firefox -opera,count)]]` ||89 61 |----------------------------------------------------------- 90 62 ||=Last 3 modified tickets: =||\ … … 106 78 |----------------------------------------------------------- 107 79 108 == = Format: list80 == Using the `[[TicketQuery]]` Macro 109 81 82 The [trac:TicketQuery TicketQuery] macro lets you display lists of tickets matching certain criteria anywhere you can use WikiFormatting. 83 84 Example: 110 85 {{{ 111 86 [[TicketQuery(version=0.6|0.7&resolution=duplicate)]] … … 115 90 [[TicketQuery(version=0.6|0.7&resolution=duplicate)]] 116 91 92 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: 117 93 {{{ 118 94 [[TicketQuery(id=123)]] … … 122 98 [[TicketQuery(id=123)]] 123 99 124 === Format: compact 125 100 A more compact representation without the ticket summaries is: 126 101 {{{ 127 102 [[TicketQuery(version=0.6|0.7&resolution=duplicate, compact)]] … … 131 106 [[TicketQuery(version=0.6|0.7&resolution=duplicate, compact)]] 132 107 133 === Format: count 134 108 If you wish to receive only the number of defects that match the query, use the `count` parameter: 135 109 {{{ 136 110 [[TicketQuery(version=0.6|0.7&resolution=duplicate, count)]] … … 140 114 [[TicketQuery(version=0.6|0.7&resolution=duplicate, count)]] 141 115 142 === Format: progress 143 116 A graphical use of the macro is with the `format=progress` attribute: 144 117 {{{ 145 118 [[TicketQuery(milestone=0.12.8&group=type,format=progress)]] 146 119 }}} 147 120 148 This is displayed as: 149 [[TicketQuery(milestone=0.12.8&group=type,format=progress)]] 150 151 === Format: table 152 153 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: 154 {{{ 155 [[TicketQuery(max=3,status=closed,order=id,desc=1,format=table,col=resolution|summary|owner|reporter)]] 156 }}} 157 158 This is displayed as: 159 [[TicketQuery(max=3,status=closed,order=id,desc=1,format=table,col=resolution|summary|owner|reporter)]] 160 161 ==== Full rows 162 163 In ''table'' format you can specify full rows using `rows=<field>`: 164 {{{ 165 [[TicketQuery(max=3,status=closed,order=id,desc=1,format=table,col=resolution|summary|owner|reporter,rows=description)]] 166 }}} 167 168 This is displayed as: 169 [[TicketQuery(max=3,status=closed,order=id,desc=1,format=table,col=resolution|summary|owner|reporter,rows=description)]] 121 For example for one of the upcoming milestones, bars are shown by ticket type: 122 [[TicketQuery(milestone=0.12.8&group=type,format=progress)]] 170 123 171 124 ---- 172 See also: TracQuery, TracTickets, TracReports 125 See also: TracQuery, TracTickets, TracReports, TracGuide