Trac Ticket Queries

In addition to reports, Trac provides support for custom ticket queries, used to display lists of tickets meeting a specified set of criteria.

To configure and execute a custom query, switch to the View Tickets module from the navigation bar, and select the Custom Query link.

Filters

When you first go to the query page the default filters will display all open tickets, or if you're logged in it will display open tickets assigned to you. Current filters can be removed by clicking the button to the right with the minus sign on the label. New filters are added from the pulldown list in the bottom-right corner of the filters box. Filters with either a text box or a pulldown menu of options can be added multiple times to perform an or of the criteria.

You can use the fields just below the filters box to group the results based on a field, or display the full description for each ticket.

Once you've edited your filters click the Update button to refresh your results.

Navigating Tickets

Clicking on one of the query results will take you to that ticket. You can navigate through the results by clicking the Next Ticket or Previous Ticket links just below the main menu bar, or click the Back to Query link to return to the query page.

You can safely edit any of the tickets and continue to navigate through the results using the Next/Previous/Back? to Query links after saving your results. When you return to the query any tickets which was edited will be displayed with italicized text. If one of the tickets was edited such that it no longer matches the query criteria the text will also be greyed. Lastly, if a new ticket matching the query critera has been created, it will be shown in bold.

The query results can be refreshed and cleared of these status indicators by clicking the Update button again.

Saving Queries

While Trac does not yet allow saving a named query and somehow making it available in a navigable list, you can save references to queries in Wiki content, as described below.

Using TracLinks

You may want to save some queries so that you can come back to them later. You can do this by making a link to the query from any Wiki page.

[query:status=new|assigned|reopened&version=1.0 Active tickets against 1.0]

Which is displayed as:

Active tickets against 1.0

This uses a very simple query language to specify the criteria (see Query Language).

Alternatively, you can copy the query string of a query and paste that into the Wiki link, including the leading ? character:

[query:?status=new&status=assigned&status=reopened&group=owner Assigned tickets by owner]

Which is displayed as:

Assigned tickets by owner

Using the [[TicketQuery]] Macro

The [[TicketQuery]] macro lets you display lists of tickets matching certain criteria anywhere you can use WikiFormatting.

Example:

[[TicketQuery(version=1.0|2.0&resolution=duplicate)]]

This is displayed as:

#20

Rename core functions into the purple_* namespace.

#28

Trac & Monotone Integration

#38

Stop doing blocking file IO

#107

Crash RTP report

#145

not able to view html codes/brackets

#160

HACKING file update

#171

Pidgin Perl Plugin won't build

#186

HTTP GET Proxy support

#189

Nickname in panel doesn't change on highlight

#191

Need to be able to customize theme on per-buddy basis

#229

Does not display own buddy avatar picture in the buddy list or conversation

#243

GAIM crash on Fedora Core 6, x86_64 on Athlon 64-X2

#251

BITMAPV5HEADER, compile failure

#253

Tooltip icons layout

#263

Sort by recent log size

#269

Office Communicator Support

#272

Pidgin not showing buddy icons of contacts using MSN LIVE messenger

#279

Logging in XML

#282

Misleading message about cancelled file transfer when transmitted successfully

#290

Implement (if possible) offline Messages for MSN

#294

use GTK's tab reordering if available

#298

Notify on birthdays (red balloon in the roster)

#323

Fix compiler warnings

#328

trac searches come up with stale changesets

#346

IRC Re-connect Re-join

#381

MSN chat hard to figure out

#394

SIGABRT on sound play

#404

Copy without selection clears clipboard

#419

You dont the See Which Protocol

#420

You dont the See Which Protocol

#421

You dont the See Which Protocol

#423

When im logging im getting a failure

#424

When im logging im getting a failure

#425

When im logging im getting a failure

#426

When im logging im getting a failure

#428

When im logging im getting a failure

#429

You dont the See Which Protocol

#430

When im logging im getting a failure

#434

Taskbar Has Wrong Symbol

#435

"Get Info "on Idle AIM user causes a crash

#438

Support Windows Live (MSN) and Yahoo integration

#448

Status at Startup preference is not saving on restart

#449

crash when viewing profiles of idle AIM buddies

#455

Pidgwin Plugin startup with Windows fails

#462

new net-pmp.c implementation breaks solaris build

#472

Incorrect registry entry for(Start Pidgin when Windows Starts)

#474

