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 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 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, use 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 73)
| Ticket | Resolution | Summary | Owner | Reporter |
|---|---|---|---|---|
| #470 | fixed | For help on using varnish cache server | argh | varnish cache server |
| #469 | duplicate | Cheap car insurance, cheap auto insurance-How to find cheap auto insurance provider? | argh | Cheap car insurance001 |
| #448 | fixed | Vocabulary workshop answers- How to remember the newest words? | argh | vocworkans19 |
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 73)
| Ticket | Resolution | Summary | Owner | Reporter |
|---|---|---|---|---|
| #470 | fixed | For help on using varnish cache server | argh | varnish cache server |
| Description |
varnish cache server varnish cache server I'm through. Thank you all so much. Syracuse No. 2 In AP, Coaches Polls. Booooring... The original story from Tales of 1001 Arabian Nights begins with, "Aladdin was a little Chinese boy." FYI not sure if it matters but we've gotten a few complaints of include_remessages=1 on lists. IMO its the right behavior. I hate when people belittle others. But I love when that person becomes what they talked down upon ": HBK gang you dont get it do ya" I'm back! It's 11:20 p.m in the Philippines...O_o Eyebags! " varnish cache server !"thongchaibsc Dear , You are sooo adorable but what were you thinking by looking like this, Sincerely Me - spon Ha ha Kevin forgot him be with her BOYFRIEND, dress like a teenager and yeah, do things we may not appriciate at times, but she works so hard to make us happy [FANTAKEN PIC] Teen Top in Taiwan Taoyuan International Airport, Niel receiving gift frm a fan (cr: merainda varnish cache server The Single Life >>> Well i'll be , yall got an answer 4 everything huh? it makes plan'n the funeral easier! Speaking from pers exp! thanks so much she's a little love bug Cameron welch Clearly, the 1% are afraid of the 99%. Good. They should be. Stay strong, everyone. Non-violent protest is our constitutional right. ows Sooo, lets talk about glee. :D varnish server Whats your favorite couple and why? ( live on adududududu :) twittnya baru masuk skr :) kang Zaenya dah dimana lagi ini:) Champions aren´t made in the gyms. Champions are made from something they have deep inside them - a desire, a dream, a vision -Muhammad Ali I just want to be like, "Oh, honey. No. No. Just... stop." Confused as love needsleep Exit 12 apart you and me No te Gustaria Romperle una Pierna, O torturarlo ?? OKNO : make sure u let me know when the next video shoot is =) fa sho GANADORES ENVIEN DATOS A .lared.com con su nombre en social media! A shot from long range by Norwich player.. still wide.. Lol just because she got TEAMFAITHFUL in her bio don't really mean she faithful.. So pretty and fierce <3 New SWATH Image in HQ SnowStew? in battle! keeeej. Somebody need to mention me :) oh Kristen,you are going to be the death of me. jajajjajaja Gracias no se molesten.. a ti!! varnish cache server Gracias por estar aqui!! Saludos estimado Hugo! Checkout behind da scenes w/ Behind the Scenes Watch Me Fred Sanford I've been grinding in this one cave for days. I'm so tired! ygolon u r not alloud to take sahar ... LoL agoluhum my partner ! Ygolon gimme aprove enha t9erlk -.- i love fireworks. haha. punkdISBACK Gimmy, ci vediamo o no??? IrelandNeedsBelieveTour? we're a small island beside England that Dosent like to be egnored please come back we love you<3 13 um zuando o outro LOL por isso qe nois tem qe come nutella no café da manha Les trois "B" du Bonheur : Boire, Bouffer, Baiser. Todas tuendole a Justin, menos yo. Ya está mis esperanzas desaparecieron. 5555+ my boyfriend >>>> your boyfriend Extraño los tiempos de antes, la navidad se hacia notar mas. - Super bowl week!! ready to rumble!! Volver a vivir (Espejismos del partido obrero y el ex senador Duhalde ~ >< .. .. Miałam ciężką noc ;P oooi obrigada :) Kissmes, we all know Block B has been suffering greatly lately. Please take some time to wish them well. StayStrongPyoJihoon? Sundays you are either working or hungover,love sundays The Obama Misery Index: a toxic blend of unemployment, debt, home foreclosures, and bankruptcies, by . What if your pillow could collect your dreams and when you woke up you could plug it into your computer and watch them all over again? RT": 229!!!4 !!! 4 ? ~" varnish server Adquira sua assinatura Spotify Premium no GoSpotify?, somos revenda Spotify Premium no Brasil! Adquira agora e ganhe super desconto! E se ninguém quiser comprá-lo ou contratá-lo por empréstimo? O que fazer? FlamenguistaSegueFlamenguista? Jasmine is our flawless beauty queen When I make it, only a select few will be feasting widd me Un pantalón como el de Hayley plij concerteza ! ": Una novia con la que pueda bromear como amigos pero respetarla como a una princesa."/ it was :) Coreógrafo diz que Jennifer Lopez aprendeu a sambar em 30 minutos GirlsLoveWhen? you play with their hair endofstory flirtygirltip Synes forslaget til var hakket bedre. Segunda primicia del día: Viatri esta en Tandil cosign, S, cosign ThingsThatILoveInLife The fact that my Mum is the best thing that has ever happened to me Part 3 right? Meu quarteto fantástico: Tédio, Fome, Preguiça e Sono. !! Excited to film my new class video today. Feat. ...shooting done by my bro ..s/o LeBron? and Wade Avengers SHINee COMEBACK! ARE NOT CALM! SHINeeIsBack Photo: Veient el Nadal-Del Potro, quin parell de bèsties! "P.S. We vote!" : Something To Send To The GOP Today -- Whatever don't kill u makes u stronger. I must be the worlds strongest woman. !!! [PO JPOP s/d BESOK] 2PM BEST 2008-2011 - In Korea [CD+DVD LE A] Rp 480.000 [CD+DVD Type B] Rp 440.000 iniiiih <3 + glasses = perfection Sent your an email, hope can you check it when possible. thanks. We have everything we need -- right here, right now -- to create a better world. occupywallstreet foreveralone - - , - ! Ada yg udah nonton dramanya Yonghwa CNBLUE dan ParkShinHye? yang Heartstrings? :O My hair takes to long to dry I could of been asleep by now :/ trnyata tadi di kelas ada yang ultah -,- 120307 [TRANS] going up!!! To USA!!! But... going to a country many tall people should I have worn (cont varnish server No puedo parar de pensar en Jemi :( ah this is awesome :P thanks ugh that sucks. How are you? Need to watch Bel Ami. Yes, it's a NEED. Raplyricoftheday "theres certain things that money can't buy, like being this fly. To the end I'm gonna ride" Jay-Z In the studio for ihatetommyfinch soundtrack. , . Today we track vox, trumpet and some djembe, woot! park city park park city bitchhhhh. So there's this fugly remix of Skyscraper here in holland.......... And well, the girl in the video.. I know her.. And.. Ok no comment. I wish the boys' management realized how much they mean fans. Even a simple word can make a life time of confidence to a girl, you know? dasar bureng ulangan malah sms guru ngingetin gitu berasa hebat ya?! idk with rizza, somewhere in timog *TK* Anak2 : "selamat pagi pak guru" | Guru: "Gausah sok akrab dehLebayy!!!"| Nangissekelas I'm at (ICN - Incheon International Airport) (2172-1 Woonseo-dong, Joong-gu, Incheon) w/ 15 others - ConfessionNight? i never make the first move.... We apologise for the inappropriate use of the word coloured in a report on racism and football in todays News at 1:30pm vroeger:'HOI! kan je spelen? (: nu:'Ouwe kan je chillen? iDS NO PODÍA METERME A MI social media, ESTABA A PUNTO DE LLORAR, HAY DIOS MÍO XD NO ME HAGAS ESTO XD wkwk,.kyk twilight yaa (._.) Galaxy S2 smartphone 2011! I Love & , The best of Kpop in France 9 FBI Probed for Bribery After Wife Met with Convicted Arms Dealer in Late 1990's . .. . . .. I hate lazy ple oii >u< hehe -squishes :3 hi bb buu!!! Sigueme *-* Don't you just love that? Wie schön das Netz auf die jüngsten, rechte Umtriebe eines Piraten reagiert: Kevingate olly murs!!! :D ( live on sok romantis ngajak pasangan bgaya superman terbang dg lois lane di lift kaca mall malah dy ngambek krn malu diliat org |
|||
| #469 | duplicate | Cheap car insurance, cheap auto insurance-How to find cheap auto insurance provider? | argh | Cheap car insurance001 |
| Description |
If you want to get cheap car insurancefor your car, you should explore affordable payment programs. People who want to get cheap car insurance to save their cars from any damage should explore right insurer. People can find many cheap car insurance companies from many websites. There are many online insurance companies that provide their services to get cheap car insurance. These companies provide cheap insurance at flexible prices.These companies provide great opportunities for their customers to get cheap car insurance. They introduce flexible and cheap auto insurance plans for drivers. {{http://carinsurancesingapore4u.com/wp-content/uploads/2011/08/carinsurancequotes.jpg}} Cheap auto insurance has great opportunities for new drivers as well as experienced drivers. They provide reliable and cheap auto insurance policies for drivers. They offer cheap car insurance policies for their customers. You can find many cheap auto insurance companies that help you to save your money and provide you financial protection against physical damage. Cheap auto insurance can be higher because of personal injury protection and other areas of coverage. {{http://www.saturn-outlook.com/wp-content/uploads/cheap-car-insurance.gif}} Cheap car insurance When mom isn't in town, & we don't know what to put in the dishwasher.We put the wrong soap in and lets say bubbles Maybe Novak ? Woke up today at 5 went into Boston now im on my way home needanap Huub Stevens kijkt toe vanaf de tribune hoe John scoort . psvtwe twesch Esteghlal comienza a dominar el centro del campo y la movilidad de Samuel, Meydavoodi y la llegada de Hamoodi les acaba dando el control. Auuuuch ... ;[ recordando viejos momentos.. concanciones Sometimes I am too naïve La escala estimativa de asertividad está en webmail there is always a fleeting moment when your unsure layin down _ That joke wasn't even funny. You're going to expose your unethical behavior over that lame joke?!?!? Bang, email kamu apa? | gombal 58 followers until 1000 ! RT please Uii o Gusttavo Lima Fuma,Vou me Vestir de Cigarro Pra Ele Colocar a Boca na minha Sandy. 500m is approximately .3 miles :) Loving the stream! SGENTE!!(?) OFFERTA IRRIPETIBILE. DAI BBBELI(?) me duele TODO :c thnks!!!! no caben los monitos! tendremos que hacerlos mas pequeños tal vez para que vayan en sus lugares cofrectos a comida ainda vai demorar um pouco ,. minha mãe ta fazendo massa com bacon :9999 has just shared video with gwynie using iPhone Knocking. Live video Sharing Application ue ganho , é pra você tirar as copias do trabalho de matématica pra mim kkkkk Here's from posing with his helmet in the Toyota portrait studio. no se deja le pregunto a si aun ira oh, que buena película thewall fui mujer valiente, pucha que me hiciste llorar en capítulo de hoy, fuerza y éxito en todo!! Gracias por dar a conocer tu vida! oldest actor EVER to win an Oscar!... UAU! Every step toward enlightenment is a step of self awareness last school production everrrrr is overrrr :O ThatAnnoyingFeeling? when people are unnecessarily argumentative. Spaghetti for L wearing white I need a shirt I'm so motivated to succeed right now... Not just for me, but for all my kin Forró da Pegação - É melhor ser feio Atração confirmada dia 13/JAN na INAUGURAÇÃO do !! SUCESSO!! VENTA DE BOLETOS EN OFICINAS (CHIHUAHUA 28 ESQUINA FRONTERA ROMA NORTE) Y LUGAR DEL EVENTO. SISTEMA DE APARTADO... Ay, odio los putos mensajes esos de "autoresponder" que te mandan cuando los seguìs loco. Hi honey! Porto Alegre Poker Tour começa hoje; Sobral participa Life is a game, and by the looks of your face, you're losing. Sometimes you'll rewatch a movie you used to watch as a kid and realize that, back then, you didn't have a clue what was going on. rsrsrsrsrsrsrs hey u have email address where I can route a question?) Photoset: si kieres arte en tu piel sigue a es un artista y un crak como persona lo unico que falta es tomar en cuenta la opinion de sindicalistas corruptos Seas novia o invitada, si las bodas tienden a conmoverte usa sólo maquillaje de ojos a prueba de agua. Que ninguna lagrimita arruine tu look Cheap car insurance Didn't know that. Thanks for letting us know! :D I like your makeup... LOL, jk. It looks like you got by Crayola. God ! Wake up for school: (--) Wake up on a holiday: \('o')/ "Ai Vi, precisamos marcar rolê" Diz a pessoa que sai toda semana com os amigos do colégio e nunca me chama! Next year! I want to hang out with you!! _ <333 Si tu novio te pide que cambies, hazle caso y cambia, pero de novio. New Photo: Vince Gill & Emmylou Harris I'm gonna try to get a pvr and join a better clan if res doesn't work buying my dry fits for this year, nothing like a brand new pair midcalves social media Is Getting Wack Yo thank u In the Gym again! DC Star This Weekend HerGirlfriend? REDOREDOREDOREDOREDOREDOREOREDOREDOREDREDOREDOREDOREDOREDOREDOREDOREDOREDOREDORED MayWePleaseRestartThatAndActLikeItNeverHappenedBabyPlease? True! noclasses yes Linda foto ") ... my prediction is the Sooners will give a Big12 going away present packaged with a beat down inside BeatAggies? BoomerSooner? |
|||
| #448 | fixed | Vocabulary workshop answers- How to remember the newest words? | argh | vocworkans19 |
| Description |
Vocabulary workshop answers are easy to use. Vocabulary workshop answers when the new arrivals of the words come then you should start remembering them and memorizing them for sure. You should be able to make or realize the difference between the old words and new words. There is also the difference laying the new, newer and the newest words for sure. These words should not be ignored and at first should be learnt. The person who learns them first of course is at great advantage.
Vocabulary workshop answers can be found by several means. But even if you are not the first most people for checking up the new arrivals and looking for the new words then do not have to be worried as there is no age gone for learning. Surly you can begin learning at any age. The beginning of learning is possible and feasible and can be achieved at any point in the life. No specific age is for learning or is known as the learning age. vocabulary answers if your looking for a good dude/girl you won't find them because we all make mistakes you just have to find the one that's worth the search" Can you guys follow me? It would be awesome if you did! mas nervioso que vaca en matadero !!! I'm happy that you spend more time working on your car than on our relationship. I'll remember that next time you need a ride princessprobz Para qué enamorarme si ya soy torpe, olvidadiza, no duermo y lloro por las noches. MY 4000TH message goes to & go follow them black educated kids!! If you DONt it shows how ignorant you are!!! Team Chuck has cuter players. I think. Y un día voy a fingir que no tengo corazón y a ver que haces sin tu juguetito. ": Haven't been on here all day." how everrrryone likes it. Np Chris Brown - Turn Up The Music VIDEO & PHOTOS: TV5 Press Conference for Nandito Ako Just added to D-D nf :) Video de mulheres e seu jeito com animais RT ": Haha senyumnya bikin kangen. lol" HAHAHAHA PEACH REPLY MY messageS OMGGGGGGGGGGGG. Bemiddeling arbeidsconflict NBA mislukt. Clubs en spelers nu al 111 dagen in impasse. Krankzinnig en financiële catastrofe basketball loveING FOLLOW! FF holaa genteee!!!! como estan? C: yo aburrida jodida y con hambre jajaja odio la gripa xD I just told you. I hate waking up and paying for last night wit a hangover goodnite miketyson lol Beta State to Open Live 105's Not So Silent Night: indie alternative musicmonday Just finished kicking a beats ...it's been giving me the runaround for over a year now.. Ha but I'm at the mall tho baby girl carrying around magnums in her purse but she cant take hahahah rt Viendo la novela con mi mama. Que basica soy ;) night night :) go ice your ankle!! Be Self Sufficient. Motivate Yourself Really interesting piece explaining what makes Jeremy Lin's dribble drive so effective vocabulary answers ostavi I meni? :D Jjja muy buena I just saw that also! Biff Henderson getting in there! uyyy que cambio eh chiquilla, el otro dia si nos mandasde a Ver-Galavision me alegra k estes bien Life changes are NOT suppose to paralyze you, they're suppose to help you discover who you are. WiseWordsToLiveBy? thx Candace I luv u for tht! When I love . I LOVE HARD <3 Bruno Mars toca amanhã em SP. Está preparado? Curta o clipe do cantor aqui: Lo primero que tienes que saber es. LOOOOOOOOOSER Check out my new EP Exercise Download + Stream Yup, yup, yup .. Tengo hambre, pero me aguanto como la prole. oeh dit valt me tegen JG. CONGRATS HOLLYWOOD BABY!! muahahahak untuk ngegantiin model MV blue atau untuk apa ni? Jadi auditornya saja aku sudah bahagia (ƪ) OMG 90's kids. Remember these toys? - spon its like REALLLLY boring right now. cagao de sueño :/ todo sea por el curi!! Unfriend You GreysonQuiz2 245 Ahora: Phineas y Ferb. Prox (11:00): Los Hechiceros de Waverly Place :-) Damos RT a los messages más relevantes... Qué esperas? Síguenos! LOVE you all more.... GREAT night Great food. AMAZING family..Welcome ;) ;) , missed my 4k message -_- well 4,010 goes out to , sorry for curvin your life today, you my ride or die!! luhyouboo fashion is weak they be wastin all the models. I am so upset I missed this! Take me back to Mykonos now!!!!!! Are my eyes tricking me or is that an undershave on Rooney Mara? I'd go for her. Still in da studio trillionniggaz é. Mas do jeito q minha sorte anda... Aiiiiii genteeee! Eu tenho q ir. Vou começar meu show aqui. Num é possivel! well all I can say is have fun n don't stay n the bathroom for four hours of ur life... lmao:-) yea yea. tf y'all doing Kinda Wish I Would Have Went Up To Milwaukee This Morning With And im salty lol |
|||
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 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 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
