Changes between Version 2 and Version 3 of TicketQuery
- Timestamp:
- 2018-10-05T12:10:06+10:00 (6 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
TicketQuery
v2 v3 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#QueryLanguage TracQuery] 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#QueryLanguage TracQuery] page. 5 5 6 6 == Usage … … 8 8 [[MacroList(TicketQuery)]] 9 9 10 == Example s10 == Example 11 11 12 12 ||= **Example** =||= **Result** =||= **Macro** =|| … … 47 47 || **[[TicketQuery(status=closed,resolution=fixed,count)]]**||\ 48 48 || `[[TicketQuery(status=closed,resolution=fixed,count)]]` || 49 |-----------------------------------------------------------50 ||=Number of untriaged tickets (milestone unset): =||\51 || **[[TicketQuery(status!=closed,milestone=,count)]]**||\52 || `[[TicketQuery(status!=closed,milestone=,count)]]` ||53 49 |----------------------------------------------------------- 54 50 ||=Total number of tickets: =||\ … … 106 102 |----------------------------------------------------------- 107 103 108 == = Format: list104 == Using the `[[TicketQuery]]` Macro 109 105 106 The [trac:TicketQuery TicketQuery] macro lets you display lists of tickets matching certain criteria anywhere you can use WikiFormatting. 107 108 Example: 110 109 {{{ 111 110 [[TicketQuery(version=0.6|0.7&resolution=duplicate)]] … … 115 114 [[TicketQuery(version=0.6|0.7&resolution=duplicate)]] 116 115 116 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 117 {{{ 118 118 [[TicketQuery(id=123)]] … … 122 122 [[TicketQuery(id=123)]] 123 123 124 === Format: compact 125 124 A more compact representation without the ticket summaries is: 126 125 {{{ 127 126 [[TicketQuery(version=0.6|0.7&resolution=duplicate, compact)]] … … 131 130 [[TicketQuery(version=0.6|0.7&resolution=duplicate, compact)]] 132 131 133 === Format: count 134 132 If you wish to receive only the number of defects that match the query, use the `count` parameter: 135 133 {{{ 136 134 [[TicketQuery(version=0.6|0.7&resolution=duplicate, count)]] … … 140 138 [[TicketQuery(version=0.6|0.7&resolution=duplicate, count)]] 141 139 142 === Format: progress 143 140 A graphical use of the macro is with the `format=progress` attribute: 144 141 {{{ 145 142 [[TicketQuery(milestone=0.12.8&group=type,format=progress)]] 146 143 }}} 147 144 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)]] 145 For example for one of the upcoming milestones, bars are shown by ticket type: 146 [[TicketQuery(milestone=0.12.8&group=type,format=progress)]] 170 147 171 148 ---- 172 See also: TracQuery, TracTickets, TracReports 149 See also: TracQuery, TracTickets, TracReports, TracGuide