No Option to Reveal Protocol Icon

#487

Protocol icons

#490

"Get info" on available AIM user w/ message crash

#501

pidgin windows plugin creates link to purple.exe and not pidgin.exe

#508

Crash signing on yahoo - buddy icon-related

#509

Crash when deleting buddy and cab plugin is loaded

#510

Sound Event for receiving an email

#513

New ICQ messages not displayed after resuming from standby

#522

Names in IM window

#531

Mail notification opens mail details window

#536

2.0.0b7 Yahoo buddy icon update: intermittant crash

#544

ICQ - Wrong encoding used to display buddy info

#546

File chooser does not show file list immediatly after opening

#548

status message MSN

#558

Unable to add Buddy 1??

#562

case for old icons: Advantagous heuristics of differentiated protocol icons

#564

Buddy List width keeps increasing due to yahoo mail notification

#570

pidgin crashes when i type in yahoo chat

#572

if the network goes down the user doesn't understand that he is offline

#577

'Unable To Add' Error on Startup

#581

special characters in away messages doesn't appear correctly

#584

Have to Re-request authorization when moving buddy to another group

#609

crash when editing sound preferences - doz

#611

Bring back protocol icons for each buddy (existed in GAIM - gone in Pidgin)

#613

ability to manipulate sound level (increase/decrease sound)

#621

Pidgin crashes when logging into Yahoo with duplicate friends

#627

Winpidgin file browser broken

#630

Buddy Icon window displays improperly on first open

#638

Have a user prefrence for single instance of pidgin which overrides default behavior

#639

Pidgin 2 Final Crashing when logging on to Yahoo.

#643

ICQ file transfer with Trillian Clients doesn't work.

#646

Plugin "Converstion Colors" disable RTL support

#651

online indicators missing service icon

#652

Installation aspell 404 error

#655

Crash when connecting to google

#658

On Screen Display (OSD)

#676

Duplicate users

#677

msimprpl needs Tango love

#680

Release notification plugin finds no information

#682

hardcoded colors

#684

Budy List Synchronization Issue - Pidgin Crashes

#686

GUI to remove a smiley theme

#688

Lock table out of available locker entries Trac error while trying to browse source

#691

Option to hide winpidgin-buddylist from Taskbar

#694

Bad look of website in Opera browser

#695

Umlauts-troubles in ICQ-Profiles

#701

similar problem to ticket #592 (no google talk connection), however SSL is enabled and connection still not possible

#706

Crash after removing user from userlist.

#709

trac internal server errors

#710

Pidgin 2.0.0 yahoo crash

#712

404 not found: http://pidgin.im/win32/download_redir.php

#713

Error when adding Yahoo account

#717

erroneous 'new version available' dialog

#722

Umlauts not displayed correctly

#727

icon update dialog box does not list files unless resized

#734

Re-authorization when moving ICQ contact to another group?

#737

Update notification plugin not function

#741

please bring back protocol specific icons

#745

Version check reports wrong info on connection error

#757

"Error Installing Spellchecker : HTTP/1.1 404 Not Found"

#759

Buddy list synchronization issue (crash on start)

#762

ICQ offline messages come with broken coding if in Russian

#768

Crash on Windows XP

#773

Link in win32 installer leads to a 404

#778

Dragging contacts results in deletion.

#782

"Away" protocols improperly reordered

#790

Pidgen crashes when you attempt to add yahoo accounts.

#797

crash on ICQ logout

#798

version.php Does Not Exist

#816

Yahoo system messages display entity reference instead of the appropriate character

#818

Crash (Null dereference?) in purple_presence_get_status()

#820

Moving user between two other users should not expand them

#827

Adding Yahoo account causes Pidgin to Crash

#829

ICQ buddy info character encoding problem

#831

purple_presence_destroy() crashing in purple_status_destroy() after msn_complete_sync_issue()

#832

Crashes when trying to enable ICQ account

#833

Pidgin crashes when I attempt to start it in Windows XP MCE

#834

windows crash

#861

Pidgin crashes when trying to create yahoo account

#863

Pidgin crashes when removing an XMPP account

#865

Pidgin can't receive files using Yahoo file transfer

#868

Crash on windows when removing a contact

#869

Pidgin Crashes when loading

#871

Crash on Windows when signing in to Yahoo

#872

Fix clipboard handling

#873

libpurple.dll error when starting program

#875

An account cannot be deleted

