Trac Ticket Queries
Table of Contents
In addition to reports, Trac provides support for custom ticket queries, which can be used to display tickets that meet specified 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 filter will display tickets relevant to you:
- If logged in then all open tickets, it will display open tickets assigned to you.
- If not logged in but you have specified a name or email address in the preferences, then it will display all open tickets where your email (or name if email not defined) is in the CC list.
- If not logged in and no name/email is defined in the preferences, then all open issues are displayed.
Current filters can be removed by clicking the button to the left with the minus sign on the label. New filters are added from the pulldown lists at the bottom corners of the filters box; 'And' conditions on the left, 'Or' conditions on the right. Filters with either a text box or a pulldown menu of options can be added multiple times to perform an Or on 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.
After you have 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 were 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 criteria 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
Trac allows you to save the query as a named query accessible from the reports module. To save a query ensure that you have Updated the view and then click the Save query button displayed beneath the results. You can also save references to queries in Wiki content, as described below.
Note: one way to easily build queries like the ones below, you can build and test the queries in the Custom report module and when ready - click Save query. This will build the query string for you. All you need to do is remove the extra line breaks.
Note: you must have the REPORT_CREATE permission in order to save queries to the list of default reports. The Save query button will only appear if you are logged in as a user that has been granted this permission. If your account does not have permission to create reports, you can still use the methods below to save a query.
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:
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:
Customizing the table format
You can also customize the columns displayed in the table format (format=table) by using col=<field>. You can specify multiple fields and what 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 106)
Full rows
In table format you can also have full rows by 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 106)
| Ticket | Resolution | Summary | Owner | Reporter |
|---|---|---|---|---|
| #136 | fixed | Compilation of webcourse grammar fails | ke | ke |
| Description |
p264360@pales:~/workspace/kahina/src/org/kahina/tralesld/test/webcourse$ trale -sd Using Trale system found in /home/p264360/dev/trale Starting Trale (no saved state) from sources with text-only interface
% compiling /home/p264360/dev/trale/startup.pl... % compiling /home/p264360/dev/trale/sics.pl... % module site imported into user % loading /home/p264360/lib/sicstus-3.12.11/library/lists.po... % module lists imported into site % loaded /home/p264360/lib/sicstus-3.12.11/library/lists.po in module lists, 0 msec 23056 bytes % loading /home/p264360/lib/sicstus-3.12.11/library/system.po... % module system imported into site % loading foreign resource /home/p264360/lib/sicstus-3.12.11/library/x86_64-linux-glibc2.5/system.so in module system % loaded /home/p264360/lib/sicstus-3.12.11/library/system.po in module system, 0 msec 47488 bytes % loading /home/p264360/lib/sicstus-3.12.11/library/ordsets.po... % module ordsets imported into site % loaded /home/p264360/lib/sicstus-3.12.11/library/ordsets.po in module ordsets, 0 msec 24416 bytes % loading /home/p264360/lib/sicstus-3.12.11/library/assoc.po... % module assoc imported into site % module lists imported into assoc % loaded /home/p264360/lib/sicstus-3.12.11/library/assoc.po in module assoc, 0 msec 21872 bytes % loading /home/p264360/lib/sicstus-3.12.11/library/charsio.po... % module charsio imported into site % loading foreign resource /home/p264360/lib/sicstus-3.12.11/library/x86_64-linux-glibc2.5/charsio.so in module charsio % loaded /home/p264360/lib/sicstus-3.12.11/library/charsio.po in module charsio, 0 msec 13296 bytes % compiling /home/p264360/dev/trale/sicstus_additions/printlength.pl... % compiled /home/p264360/dev/trale/sicstus_additions/printlength.pl in module site, 0 msec 3168 bytes % compiling /home/p264360/dev/trale/sicstus_additions/sets.pl... % compiled /home/p264360/dev/trale/sicstus_additions/sets.pl in module site, 0 msec 720 bytes % compiling /home/p264360/dev/trale/sicstus_additions/samsort.pl... % compiled /home/p264360/dev/trale/sicstus_additions/samsort.pl in module site, 10 msec 14352 bytes % compiling /home/p264360/dev/trale/sicstus_additions/graphs.pl... % compiled /home/p264360/dev/trale/sicstus_additions/graphs.pl in module site, 0 msec 9296 bytes % compiling /home/p264360/dev/trale/sicstus_additions/case_conv.pl... % compiled /home/p264360/dev/trale/sicstus_additions/case_conv.pl in module site, 0 msec 9616 bytes % compiling /home/p264360/dev/trale/sicstus_additions/strings.pl... % compiled /home/p264360/dev/trale/sicstus_additions/strings.pl in module site, 0 msec 1168 bytes % compiled /home/p264360/dev/trale/sics.pl in module site, 30 msec 265272 bytes % compiling /home/p264360/dev/trale/trale.pl... % compiling /home/p264360/dev/trale/ale.pl... % loading /home/p264360/lib/sicstus-3.12.11/library/terms.po... % module terms imported into user % module assoc imported into terms % loaded /home/p264360/lib/sicstus-3.12.11/library/terms.po in module terms, 0 msec 14496 bytes % module lists imported into user % module ordsets imported into user % loading /home/p264360/lib/sicstus-3.12.11/library/ugraphs.po... % module ugraphs imported into user % module ordsets imported into ugraphs % module lists imported into ugraphs % module assoc imported into ugraphs % loading /home/p264360/lib/sicstus-3.12.11/library/random.po... % module random imported into ugraphs % module assoc imported into random % loading foreign resource /home/p264360/lib/sicstus-3.12.11/library/x86_64-linux-glibc2.5/random.so in module random % loaded /home/p264360/lib/sicstus-3.12.11/library/random.po in module random, 0 msec 11184 bytes % loaded /home/p264360/lib/sicstus-3.12.11/library/ugraphs.po in module ugraphs, 0 msec 92640 bytes % module assoc imported into user % module system imported into user ALE Version 4.0 alpha; September, 2006 Copyright (C) 1992-1995, Bob Carpenter and Gerald Penn Copyright (C) 1998,1999,2001--2006 Gerald Penn All rights reserved % compiled /home/p264360/dev/trale/ale.pl in module user, 700 msec 1421232 bytes % compiling /home/p264360/dev/trale/sics.pl... % module site imported into user % module lists imported into site % module system imported into site % module ordsets imported into site % module assoc imported into site % module charsio imported into site % compiling /home/p264360/dev/trale/sicstus_additions/printlength.pl... % compiled /home/p264360/dev/trale/sicstus_additions/printlength.pl in module site, 0 msec 2736 bytes % compiling /home/p264360/dev/trale/sicstus_additions/sets.pl... % compiled /home/p264360/dev/trale/sicstus_additions/sets.pl in module site, 0 msec 688 bytes % compiling /home/p264360/dev/trale/sicstus_additions/samsort.pl... % compiled /home/p264360/dev/trale/sicstus_additions/samsort.pl in module site, 0 msec 8400 bytes % compiling /home/p264360/dev/trale/sicstus_additions/graphs.pl... % compiled /home/p264360/dev/trale/sicstus_additions/graphs.pl in module site, 0 msec 7344 bytes % compiling /home/p264360/dev/trale/sicstus_additions/case_conv.pl... % compiled /home/p264360/dev/trale/sicstus_additions/case_conv.pl in module site, 0 msec 8192 bytes % compiling /home/p264360/dev/trale/sicstus_additions/strings.pl... % compiled /home/p264360/dev/trale/sicstus_additions/strings.pl in module site, 0 msec 944 bytes % compiled /home/p264360/dev/trale/sics.pl in module site, 50 msec -14480 bytes % compiling /home/p264360/dev/trale/utilities.pl... % compiled /home/p264360/dev/trale/utilities.pl in module user, 0 msec 1728 bytes % compiling /home/p264360/dev/trale/pth.pl... % module type_hierarchy_compiler imported into user % module site imported into type_hierarchy_compiler % module lists imported into type_hierarchy_compiler % module system imported into type_hierarchy_compiler % module assoc imported into type_hierarchy_compiler % compiled /home/p264360/dev/trale/pth.pl in module type_hierarchy_compiler, 40 msec 109952 bytes TRALE Version 1.0; June, 2005 Copyright (C) 1999,2003--2005, Gerald Penn All rights reserved % compiling /home/p264360/dev/trale/stcover.pl... % compiled /home/p264360/dev/trale/stcover.pl in module user, 30 msec 60320 bytes {ALE: signature compiler will assume subtype covering} % compiled /home/p264360/dev/trale/trale.pl in module user, 860 msec 1617536 bytes OSU TRALE Modules 1.0 Copyright (C) 2002, Detmar Meurers Copyright (C) 2006, Gerald Penn All rights reserved % compiling /home/p264360/dev/trale/fs2desc.pl... % compiled /home/p264360/dev/trale/fs2desc.pl in module user, 0 msec 13504 bytes % compiling /home/p264360/dev/trale/grammar_interface.pl... % compiled /home/p264360/dev/trale/grammar_interface.pl in module user, 0 msec 33088 bytes % compiling /home/p264360/dev/trale/feature_ordering.pl... % compiled /home/p264360/dev/trale/feature_ordering.pl in module user, 10 msec 38672 bytes % compiling /home/p264360/dev/trale/macro_utils.pl... % compiled /home/p264360/dev/trale/macro_utils.pl in module user, 10 msec 29536 bytes % compiling /home/p264360/dev/trale/extend_access.pl... % compiled /home/p264360/dev/trale/extend_access.pl in module user, 0 msec 36432 bytes % compiling /home/p264360/dev/trale/test_suite_handling.pl... % compiling /home/p264360/dev/trale/chart_display/sic.pl... % compiled /home/p264360/dev/trale/chart_display/sic.pl in module user, 0 msec 11440 bytes % module charsio imported into user % compiled /home/p264360/dev/trale/test_suite_handling.pl in module user, 10 msec 37360 bytes % compiling /home/p264360/dev/trale/trale_extras.pl... % compiling /home/p264360/dev/trale/toplevel.pl... % module toplevel imported into user % compiled /home/p264360/dev/trale/toplevel.pl in module toplevel, 0 msec 2976 bytes % compiled /home/p264360/dev/trale/trale_extras.pl in module user, 10 msec 38592 bytes % compiling /home/p264360/dev/trale/graphviz.pl... % compiled /home/p264360/dev/trale/graphviz.pl in module user, 10 msec 29344 bytes % compiling /home/p264360/dev/trale/chart_display/chart_display.pl... % loading /home/p264360/lib/sicstus-3.12.11/library/sockets.po... % module sockets imported into user % loading foreign resource /home/p264360/lib/sicstus-3.12.11/library/x86_64-linux-glibc2.5/sockets.so in module sockets % loaded /home/p264360/lib/sicstus-3.12.11/library/sockets.po in module sockets, 0 msec 41760 bytes % loading /home/p264360/lib/sicstus-3.12.11/library/timeout.po... % module timeout imported into user % loading foreign resource /home/p264360/lib/sicstus-3.12.11/library/x86_64-linux-glibc2.5/timeout.so in module timeout % loaded /home/p264360/lib/sicstus-3.12.11/library/timeout.po in module timeout, 0 msec 9024 bytes % compiling /home/p264360/dev/trale/chart_display/statistics.pl... % compiled /home/p264360/dev/trale/chart_display/statistics.pl in module user, 0 msec 12336 bytes % compiling /home/p264360/dev/trale/chart_display/print_mrs.pl... % compiled /home/p264360/dev/trale/chart_display/print_mrs.pl in module user, 10 msec 43168 bytes % compiling /home/p264360/dev/trale/chart_display/lr_utils.pl... % compiled /home/p264360/dev/trale/chart_display/lr_utils.pl in module user, 0 msec 2992 bytes % compiled /home/p264360/dev/trale/chart_display/chart_display.pl in module user, 100 msec 372784 bytes % compiling /home/p264360/dev/trale/save_results.pl... % compiled /home/p264360/dev/trale/save_results.pl in module user, 0 msec 15824 bytes % compiling /home/p264360/dev/trale/trale_emacs.pl... % compiled /home/p264360/dev/trale/trale_emacs.pl in module user, 10 msec 16736 bytes TRALE Milca environment (version 3.0beta1) Copyright (C) 2002-6 Project MILCA A4 All rights reserved % compiling /home/p264360/dev/trale/trdebug.pl... % compiling /home/p264360/dev/trale/trale-sld/interp.pl... % compiling /home/p264360/dev/trale/trale-sld/tralesld_hooks.pl... % loading /home/p264360/lib/sicstus-3.12.11/library/atts.po... % module attributes imported into user % module lists imported into attributes % loaded /home/p264360/lib/sicstus-3.12.11/library/atts.po in module attributes, 0 msec 26144 bytes % loading /home/p264360/lib/sicstus-3.12.11/library/jasper.po... % module jasper imported into user % module lists imported into jasper % loading foreign resource /home/p264360/lib/sicstus-3.12.11/library/x86_64-linux-glibc2.5/jasper.so in module jasper % loaded /home/p264360/lib/sicstus-3.12.11/library/jasper.po in module jasper, 0 msec 82608 bytes % compiling /home/p264360/dev/trale/ghooks.pl... % compiling /home/p264360/dev/trale/trale_patches.pl... % compiling /home/p264360/dev/trale/grale_forall.pl... % compiled /home/p264360/dev/trale/grale_forall.pl in module user, 0 msec 1056 bytes % compiled /home/p264360/dev/trale/trale_patches.pl in module user, 0 msec 4304 bytes % compiling /home/p264360/dev/trale/socket_interface.pl... % compiled /home/p264360/dev/trale/socket_interface.pl in module user, 0 msec 8288 bytes % compiling /home/p264360/dev/trale/unfill.pl... % compiled /home/p264360/dev/trale/unfill.pl in module user, 0 msec 8512 bytes % consulting /home/p264360/dev/trale/save_results.pl... % consulted /home/p264360/dev/trale/save_results.pl in module user, 0 msec -4016 bytes % compiled /home/p264360/dev/trale/ghooks.pl in module user, 120 msec 209792 bytes % compiled /home/p264360/dev/trale/trale-sld/tralesld_hooks.pl in module user, 190 msec 341056 bytes ALE Source-Level Debugger Version 3.2.1; December, 2001 Copyright (C) 1997--1999, 2001, Gerald Penn All rights reserved % compiled /home/p264360/dev/trale/trale-sld/interp.pl in module user, 470 msec 832528 bytes % compiling /home/p264360/dev/trale/trale-sld/trinterp.pl... % compiled /home/p264360/dev/trale/trale-sld/trinterp.pl in module user, 0 msec 12784 bytes % compiled /home/p264360/dev/trale/trdebug.pl in module user, 480 msec 847920 bytes {ALE: source-level debugger is active} % compiled /home/p264360/dev/trale/startup.pl in module user, 1590 msec 3413792 bytes SICStus 3.12.11 (x86_64-linux-glibc2.5): Tue May 10 14:16:47 CEST 2011 Licensed to Kilian Personal | ?- dgo. Using classpath: [kahinatrunk(bin),trale_home(trale-sld/lib/jedit-textArea.jar),kahinatrunk(lib/gralej/gralej.jar),kahinatrunk(lib/gralej/lib/batik-util.jar),kahinatrunk(lib/gralej/lib/jlibeps.jar),kahinatrunk(lib/gralej/lib/batik-awt-util.jar),kahinatrunk(lib/gralej/lib/plugin.jar),kahinatrunk(lib/gralej/lib/batik-svggen.jar),kahinatrunk(lib/gralej/lib/tomato.jar)] New TraleSLDState() and empty signature Current heap size: 61276160 Loading default project: test/webcourse/webcourse-project.xml
Loading default project: test/ps94/ps94-project.xml
Loading default project: test/webcourse/webcourse-project.xml
Loading default project: test/ps94/ps94-project.xml
Executing compile command:
org.kahina.tralesld.TraleSLDInstance@…(/home/p264360/workspace/kahina/src/org/kahina/tralesld/test/webcourse/theory.pl) org.kahina.tralesld.TraleSLDInstance@…()=query dcompile_gram('/home/p264360/workspace/kahina/src/org/kahina/tralesld/test/webcourse/theory.pl').(Queue: [query send_signature.]) Loading default project: test/webcourse/webcourse-project.xml
Loading default project: test/ps94/ps94-project.xml
Grammar registered. % consulting /home/p264360/workspace/kahina/src/org/kahina/tralesld/test/webcourse/theory.pl... % consulting /home/p264360/dev/trale/feature_ordering.pl... % consulted /home/p264360/dev/trale/feature_ordering.pl in module user, 0 msec -4064 bytes
% consulted /home/p264360/workspace/kahina/src/org/kahina/tralesld/test/webcourse/theory.pl in module user, 10 msec 61520 bytes Reading signature file... signature Compiling type unification... {ALE: Warning: unary branch from move_rel to walk_rel} {ALE: Warning: assuming the following types are maximally specific: acc adv base by cat cont_rel direction_rel e_list fem fin first for functional future_rel give_rel ha_struc hc_struc here_rel hf_struc hs_struc inf it lexical like_rel loc masc minus ne_list neut nom nom_obj none nonloc noun pas past_rel perfect_rel phrase pl plus prep present_rel prp psp rain_rel ref sai_struc say_rel second sg synsem that there third to unmarked val verb walk_rel word } Compiling appropriateness... Compiling extensionality declarations... Computing signature modules... Compiling subtype covering constraints... Compiling functional descriptions... Indexing source files... Compiling type constraints... Computing most general satisfiers... Compiling type promotion... Compiling unification... Compiling definite clauses... {ALE: Warning: first disjunct unsatisfiable in: und_search_rel(_128017,(_128018,(move_rel;tense_rel)),_128019);fail} {ALE: Warning: first disjunct unsatisfiable in: und_search_rel(_128017,(_128018,(move_rel;tense_rel)),_128019);fail} {ALE: Warning: first disjunct unsatisfiable in: und_search_rel(_128017,(_128018,(move_rel;tense_rel)),_128019);fail} {ALE: Warning: first disjunct unsatisfiable in: und_search_rel(_128017,(_128018,(move_rel;tense_rel)),_128019);fail} {ALE: Warning: first disjunct unsatisfiable in: und_search_rel(_128017,(_128018,(move_rel;tense_rel)),_128019);fail} {ALE: Warning: first disjunct unsatisfiable in: und_search_rel(_128017,(_128018,(move_rel;tense_rel)),_128019);fail} Compiling lexical rules... Compiling lexicon... Collecting empty categories... Blocked: und_list_of_synsems/1 ! tralesld_hook_failed(tralesld_call(22,unify(feat(loc),'Local',loc(loc(_468),_471,cat(cat(_461),_464,head(_448,_453,_179,_455,_456,_457,_458,_459),max),max),_480),['/home/p264360/workspace/kahina/src/org/kahina/tralesld/test/webcourse/theory.pl'|454],d_add_to_lvar(_480,loc(loc(_468),_471,cat(cat(_461),_464,head(_448,_453,_179,_455,_456,_457,_458,_459),max),max),loc,feat(loc)))) | ?- |
|||
| #135 | fixed | TRALE should not have to be started from grammar directory in order for projects to work | ke | ke |
| Description |
Das scheint auch der Grund für die Kompilierungsfehler zu sein. Der Ort der Signaturdatei wird ja in der Theoriedatei angegeben; TRALE interpretiert ihn leider relativ zu PWD. Workaround for now: trale -sdf vom Grammatikverzeichnis aus starten - so krieg ich die Grammatik kompiliert und "she walks" erfolgreich geparst. Der einzige wirklich saubere Fix des Problems, der mir zu dieser späten Stunde einfällt, wäre auf der TRALE-Seite - kommt mir vor, dass signature/1 Pfade generell besser vom Theorieverzeichnis aus auflösen sollte. Oder zumindest sollte es Grammatikschreibern diese Option anbieten, etwa in dieser Form: |
|||
| #134 | fixed | Hardcoded paths in predefined projects should be eliminated | jd | ke |
| Description |
Needs some changes in how KahinaInstance? and its subclasses load projects. |
|||
Query Language
query: TracLinks and the [[TicketQuery]] macro both use a mini “query language” for specifying query filters. Filters are separated by ampersands (&). Each filter 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. To include a literal & or | in a value, escape the character with a backslash (\).
The available operators are:
| = | the field content exactly matches 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 |
The date fields created and modified can be constrained by using the = operator and specifying a value containing two dates separated by two dots (..). Either end of the date range can be left empty, meaning that the corresponding end of the range is open. The date parser understands a few natural date specifications like "3 weeks ago", "last month" and "now", as well as Bugzilla-style date specifications like "1d", "2w", "3m" or "4y" for 1 day, 2 weeks, 3 months and 4 years, respectively. Spaces in date specifications can be omitted to avoid having to quote the query string.
| created=2007-01-01..2008-01-01 | query tickets created in 2007 |
| created=lastmonth..thismonth | query tickets created during the previous month |
| modified=1weekago.. | query tickets that have been modified in the last week |
| modified=..30daysago | query tickets that have been inactive for the last 30 days |
See also: TracTickets, TracReports, TracGuide, TicketQuery
