Show pageOld revisionsBacklinksBack to top This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong. ====== 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. ===== Usage===== [[:[MacroList(TicketQuery)]]] ===== Example===== ^ \*\*Example\*\* ^ \*\*Result\*\* ^ \*\*Macro\*\* ^ |----------------------------------------------------------- ^ Number of \[[:query\:status|new&milestone= Triage tickets]]: =|\ | **[[:[TicketQuery(status=new&milestone=,count)]]]**|\ | `[[:[TicketQuery(status=new&milestone=,count)]]]` | |----------------------------------------------------------- ^ Number of new tickets\: |\ | **[[:[TicketQuery(status=new,count)]]]**|\ | `[[:[TicketQuery(status=new,count)]]]` | |----------------------------------------------------------- ^ Number of reopened tickets\: |\ | **[[:[TicketQuery(status=reopened,count)]]]**|\ | `[[:[TicketQuery(status=reopened,count)]]]` | |----------------------------------------------------------- ^ Number of assigned tickets\: |\ | **[[:[TicketQuery(status=assigned,count)]]]**|\ | `[[:[TicketQuery(status=assigned,count)]]]` | |----------------------------------------------------------- ^ Number of invalid tickets\: |\ | **[[:[TicketQuery(status=closed,resolution=invalid,count)]]]**|\ | `[[:[TicketQuery(status=closed,resolution=invalid,count)]]]` | |----------------------------------------------------------- ^ Number of worksforme tickets\: |\ | **[[:[TicketQuery(status=closed,resolution=worksforme,count)]]]**|\ | `[[:[TicketQuery(status=closed,resolution=worksforme,count)]]]` | |----------------------------------------------------------- ^ Number of duplicate tickets\: |\ | **[[:[TicketQuery(status=closed,resolution=duplicate,count)]]]**|\ | `[[:[TicketQuery(status=closed,resolution=duplicate,count)]]]` | |----------------------------------------------------------- ^ Number of wontfix tickets\: |\ | **[[:[TicketQuery(status=closed,resolution=wontfix,count)]]]**|\ | `[[:[TicketQuery(status=closed,resolution=wontfix,count)]]]` | |----------------------------------------------------------- ^ Number of fixed tickets\: |\ | **[[:[TicketQuery(status=closed,resolution=fixed,count)]]]**|\ | `[[:[TicketQuery(status=closed,resolution=fixed,count)]]]` | |----------------------------------------------------------- ^ Total number of tickets\: |\ | **[[:[TicketQuery(count)]]]**|\ | `[[:[TicketQuery(count)]]]` | |----------------------------------------------------------- ^ Number of tickets reported \*\*or\*\* owned by current user\: |\ | **[[:[TicketQuery(reporter=$USER,or,owner=$USER,count)]]]**|\ | `[[:[TicketQuery(reporter=$USER,or,owner=$USER,count)]]]` | |----------------------------------------------------------- ^ Number of tickets created this month\: |\ | **[[:[TicketQuery(created=thismonth..,count)]]]**|\ | `[[:[TicketQuery(created=thismonth..,count)]]]` | |----------------------------------------------------------- ^ Last 3 modified tickets\: |\ |**[[:[TicketQuery(max=3,order=modified,desc=1,compact)]]]**|\ | `[[:[TicketQuery(max=3,order=modified,desc=1,compact)]]]` | |----------------------------------------------------------- <code>#!th rowspan=2, style="text-align: left;" Details of ticket #1: </code> <code>#!td style="border-bottom: 0;" </code> <code>#!td `[[:[TicketQuery(id=1,col=id|owner|reporter,rows=summary,table)]]]` </code> |- <code>#!td colspan=2, style="border-top: 0;" [[:[TicketQuery(id=1,col=id|owner|reporter,rows=summary,table)]]] </code> |----------------------------------------------------------- ===== Using the `[[:[TicketQuery]]]` Macro===== The [[:trac:TicketQuery|TicketQuery]] macro lets you display lists of tickets matching certain criteria anywhere you can use WikiFormatting. Example: <code> [[:[TicketQuery(version=0.6|0.7&resolution=duplicate)]]] </code> This is displayed as: [[:[TicketQuery(version=0.6|0.7&resolution=duplicate)]]] Just like the [[:TracQuery#UsingTracLinks|query: wiki links]], the parameter of this macro expects a query string formatted according to the rules of the simple [[:TracQuery#QueryLanguage|ticket query language]]. This also displays the link and description of a single ticket: <code> [[:[TicketQuery(id=123)]]] </code> This is displayed as: [[:[TicketQuery(id=123)]]] A more compact representation without the ticket summaries is: <code> [[:TicketQuery(version=0.6|0.7&resolution=duplicate,|compact)]] </code> This is displayed as: [[: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: <code> [[:TicketQuery(version=0.6|0.7&resolution=duplicate,|count)]] </code> This is displayed as: [[:TicketQuery(version=0.6|0.7&resolution=duplicate,|count)]] A graphical use of the macro is with the `format=progress` attribute: <code> [[:[TicketQuery(milestone=0.12.8&group=type,format=progress)]]] </code> 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 ticketquery.txt Last modified: 2020/07/17 18:33(external edit)