#877

pidgin crash on removal of own jabber contact

#878

News Page is broken

#879

AIM Account Not Logging In

#881

ESC does not exit out of IMs

#883

crash on list synchronization

#885

http://pidgin.im/l10n does not exist any more

#887

[i18n] problem in the fr translation in a error msg

#888

Yahoo popup isn't correctly escaping the html

#893

When I move contacts to another group they get deleted

#894

Apply Buddy Pounce for every account of a contact

#895

Apply Buddy-Alarm for every account of a contact

#900

crashing when run immediately after install windowsxp sp2

#902

crashes loading

#903

Google Talk and MSN will not work through HTTP proxy (maybe which only allows 80 and 443 but TLS option is not available)

#905

Buddy Icons

#906

Pidgin Crash After Install

#907

Pidgin Crash After Install

#909

Conversation window entry field default size

#910

Buddy icons as window icons should be optional

#913

application error @ 0x00038d9d

#918

Font buttons in the IM interface

#922

Storing logs by date

#923

Storing pictures/files in logs

#924

Alias editing will close

#930

Yahoo file transfer, says cancelled when actually completed

#931

Away Message

#936

Incomming messages from QIP uses Cyrillic characters instead of accented latin

#941

Program crashed, doesn't restart, uninstall/reinstall and debug won't work

#942

Pidgin crash

#946

Synchronization popups

#947

Synchronization popups

#961

Pingin crashes when minimized and I try to resize it

#982

crash after attempt to choose sound

#986

add msn webcam support

#987

Pidgin crashes when connecting to a Yahoo account

#994

AIM/oscar: status messages are not set while status is "available".

#996

crash when disabling accounts

#997

Timeout for pounce windows

#1004

Importation of Logs from LAIM

#1005

Crash when it's just started to run.

#1006

Your contact is using Windows Live Messenger

#1007

XMPP needs "Priority" setting

#1009

ICQ Privacy Sucks

#1012

adding a account type icon?

#1014

windows crash when modify friend list

#1015

Pidgin crashed on buddy deletion

#1016

Pidgin crashes on Linux and Windows when trying to synchronize MSN contact list

#1020

Bring back the protocol icons

#1022

Crash while logging to jabber

#1023

sorry for nudging but... i want to nudge a friend with a button.

#1026

Logged in time calculated wrong...

#1027

Windows crash stating "the memory could not be "read"

#1028

Pidgin Crash after modifying friends list in Yahoo.

#1033

adding YIM the program crashes

#1035

Cannot login into any account through a proxy

#1041

Crash when adding Yahoo! account

#1048

Pidgin (Windows) Crashes / Faulting Module libpurple.dll / Fault Address 0x00038d9d

#1055

Web page links (blogs) do not seem to work.

#1057

Notify on status message change

#1059

Pidgin crashes as soon as it opens

#1067

crashes consistently when trying to set up my Yahoo acct

#1068

Autoreconnect

#1074

Prevent auto-away replies overriding Away status messages

#1080

Unblock Account will fail every time

#1083

Pidign crashes right after launch before Buddylist loads

#1084

Pidign crashes right after launch before Buddylist loads

#1085

Pidgin Seg Faults When Adding Yahoo Account

#1089

Duplication jabber buddy after authorization

#1091

Pidgin 2.0.0 crashes on startup after entering password for accounts

#1093

Another error when compiling on Solaris 10 x86

#1098

Unify taskbar icon

#1099

Unify taskbar icon

#1101

Avatars dissapearing.

#1107

Pidgin segfaults before I get a chance to touch anything!

#1108

Protocol icons - bring 'em back.

#1110

Pidgin crashes because I am on my own contacts list

#1114

"Away" buddy in a contact shown as "offline"

#1119

ICQ: Default to windows default 8 bit encoding for region depending on locale

#1128

Font problems

#1133

Crash in WindowsXP 64bit

#1134

Retirement plans

#1141

Pidgin encounters error immediately as its started

#1146

Startup crash after creating new groups and moving people

#1149

Pidgin Crashes When Opening

#1152

Different System Tray Icon when Disconnected / Half Connected

#1153

Invite in msn chat with "drag and drop"

#1155

My pidgin is crashing

#1161

pidgin crash deleting MSN account

#1164

Win32 crash on yahoo startup

#1166

Pidgin crashes immediately on creation of Yahoo account

#1171

