close Warning: Can't synchronize with repository "(default)" (The repository directory has changed, you should resynchronize the repository with: trac-admin $ENV repository resync '(default)'). Look in the Trac log for more information.

Changes between Version 1 and Version 2 of TicketQuery


Ignore:
Timestamp:
2020-07-23T14:06:24-07:00 (4 years ago)
Author:
trac
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • TicketQuery

    v1 v2  
    11= !TicketQuery Wiki Macro
    22
    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.
     3The !TicketQuery macro lets you display ticket information anywhere that accepts WikiFormatting.
     4The query language used by the `[[TicketQuery]]` macro is described in the [TracQuery#QueryLanguage TracQuery] page.
    55
    66== Usage
     
    88[[MacroList(TicketQuery)]]
    99
    10 == Example
     10== Examples
    1111
    1212||= **Example** =||= **Result** =||= **Macro** =||
     
    4747|| **[[TicketQuery(status=closed,resolution=fixed,count)]]**||\
    4848|| `[[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)]]` ||
    4953|-----------------------------------------------------------
    5054||=Total number of tickets: =||\
     
    102106|-----------------------------------------------------------
    103107
    104 == Using the `[[TicketQuery]]` Macro
     108=== Format: list
    105109
    106 The [trac:TicketQuery TicketQuery] macro lets you display lists of tickets matching certain criteria anywhere you can use WikiFormatting.
    107 
    108 Example:
    109110{{{
    110111[[TicketQuery(version=0.6|0.7&resolution=duplicate)]]
     
    114115  [[TicketQuery(version=0.6|0.7&resolution=duplicate)]]
    115116
    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:
    117117{{{
    118118[[TicketQuery(id=123)]]
     
    122122  [[TicketQuery(id=123)]]
    123123
    124 A more compact representation without the ticket summaries is:
     124=== Format: compact
     125
    125126{{{
    126127[[TicketQuery(version=0.6|0.7&resolution=duplicate, compact)]]
     
    130131  [[TicketQuery(version=0.6|0.7&resolution=duplicate, compact)]]
    131132
    132 If you wish to receive only the number of defects that match the query, use the `count` parameter:
     133=== Format: count
     134
    133135{{{
    134136[[TicketQuery(version=0.6|0.7&resolution=duplicate, count)]]
     
    138140  [[TicketQuery(version=0.6|0.7&resolution=duplicate, count)]]
    139141
    140 A graphical use of the macro is with the `format=progress` attribute:
     142=== Format: progress
     143
    141144{{{
    142145[[TicketQuery(milestone=0.12.8&group=type,format=progress)]]
    143146}}}
    144147
    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)]]
     148This is displayed as:
     149  [[TicketQuery(milestone=0.12.8&group=type,format=progress)]]
     150
     151=== Format: table
     152
     153You 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
     158This 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
     163In ''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
     168This is displayed as:
     169[[TicketQuery(max=3,status=closed,order=id,desc=1,format=table,col=resolution|summary|owner|reporter,rows=description)]]
    147170
    148171----
    149 See also: TracQuery, TracTickets, TracReports, TracGuide
     172See also: TracQuery, TracTickets, TracReports