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 110)
| Ticket | Resolution | Summary | Owner | Reporter |
|---|---|---|---|---|
| #150 | invalid | Breast enlargement - how to know Breast Enlargement Surgery | pietercolpaert | breastenlargement17 |
| #149 | invalid | How players can handle the roulette wheel of roulette game? | pietercolpaert | roulettegame014 |
| #148 | invalid | Linser billigst, Billige kontaktlinser – Can continue lens wear can cause problems for eyes? | pietercolpaert | billigekontaktlinser17 |
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 110)
| Ticket | Resolution | Summary | Owner | Reporter |
|---|---|---|---|---|
| #150 | invalid | Breast enlargement - how to know Breast Enlargement Surgery | pietercolpaert | breastenlargement17 |
| Description |
Breast enlargement surgery is very common now days among women who want their busts to be in good shape and perfect. The surgery is scientifically called as mammoplasty which is a surgical operation to make the breast enhancement of women. Breast implants are done by females due to uneven bust sizes which might be caused due to breast feeding, pregnancy, age factor or any other reason. The dropping of breast may also be due to the gravitational forces, so surgery is required to bring them back to the original shape and order.
Guide2BreastEnhancement.com is the website where women can find the ways how to carry out surgery and from where and which doctor. There occur a lot of risks doing breast enhancement surgery such as infection etc. so finding a good doctor is important. Recommendation is very beneficial in these types of cases because of immediate and after causes of surgery.
Breast Enlargement hát igen, pedig ha tudtam volna, hogy beteg leszek :D mindegy így legalább nem kell tanulnom :DD os filme q o menino derruba o livro da menina no corredor e eles começam um romance se fosse vida real a menina virava "PEGA ESSA PORRA FDP" Me vuelven LOCO las librerias. <3 comprar policromos YAY!! i'm great... :) La audiencia prefiere a para seguir la actualidad informativa según últimos datos cc The Archdiocese of Washington is self-insured and has non-Catholic employees, therefore does not qualify for exemption. xDDD ¿tú sabes qué tentación tan grande es llamarte así a partir de ahora? I have 1 dimple. On le chin. trying thanks for the ff Drew Mac on the way out here......uh oh!! I'm the one who wants to be with you deep down I hope you feel the same too Be happy with your tickets, loads of people didn't get any! ;) x Boletín de Competitividad social en México | 2008 | 18! Happy Birthday, Lewis. Hope you have a great day. Cheers! Sadly, unlikely. Yes it would be you tube, social media, back page internet papers within ten minutes. Ya no soy mas virgen,la vida me vive violando. Caralhoo meu TT ta de roscaa acabou o cqc e tenho certeza q nem trocou de canal ainda... pelas primeiras cenas do filmao q esta passando.... rs I'm flirt, I know that. I can't change who I am just to please you. TheBestFeelingsIsWhen? comes con hambre :K :) omg catching up on BGT. basically every act is annoying/rubbish/stupid. Gracias por tus sonrisas, tus alegrías, tus chistes son lo mejor Te amo (1) EStatus: Con los labios mas irritados peor q si ubiese besado a una bigotona! brakeado me siento super raro :AS VCU baby!! MarchMadness? Breast Enlargement see you then, sir!!! É:) Não é porque estamos de férias que você vai deixar de dar uma passadinha no , né? - DD 060 En tiempos de crisis y más allá de la causa que convoca, definitivamente lo mejor de san lorenzo: sus hinchas, su gente It's a miraggggee alliemartinez <3 "We're gonna need some privacy here, so you're gonna need to paint your windows black and stay in your home." I need Chipotle now...but wait I'm stuck here until tuesday swag You don't know what you mean, we're all so back and forth, nothing is as it seems tdwp borntolose Web "two is better then one" 14- - Depois dos dois terem aquela noite quente,eles acordaram assustados... Let's do this!! I'm saying good-bye to fast food Sampling getting weird with little bro igualmente gracias!!! 90 more ;) TeamFollowBack? FollowNGain Follow4Follow InstantFollow? AutoFollow? IFollowAll IFollowBack FOLLOWFRIDAY urbannation: hip hop fashion | 5ive jungle clothing: We are not the same I am I martian this I space jam Ulike Jawan Harriss???????? XKSKÇSÇCKSKCPSXSCL ENTÃO NÓS DUAS IAMOS COMER AMEGAAAAAAAAAAAAAAAAA Top10FavouriteArcticMonkeysSongs mardy . People say that we're the rudest fanbase because of the way we defend Justin. What do you expect us to do? Sit there & do nothing? Um no. Dear Meghan Gurdon, YA lit is NOT too dark. It reflects life. Choosing to be blind and deaf to badness doesn't vaporize it. YAsaves Ajuda a divulgar? O aniversário do Ped será 14/04 e irei fazer um vídeo no qual os fãs podem participar. I think we need to move the date up from may 20th to THIS SUNDAY...APRIL 8th! UKCOUNTDOWN - BOYFRIEND Por Semana Santa, la UCA estará cerrada del 31 de marzo al 9 de abril. Las actividades se reanudarán el martes 10. Felices vacaciones |
|||
| #149 | invalid | How players can handle the roulette wheel of roulette game? | pietercolpaert | roulettegame014 |
| Description |
Roulette game is more famous among all types of players who can easily handle with this game. A huge amount of people will be gathered around roulette table and feel happiness to play this game. It is also known as social game that helps people to make social relations among them. All the players and spectators will hold their breath while roulette wheel is revolving. If you want to play online roulette game, you should get all important information about this game before playing.
You will find this game very easy and convenient. People are so excited and shouting when roulette wheel is revolving. It provides a great activity for its players who get full entertainment from this game. All players will play roulette game with different style and win this game easily. You can get great help from Online roulette game reviews that define all ways of playing games.
Roulette game 26 Harry :) Lightning players gave goaltender Dwayne Roloson a standing ovation ... Tampa Bay Times WHAT ISH LE WRONG HANNAAAAA?? I'M HERE FOR YOUUUUUU Sir Paul Smith and Mr Sports Personality chat cycling The Olive Gopaul Show on Facebook: Guyana My life gotta be the worse doa Leading someone on is just foul foreal. dontDoIt Siga-nos no social media? E nos envie seu e-mail para encaminharmos nossos louvores! Que Deus te abençoe! MusicOnGameDay? 99% Country 1% Other If you're a super-rich tax dodger who smokes you'll be worse off. Otherwise you'll be fine downloadkan nah!! Streamingnya mantap. My weed, my life, my choice. LegalizeMarijuana? LegalizeIt? LegalizeWeed? OperationLegalize? OperationLegalizeWeed? N can't sleep ): ... just voted for every1 VOTE and REmessage GO GO GO! if you are watching the football you will understand. SYNERGY scheduled to play tomorrow at 5:30 on stream in the FYC 4v4 tournament! Here's why lots of people throughout life surrendered their lives for the cause - i know im bored if im doing truth is on fb haha hahahaha yes:-) Voy dormir!! Que tengan una buena madrugada .¡. don't be bout that ! Yep. I am that invisible Er hun så billig? :-) Xandão já fez mais pelo Sporting em um jogo, do que pelo SPFC em todo seu período aqui: bubu ): iajsiajisjaisia Very cool piece. Always really liked him definitely going to be late but im too comfy to care! of COURSE she is. She's blinkin' *awesome*. Hurrah! haha i got to many big brothers :) não gosta de hole?? ahahahhaa Si Digo Que Los Santos Es La Mejor Provincia Me Voy Aparecer Chiricano Asique Viva El 10 De Nov Viva . BREAKING: New images reveal extent of George Zimmerman's wounds. See here! ------> . A set back can be a set up for a comeback Pouringg Your Heart Into Something That Dont Return The LOVE <<<<<<< Decir que amas un grupo cuando sólo has escuchado dos canciones suyas. Todo por caerle bien a la gente. Eh, lo estás haciendo mal. De nada. I have, but only because told me to. - oh you thought the fondue video was corny?? u dont know corny. This my friend...this is corny. haha. ADealIsADe Here's what you've all been waiting for! convinced me to join social media. What do you think Good or Bad move? lol here you go lol look at her name what your sisters bf texts you.. ohdeargod maybe im a little biased ,since I'm his grandson but why do you think he doesn't get the love and appreciation he should. ! Ese tatuaje es real, pero lo tiene tatuado en otra parte que yo sola vi ;) Y si, me dejo en shock cuando vi....... SIN PALABRAS I shoot tomorrow :( u know me, I'm not a drinker lol Brandon Ashley > marry me? Ohhhhhh, yeah! gotcha Roulette game Turtles Hatch at Wareham Community Garden, yump dang, sorry to hear La amistad es un amor que nunca muere. sim,nem qro voltar a pensar em promos da mix.. Eu sigo a porque só ela me dá a chance de conhecer os Rebeldes no camarim em Natal dia 29/04. +66 Preview this hot new single "Hustle" by RetroPhresh? NoDaysOff? Thanks!!! tranquila recuerda cristhian nos siguio semanas despues, como dos semanas mas o menos no?? Are you ready for tonight? Prep with PrettyLittleLiars? sneak peeks: :D. Que booooooooooom. Patricia e a mãe foram ai ? how are you honey? babe, so am I! But I cba to cook:(<3 heeeeyy , Marvel and Aurasma Show Off New Line Of Augmented Reality Comics at SXSW Now with awesome demo video tiens te voilà là toi Coool the 'crazy mosh pits' lol No thank you. The Raffle for Kids Radiothon is today. 2012 Calendars are only $25 and give you a chance at winning thousands of... |
|||
| #148 | invalid | Linser billigst, Billige kontaktlinser – Can continue lens wear can cause problems for eyes? | pietercolpaert | billigekontaktlinser17 |
| Description |
Lens means the protection of your eyes and enhances your eyes beauty. There is much variety of lenses available in the markets which are designed for specific reasons and for specific purposes. If you need help and proper guideline then visit to Linser billigst and wear the lens according to given instructions in the website other wise you have another option which is best and recommending that you have to consult with your eye specialist then you can use lens. Some types of lens is not suitable to wear for long times. For more detail visit to Billige kontaktlinser to enjoy benefits. It is true that continues wearing of lens can cause eye side problems for you. Take wise decisions and after the consultation of your doctor and use only recommended lens but there are lots of other types to which you no need to share with any consultant or doctor. Linser billigst, Billige kontaktlinser –Kan fortsette objektiv slitasje kan føre til problemer for øynene?
Objektiv betyr beskyttelse av øynene og forbedrer dine øyne skjønnhet. Det er mye utvalg av objektiver tilgjengelig i markeder som er utviklet for bestemte grunner og for bestemte formål. Hvis du trenger hjelp og riktig retningslinje og deretter gå til Linser billigst og slitasje på objektivet i henhold til gitte instruksjoner i nettstedet andre vismenn har du et alternativ som er best og anbefale at du har til å ta kontakt med øyet spesialist kan du bruke linse. For mer detaljer besøk til Billige kontaktlinser for å nyte fordelene. Det er sant at fortsetter å slite på objektivet kan forårsake øye side problemer for deg. Ta kloke avgjørelser og etter konsultasjon med lege og bruk bare anbefalt objektiv men det er mange andre typer som du ikke trenger å dele med noen rådgiver eller lege.
Acabo de ganhar uma seguidora. A super , ô loco, bixo! Quem sabe faz ao vivo! me sigues yo te sigo :) follow me <3 (nom, nom! .. This is why you should never eat bacon: Inglese, spagnolo *-* e francese D: sure, just check your DMs- those interested please DM us, or RT this for a follow! :) ._.? <3 Galera, não esqueçam: AMANHÃ AS 20:00 TEM KIDS CHOICE AWARDS 2012 NA ÍNTEGRA NA NICKELODEON! TEM RESTART LEVANDO PRÊMIO E TUDO, SE LIGUEM! RT please, help me with this, is my dream thankyou so much Muchas Gracias!!!!! q lindos!! :) NowPlaying? The Notwist Consequence on SpotONRadio nããããão! Kkkkkk! Se eu ganhar, é meu e ninguém tira! vouganhar You think its cool to wear your pants under your , have a fake grill, a 4XL white tee and cary a loaded gun above ya ? FALSE. Billige Kontaktlinser Con mi leoncito Matxo!!! R.I.P. Trayvon Martin Remessage if you see this & you care if not keep scrolling ClipeDoJeitoQueEuSou1MilhãoDeVisualizações ClipeDoJeitoQueEuSou1MilhãoDeVisualizações Hoya is an AB Bloodtype o HAPPYHOYADAY It's not what you look at that matters, it's what you see. - Henry David Thoreau ACTA Signed by 8 of 11 Countries - Now What? - O MarcoCivil? é apontado como nossa "Anti-ACTA legislation" pela . RussiaWaitJYJ we love you boo boo i love me some Marilyn Monroe <3 Bulls allow 100 points for just the 10th time this year and only 3rd at the United Center. Girl, iWas da one dhat told you Fxck dem other then, you still went &&' Fxcked dem other ! "Oooh-oooh sometiiiiiimes,I get a good feelin" (sing it) Yeahhh.. Grammy kickoff party ... alguém fala comigo, por favoooor :( intro ulang deh :3 haha oke :p RT hekyo_KVIN: kayany udah tapi lupa, hehe hayy juga ehh udh intro blm ya here we go again... Gee Bob, someone as liberally white as you must be an expert on who is a racist. Please keep chasing runaway slaves. Show me the money? Insane!! Report: US government spent at least $945M on advertising in 2010 on Fluent News haha just working the event! She lyin, Tlkn bout she wanna to take dem wit her tf Why da she aint dead den????? Juniper Systems Rugged Handheld Used for Arctic Wildlife Monitoring Program in Nunavut, Canada Dulu itu maennya di belakang, lempar lemparan terus berantem.. I miss this placee.. Mangaratiba tem quatro candidatos a prefeito Yep! Some people can't differentiate the two --->> perception become ones reality! You can do as many drugs as you want. the trick is to not take a relaxing bath after you do it. Eloquently and elegantly done, Mr Ness. Liking it a lot. Thank you god Ser fiel es más allá de besar o no a alguien más. Ser fiel es querer estar ahí, incluso cuando se puede estar en otra parte. Blowin up mayhemness' bathroom, donotoccupyforatleastanhouroryouwillregretit poomessage tudo sim amor, e você? *u* aha I think I did good for once. Hes not a good teacher Billige Kontaktlinser 47 Senators Side With Big Oil And Vote To Kill 37,000 American Wind Jobs 4jobs 2futures youcut p2 tcot Her & her relationship can suck asssss ;) I agree. Let's review: There's no buzz in the arena, no national TV and Rondo has 5 points, 3 rebounds and is the only guy who wants the ball. Oww oq aconteceu q vc foi embora?? poser nem adianta finjir Hj não é seu dia hj é dia do Fã FelizDiaDoFã? para os verdadeiros Fãs Min Celso de Mello conclui seu voto no qual não admite declaração de inelegibilidade antes do trânsito em julgado da sentença condenatória where?? Tomorrow marks my first lecture of the year and the beginning of another semester. Cue assignments, study and stress. Do not want. |
|||
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