Adding duplicate (ICQ) Buddy crashes Pidgin

#1172

NEWS page broken

#1173

Pidgin crashes immediately on startup

#1174

Pidgin crashes immediately on startup

#1176

Pidgin crashes upon startup

#1179

Buddy autoswitching with metacontacts should be optional

#1186

Misreports file size for large file transfers

#1192

Error in lib purple

#1201

Macedonian Translation Updated

#1206

need working jabber file transfers with proxies and jingle

#1207

Pidgin crashing all of a sudden

#1209

Crash shortly after starting

#1212

crash on exit from tray

#1213

On Windows, Chinese characters from MSN messenger are garbled

#1216

Crashes immediately, but shows with yahoo i'm online

#1218

Buddy List should show special status icons/emblems for buddies user has conversations open with

#1221

Reconsider: An option to switch on protocol icons for those who need them

#1224

Crash on Delete Account.

#1231

Flashing only once

#1232

detect pidgin already running on start

#1234

Pidgin crashes on startup when attempting to connect to YIM

#1239

pidgin crashes after ~13 min in group chat

#1240

gaim crashes when i open it

#1244

Pidgin crashes when you enable a Yahoo account

#1253

KDE User Icons Interfere with Buddy Icon

#1255

Pictures cannot be shown correctly

#1272

Buddy alias gets stored on the server

Just like the query: wiki links, the parameter of this macro expects a query string formatted according to the rules of the simple ticket query language.

A more compact representation without the ticket summaries is also available:

[[TicketQuery(version=1.0|2.0&resolution=duplicate, compact)]]

This is displayed as:

#20, #28, #38, #107, #145, #160, #171, #186, #189, #191, #229, #243, #251, #253, #263, #269, #272, #279, #282, #290, #294, #298, #323, #328, #346, #381, #394, #404, #419, #420, #421, #423, #424, #425, #426, #428, #429, #430, #434, #435, #438, #448, #449, #455, #462, #472, #474, #487, #490, #501, #508, #509, #510, #513, #522, #531, #536, #544, #546, #548, #558, #562, #564, #570, #572, #577, #581, #584, #609, #611, #613, #621, #627, #630, #638, #639, #643, #646, #651, #652, #655, #658, #676, #677, #680, #682, #684, #686, #688, #691, #694, #695, #701, #706, #709, #710, #712, #713, #717, #722, #727, #734, #737, #741, #745, #757, #759, #762, #768, #773, #778, #782, #790, #797, #798, #816, #818, #820, #827, #829, #831, #832, #833, #834, #861, #863, #865, #868, #869, #871, #872, #873, #875, #877, #878, #879, #881, #883, #885, #887, #888, #893, #894, #895, #900, #902, #903, #905, #906, #907, #909, #910, #913, #918, #922, #923, #924, #930, #931, #936, #941, #942, #946, #947, #961, #982, #986, #987, #994, #996, #997, #1004, #1005, #1006, #1007, #1009, #1012, #1014, #1015, #1016, #1020, #1022, #1023, #1026, #1027, #1028, #1033, #1035, #1041, #1048, #1055, #1057, #1059, #1067, #1068, #1074, #1080, #1083, #1084, #1085, #1089, #1091, #1093, #1098, #1099, #1101, #1107, #1108, #1110, #1114, #1119, #1128, #1133, #1134, #1141, #1146, #1149, #1152, #1153, #1155, #1161, #1164, #1166, #1171, #1172, #1173, #1174, #1176, #1179, #1186, #1192, #1201, #1206, #1207, #1209, #1212, #1213, #1216, #1218, #1221, #1224, #1231, #1232, #1234, #1239, #1240, #1244, #1253, #1255, #1272

Query Language

query: TracLinks and the [[TicketQuery]] macro both use a mini “query language” for specifying query filters. Basically, the filters are separate by ampersands (&). Each filter then consists of the ticket field name, an operator, and one or more values. More than one value are separated by a pipe (|), meaning that the filter matches any of the values.

The available operators are:

=	the field content exactly matches the one of the values
~=	the field content contains one or more of the values
^=	the field content starts with one of the values
$=	the field content ends with one of the values

All of these operators can also be negated:

!=	the field content matches none of the values
!~=	the field content does not contain any of the values
!^=	the field content does not start with any of the values
!$=	the field content does not end with any of the values

---

See also: TracTickets, TracReports, TracGuide