TicketQuery Wiki Macro
The TicketQuery macro lets you display ticket information anywhere that accepts WikiFormatting.
The query language used by the [[TicketQuery]] macro is described in the TracQuery page.
Usage
[[TicketQuery]]
Wiki macro listing tickets that match certain criteria.
This macro accepts a comma-separated list of keyed parameters, in the form "key=value".
If the key is the name of a field, the value must use the syntax
of a filter specifier as defined in TracQuery#QueryLanguage.
Note that this is not the same as the simplified URL syntax
used for query: links starting with a ? character. Commas (,)
can be included in field values by escaping them with a backslash (\).
Groups of field constraints to be OR-ed together can be separated by a
literal or argument.
In addition to filters, several other named parameters can be used to control how the results are presented. All of them are optional.
The format parameter determines how the list of tickets is
presented:
- list -- the default presentation is to list the ticket ID next to the summary, with each ticket on a separate line.
- compact -- the tickets are presented as a comma-separated list of ticket IDs.
- count -- only the count of matching tickets is displayed
- rawcount -- only the count of matching tickets is displayed, not even with a link to the corresponding query (since 1.1.1)
- table -- a view similar to the custom query view (but without the controls)
- progress -- a view similar to the milestone progress bars
The max parameter can be used to limit the number of tickets shown
(defaults to 0, i.e. no maximum).
The order parameter sets the field used for ordering tickets
(defaults to id).
The desc parameter indicates whether the order of the tickets
should be reversed (defaults to false).
The group parameter sets the field used for grouping tickets
(defaults to not being set).
The groupdesc parameter indicates whether the natural display
order of the groups should be reversed (defaults to false).
The verbose parameter can be set to a true value in order to
get the description for the listed tickets. For table format only.
deprecated in favor of the rows parameter
The rows parameter can be used to specify which field(s) should
be viewed as a row, e.g. rows=description|summary
The col parameter can be used to specify which fields should
be viewed as columns. For table format only.
For compatibility with Trac 0.10, if there's a last positional parameter
given to the macro, it will be used to specify the format.
Also, using "&" as a field separator still works (except for order)
but is deprecated.
Examples
| Example | Result | Macro |
|---|---|---|
| Number of Triage tickets: | 3 | [[TicketQuery(status=new&milestone=,count)]]
|
| Number of new tickets: | 3 | [[TicketQuery(status=new,count)]]
|
| Number of reopened tickets: | 0 | [[TicketQuery(status=reopened,count)]]
|
| Number of assigned tickets: | 0 | [[TicketQuery(status=assigned,count)]]
|
| Number of invalid tickets: | 0 | [[TicketQuery(status=closed,resolution=invalid,count)]]
|
| Number of worksforme tickets: | 5 | [[TicketQuery(status=closed,resolution=worksforme,count)]]
|
| Number of duplicate tickets: | 1 | [[TicketQuery(status=closed,resolution=duplicate,count)]]
|
| Number of wontfix tickets: | 10 | [[TicketQuery(status=closed,resolution=wontfix,count)]]
|
| Number of fixed tickets: | 23 | [[TicketQuery(status=closed,resolution=fixed,count)]]
|
| Number of untriaged tickets (milestone unset): | 4 | [[TicketQuery(status!=closed,milestone=,count)]]
|
| Total number of tickets: | 45 | [[TicketQuery(count)]]
|
| Number of tickets reported or owned by current user: | 0 | [[TicketQuery(reporter=$USER,or,owner=$USER,count)]]
|
| Number of tickets created this month: | 0 | [[TicketQuery(created=thismonth..,count)]]
|
| Number of closed Firefox tickets: | 0 | [[TicketQuery(status=closed,keywords~=firefox,count)]]
|
| Number of closed Opera tickets: | 0 | [[TicketQuery(status=closed,keywords~=opera,count)]]
|
| Number of closed tickets affecting Firefox and Opera: | 0 | [[TicketQuery(status=closed,keywords~=firefox opera,count)]]
|
| Number of closed tickets affecting Firefox or Opera: | 0 | [[TicketQuery(status=closed,keywords~=firefox|opera,count)]]
|
| Number of tickets that affect Firefox or are closed and affect Opera: | 0 | [[TicketQuery(status=closed,keywords~=opera,or,keywords~=firefox,count)]]
|
| Number of closed Firefox tickets that don't affect Opera: | 0 | [[TicketQuery(status=closed,keywords~=firefox -opera,count)]]
|
| Last 3 modified tickets: | #45, #44, #43 | [[TicketQuery(max=3,order=modified,desc=1,compact)]]
|
Details of ticket #1: |
| |
| ||
Format: list
[[TicketQuery(version=0.6|0.7&resolution=duplicate)]]
This is displayed as:
No results
[[TicketQuery(id=123)]]
This is displayed as:
No results
Format: compact
[[TicketQuery(version=0.6|0.7&resolution=duplicate, compact)]]
This is displayed as:
No results
Format: count
[[TicketQuery(version=0.6|0.7&resolution=duplicate, count)]]
This is displayed as:
Format: progress
[[TicketQuery(milestone=0.12.8&group=type,format=progress)]]
This is displayed as:
defect
30 / 31
enhancement
7 / 9
task
3 / 3
comment
1 / 2
Format: table
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 in by placing pipes (|) between the columns:
[[TicketQuery(max=3,status=closed,order=id,desc=1,format=table,col=resolution|summary|owner|reporter)]]
This is displayed as:
Results (1 - 3 of 41)
| Ticket | Resolution | Summary | Owner | Reporter |
|---|---|---|---|---|
| #43 | NoChangeNeeded | trap in netbind using R8169.OS2 | ||
| #42 | fixed | Direct NVETH and E1000E Link | ||
| #41 | fixed | r8169-1.0.0-BETA-20140202 |
Full rows
In table format you can specify full rows using rows=<field>:
[[TicketQuery(max=3,status=closed,order=id,desc=1,format=table,col=resolution|summary|owner|reporter,rows=description)]]
This is displayed as:
Results (1 - 3 of 41)
| Ticket | Resolution | Summary | Owner | Reporter |
|---|---|---|---|---|
| #43 | NoChangeNeeded | trap in netbind using R8169.OS2 | ||
| Description |
MB asus M5A 78L MLX. In addition to onboard nic I have 1gig Intel nic using your latest driver. Works fine using this: DEVICE=C:\IBMCOM\MACS\E1000E.OS2 DEVICE=C:\IBMCOM\MACS\R8110.OS2 Traps when using this: DEVICE=C:\IBMCOM\MACS\E1000E.OS2 DEVICE=C:\IBMCOM\MACS\R8169.OS2 /V From Pdump: Current slot number: 000d
*000d# 0004 0001 0004 0001 run 0300 f8c0c000 fe226020 f931114c 0f40 00 NETBIND eax=00000081 ebx=00000049 ecx=00000000 edx=00000657 esi=000003f0 edi=000003f0 eip=00000158 esp=0000151e ebp=00001542 iopl=0 -- -- -- nv up ei pl zr na pe nc cs=000f ss=001f ds=001f es=001f fs=150b gs=0000 cr2=00000000 cr3=00000000 p=00 000f:00000158 a11408 mov ax,word ptr [0814] ds:0814=0000 # ========= Nic & driver details: [C:\ibmcom\macs]bldlevel r8169.os2 Build Level Display Facility Version 6.12.675 Sep 25 2001 (C) Copyright IBM Corporation 1993-2001 Signature: @#D Azarewicz:1.0.0#@##1## 16 Feb 2014 10:12:40 DAZAR1 : :::0::SVN27@@Realtek 8169/1Gb PCIe MAC Driver Vendor: D Azarewicz Revision: 1.00.0 Date/Time: 16 Feb 2014 10:12:40 Build Machine: DAZAR1 FixPak Version: SVN27 File Version: 1.0 Description: Realtek 8169/1Gb PCIe MAC Driver Bus 2 (PCI Express), Device Number 0, Device Function 0
=========== [C:\ibmcom\macs]bldlevel e1000e.os2 Build Level Display Facility Version 6.12.675 Sep 25 2001 (C) Copyright IBM Corporation 1993-2001 Signature: @#D Azarewicz:0.2.5#@##1## 26 Jan 2014 21:49:21 DAZAR1 : :::5::SVN266@@Intel PRO/1000 PCIe MAC Driver Vendor: D Azarewicz Revision: 0.02.5 Date/Time: 26 Jan 2014 21:49:21 Build Machine: DAZAR1 FixPak Version: SVN266 File Version: 0.2.5 Description: Intel PRO/1000 PCIe MAC Driver
======= Further info: Realtek is onboard nic & assigned interface 1 - static IP. Intel is PCIe assigned interface 0 - dhcp IP. Even though I have set up the Realtek I have not plugged in a cable (this will be done when ready to replace old machine). I don't think this matters (and R8110 drivers doesn't trap w/ this setup) but thought it should be mentioned. The assigned IP for lan1 in setup.cmd is rem'd out. bldlevel netbind: Vendor: IBM Revision: 60.58 Date/Time: Fri May 21 14:12:49 2004 Build Machine: BWBLD254 ASD Feature ID: FixPak Version: WR_8708 File Version: 60.58 Description: Copyright (c) IBM, 2004 I tried the suggestions at the end of ticket #36 without success. Rgds, jon |
|||
| #42 | fixed | Direct NVETH and E1000E Link | ||
| Description |
Would it be possible to also add a direct download link for the NVETH and E1000E drivers? Like the one for the RTL. IMHO it would make the life a bit easier. |
|||
| #41 | fixed | r8169-1.0.0-BETA-20140202 | ||
| Description |
Hi David, I installed the r8169 beta driver. If i connect to Irc, or connect with FF or with mail all works well. But as soon i use Qbittorrent and i load a torrent file within 15 sec the comps hangs solid. Even the reset button don't work, have to push the on button for 5 sec and then it's rebooting. I don't know if it's relevant but with the multimac driver i had when i download several torrents or nzb files from newsgroups the comp became verry slow, seems the downloads takes all the sources to get it. Sometimes i just had to wait till downloads where done. I have a 150Mbit down and a 10mbit up I attach the trace log and the testlog |
|||
See also: TracQuery, TracTickets, TracReports
