![(please configure the [header_logo] section in trac.ini)](/img/logo.png){kind=logo}
Trac Ticket Queries
Table of Contents
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 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 and no name/email defined in the preferences then all open issues are displayed.
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 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 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 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.
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:
Using the [[TicketQuery]] Macro
The TicketQuery macro lets you display lists of tickets matching certain criteria anywhere you can use WikiFormatting.
Example:
[[TicketQuery(version=0.6|0.7&resolution=duplicate)]]
This is displayed as:
No results
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=0.6|0.7&resolution=duplicate, compact)]]
This is displayed as:
No results
Finally if you wish to receive only the number of defects that match the query using the count parameter.
[[TicketQuery(version=0.6|0.7&resolution=duplicate, count)]]
This is displayed as:
0
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 by placing pipes (|) between the columns like below:
[[TicketQuery(max=3,status=closed,order=id,desc=1,format=table,col=resolution|summary|owner|reporter)]]
This is displayed as:
Results (1 - 3 of 44)
| Ticket | Resolution | Summary | Owner | Reporter |
|---|---|---|---|---|
| #79 | fixed | Anonymous Browsing Stated | chris.moos | xgdqarjtpxt0 |
| #78 | fixed | Select the Perfect Item from Various Wedding Favor Ideas | chris.moos | jcphgwvcpkw5 |
| #77 | fixed | Read about Removing System Tool Virus | chris.moos | jzaxshicaei7 |
Full rows
In table format you can also have full rows by using rows=<field> like below:
[[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 44)
| Ticket | Resolution | Summary | Owner | Reporter |
|---|---|---|---|---|
| #79 | fixed | Anonymous Browsing Stated | chris.moos | xgdqarjtpxt0 |
| Description |
Anonymous Browsing Stated Even though a lot of people have often desired that they could possibly in some way explore the net covertly with out other people actually finding out about the facts of the visits to the web sites, most of them really don't know that this is possible. Sure, anonymous browsing will be the solution. Whenever a person indulges in anonymous browsing, you've got the possibility of searching the web with total privacy by hiding oneâ??s Ip address, which usually helps prevent tracking. You will find 2 principal ways of going about surfing the net privately. One can either go ahead and take assist of anonymous proxy servers or you can rely on software programs which facilitate these kinds of exploring. Having said that there are numerous measures to be considered before randomly choosing any proxy server for this function. Sadly lots of proxies are setup for the only purpose of getting hold of the useful information of people. Consequently before you go for any proxy server that you've found out on search engines like google, you should think twice since there is no such thing like a no cost lunch. Then again, having said that, there are many individuals who put up proxy servers with complete honesty, but discovering these kinds of truthful proxies could be very difficult. Rather than making guesses and assumptions on which proxies are secure to use, one can also employ another method for anonymous surfing. This process refers to the employment of exclusive proxy services which can easily be found on the World Wide Web. This kind of assistance allows one to alter the Ip address and encrypt it as well. These software programs are very simple to use and they offer you full anonymous browsing. In fact it is also transportable as you can copy the program on to an Usb or a pen drive and use it on the go. You can have pleasure in anonymous browsing in a friendâ??s home, the institution cyber café or in the office, all you've got to do is to connect the Usb stick, run the anonymous browsing program and then appreciate anonymous browsing all day. Many reasons exist as to the reasons you need to work with anonymous browsing, a few of them being privacy, security and prevention of id theft. Making use of this form of exploring can protect one resistant to the nasty and destructive clutches of cyber criminals, trackers and websites filled with viruses, spyware and adware, spyware, and so on. |
|||
| #78 | fixed | Select the Perfect Item from Various Wedding Favor Ideas | chris.moos | jcphgwvcpkw5 |
| Description |
Select the Perfect Item from Various Wedding Favor Ideas It's a general convention to provide wedding favors to guests for making the wedding event unforgettable. Different things are selected for making the event successful for the actual newlyweds and the gesture is extremely appreciated in the actual community. Typically, the wedding favor contained presenting of sweetmeats and comparable edibles to symbolize the environment of joy. At present, the option of this kind of gesture is actually expressed in another way in which several other items are acquired as wedding favor ideas. As we remember a history of such custom, we discover that numerous sweetened preparations were utilised as selection items such as walnuts in sweetening solution in order to symbolize wellness and wealth associated with guests. The specific tradition of presents at the wedding ceremony is actually prevalent in several ethnicities around the globe and couples contain the item as being an important part of the entire marriage organizing with the holding of reception function. The current pattern has fairly normally accepted the current style in selecting the present, which resembles the primary style from the marriage ceremony. It's provided birth to personalized wedding favors which contain names and phone numbers of the pair to remain within the memory of visitors. The most typical gifts which are seen these days include stunning bouquet of flowers, candle lights, crafted earthen or metal guards, stitched caskets, floral vases, and many more items in addition to electronic products. Couples choose the product beforehand and finish the actual promoting to get the gift articles well- ready with names as well as phone numbers are to produce the personal touch. There is an increasing demand of such articles which are used as wedding favors. It is a normal program for everyone in the culture to follow along with a particular trend to choose the article for weddings. Many people still choose the conventional articles as optimistic wedding favor ideas which include the container of dried fruits to express the gratitude towards the guest. The idea of a small gift tote is another very fine alternative to popular utter thank you to guests. Picture casings are great items for this kind of occasion, that are transformed into personalized wedding favors by using a picture of the bride and groom in one part of the frame. The other part of the framework is for the visitor, that also is really a remarkable gift idea for the marriage ceremony. Candles, desserts, pastries along with other eatables with nice taste are additionally contained in the list of wedding favors which are recognized by the modern society generally. |
|||
| #77 | fixed | Read about Removing System Tool Virus | chris.moos | jzaxshicaei7 |
| Description |
Read about Removing System Tool Virus The system tool virus essentially seems under the guise of the antivirus software program that promises to protect the device from virulent attacks, spy ware as well as adware. It is actually a fake system that masquerades like a genuine pc safety and victimizes harmless customers through infecting their own device. When a variety of pop-ups show up throughout usage advertising a strong as well as trustworthy safety software program, the user must be careful as it might be this particular deceitful bundle which might be attempting to make an entry in to the program. Since it has been built to bear resemblance to an antivirus software program package, numerous computer users get fooled through its marketing strategy as well as end up buying its account activation code/ enrollment key. By the time, these people recognize their own folly, it's past too far and the virus is already embedded deep in to the computer. Once integrated into the computer due to a slight slip on part of the user, the system tool virus ensures the malfunction of other forms of safety as well as hinders with their own installation and working. Another after-effect is the huge decrease within the pace associated with the pc therefore impacting the overall performance as well as software abilities in daily tasks. An undesirable consequence is the rise in the amount of pop-ups, many of which are equally deceitful and fake. Elimination of system tool virus is actually accomplished by rebooting the computer in safe mode through pushing the F8 key as well as choosing the safe mode from the advanced alternatives menu. Alternatively, the operator can choose the free of charge system tool elimination software program, set up this program on the pc and allow it to function to the potential. Whenever such software programs are set up, the onus is about the consumer to up-date them also as well as carry out arbitrary inspections once in a while to make sure that nothing alien has breached the protection. While using the antivirus, it is essential to scan the outcomes because this is the best way to place any kind of anomalies present in your system. Solely following these are removed as well as erased that the system should be switched off and its purity preserved henceforth. The user is also advised to use a variety of antivirus packages so that malicious applications of all types and caught simultaneously as well as removed. Consequently, whenever while working away at the pc you will find intimidating messages caution the user of compromise about the security, these should be totally ignored or thoroughly investigated to maintain the safety of the pc before being clicked upon. |
|||
Query Language
query: TracLinks and the [[TicketQuery]] macro both use a mini “query language” for specifying query filters. Basically, the filters are separated 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. To include a litteral & or | in a value, escape the character with a backslash (\).
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 |
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 left out 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
