Changes between Version 2 and Version 3 of TicketQuery
- Timestamp:
- 05/08/22 15:10:32 (3 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
TicketQuery
v2 v3 1 1 = !TicketQuery Wiki Macro 2 2 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#UsingtheTicketQueryMacroTracQuery] page.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. 5 5 6 6 == Usage … … 8 8 [[MacroList(TicketQuery)]] 9 9 10 == Example 10 == Examples 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 |----------------------------------------------------------- 50 54 ||=Total number of tickets: =||\ 51 55 || **[[TicketQuery(count)]]**||\ … … 59 63 || **[[TicketQuery(created=thismonth..,count)]]**||\ 60 64 || `[[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)]]` || 61 89 |----------------------------------------------------------- 62 90 ||=Last 3 modified tickets: =||\ … … 78 106 |----------------------------------------------------------- 79 107 80 == Using the `[[TicketQuery]]` Macro108 === Format: list 81 109 82 The [trac:TicketQuery TicketQuery] macro lets you display lists of tickets matching certain criteria anywhere you can use WikiFormatting.83 84 Example:85 110 {{{ 86 111 [[TicketQuery(version=0.6|0.7&resolution=duplicate)]] … … 90 115 [[TicketQuery(version=0.6|0.7&resolution=duplicate)]] 91 116 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:93 117 {{{ 94 118 [[TicketQuery(id=123)]] … … 98 122 [[TicketQuery(id=123)]] 99 123 100 A more compact representation without the ticket summaries is: 124 === Format: compact 125 101 126 {{{ 102 127 [[TicketQuery(version=0.6|0.7&resolution=duplicate, compact)]] … … 106 131 [[TicketQuery(version=0.6|0.7&resolution=duplicate, compact)]] 107 132 108 If you wish to receive only the number of defects that match the query, use the `count` parameter: 133 === Format: count 134 109 135 {{{ 110 136 [[TicketQuery(version=0.6|0.7&resolution=duplicate, count)]] … … 114 140 [[TicketQuery(version=0.6|0.7&resolution=duplicate, count)]] 115 141 116 A graphical use of the macro is with the `format=progress` attribute: 142 === Format: progress 143 117 144 {{{ 118 145 [[TicketQuery(milestone=0.12.8&group=type,format=progress)]] 119 146 }}} 120 147 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)]] 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)]] 123 170 124 171 ---- 125 See also: TracQuery, TracTickets, TracReports , TracGuide172 See also: TracQuery, TracTickets, TracReports