wiki:TicketQuery

Version 1 (modified by trac, 3 years ago) ( diff )

--

TicketQuery Wiki Macro

The TicketQuery macro lets you display information on tickets within wiki pages. The query language used by the [[TicketQuery]] macro is described in TracQuery page.

Usage

[[TicketQuery]]

Wiki macro listing tickets that match certain criteria.

This macro accepts a comma-separated list of keyed parameters, in the form "key=value".

If the key is the name of a field, the value must use the syntax of a filter specifier as defined in TracQuery#QueryLanguage. Note that this is not the same as the simplified URL syntax used for query: links starting with a ? character. Commas (,) can be included in field values by escaping them with a backslash (\).

Groups of field constraints to be OR-ed together can be separated by a literal or argument.

In addition to filters, several other named parameters can be used to control how the results are presented. All of them are optional.

The format parameter determines how the list of tickets is presented:

  • list -- the default presentation is to list the ticket ID next to the summary, with each ticket on a separate line.
  • compact -- the tickets are presented as a comma-separated list of ticket IDs.
  • count -- only the count of matching tickets is displayed
  • rawcount -- only the count of matching tickets is displayed, not even with a link to the corresponding query (since 1.1.1)
  • table -- a view similar to the custom query view (but without the controls)
  • progress -- a view similar to the milestone progress bars

The max parameter can be used to limit the number of tickets shown (defaults to 0, i.e. no maximum).

The order parameter sets the field used for ordering tickets (defaults to id).

The desc parameter indicates whether the order of the tickets should be reversed (defaults to false).

The group parameter sets the field used for grouping tickets (defaults to not being set).

The groupdesc parameter indicates whether the natural display order of the groups should be reversed (defaults to false).

The verbose parameter can be set to a true value in order to get the description for the listed tickets. For table format only. deprecated in favor of the rows parameter

The rows parameter can be used to specify which field(s) should be viewed as a row, e.g. rows=description|summary

The col parameter can be used to specify which fields should be viewed as columns. For table format only.

For compatibility with Trac 0.10, if there's a last positional parameter given to the macro, it will be used to specify the format. Also, using "&" as a field separator still works (except for order) but is deprecated.

Example

Example Result Macro
Number of Triage tickets: 793 [[TicketQuery(status=new&milestone=,count)]]
Number of new tickets: 793 [[TicketQuery(status=new,count)]]
Number of reopened tickets: 0 [[TicketQuery(status=reopened,count)]]
Number of assigned tickets: 0 [[TicketQuery(status=assigned,count)]]
Number of invalid tickets: 906 [[TicketQuery(status=closed,resolution=invalid,count)]]
Number of worksforme tickets: 290 [[TicketQuery(status=closed,resolution=worksforme,count)]]
Number of duplicate tickets: 406 [[TicketQuery(status=closed,resolution=duplicate,count)]]
Number of wontfix tickets: 638 [[TicketQuery(status=closed,resolution=wontfix,count)]]
Number of fixed tickets: 5467 [[TicketQuery(status=closed,resolution=fixed,count)]]
Total number of tickets: 11214 [[TicketQuery(count)]]
Number of tickets reported or owned by current user: 0 [[TicketQuery(reporter=$USER,or,owner=$USER,count)]]
Number of tickets created this month: 30 [[TicketQuery(created=thismonth..,count)]]
Last 3 modified tickets: #11214, #11213, #11212 [[TicketQuery(max=3,order=modified,desc=1,compact)]]

Details of ticket #1:

[[TicketQuery(id=1,col=id|owner|reporter,rows=summary,table)]]

Ticket Owner Reporter
#1 SF/strigeus SF/jackburton
Summary Elayne climb down with no rope (1° room)

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:

#73
Atlantis: problem using bead in necklace
#76
Music is played too slow....
#107
indy4 montecarlo glitch
#122
Can't leave Stan's in MI1
#155
Minor bug on Iceland
#179
Monkey 1 MP3 crash
#182
small music annoyance :)
#183
part screens
#221
No music while credits
#224
Mouse cursor is not updated (Act 2)
#226
Chrono-John Animation glitch
#242
sam&max freeze during bumpusville sing
#248
(554619) sam and max problem
#251
indy3: crash when fighting boxer
#265
Sound effect plays when entering a room
#274
Meeting Sophia GFX Glitch
#279
SAM: Talking
#283
Indy4 dissapearing actors
#288
Missing moving graphic
#292
no digital sounds in MI2
#302
Sound unsynced : Hogie on roof
#303
Sound unsynced : Bernard on roof
#304
Sound unsynced : Laverne on roof
#330
Declaration Bug in Script_v1.cpp
#388
Infinite loop
#409
mi2: keyboard layout change needed
#448
Crash when discovering world of fish
#451
Freeze at Rotating Restraunt
#453
S&M Imuse failing sounds,wrongsounds ect
#464
ZAK256: ambient sounds not looped
#473
Sam'n'Max music during opening credits
#534
MI1: MP3 decoding error
#547
DIG: jerky graphics
#558
DIG: Minimised actors/unwanted scrolling
#567
DIG: Scrolling
#574
DIG: Subtitles redraw problems
#585
DIG: Game lockup in elevator room
#596
ALL: text displays cut off
#597
MI2 : cut txt with some long sentences
#607
INDY3: Wrong sprites in intro
#612
Inventory (Lower Left) Wanders
#622
DIG: Miniaturized Shuttle Crew
#623
Dig: NPC speech interrupted too early
#630
No sound effects
#649
INDY3: Music doesn't loop
#658
Corrupted graphics in startup sequence
#661
loading bug
#672
DIG: no object labels
#675
Crash when turning on lighter in Seatle cave
#685
16:9 ?!
#698
Assertion failed on 0.3.1cvs
#734
COMI : Repeated sound warning (can lockup on Win CE)
#742
SAM : game crashes when powering up telescope
#789
COMI: Too many scripts running
#809
DIG: actors freeze in tomb entrance
#820
DIG: Italian version with ingame random text
#825
DIG: Captions are all wrong with italian version
#827
MI2: Graphic glitches in Amiga version
#850
voice versus subtitles
#874
Ending: Can't quit when you're done
#933
ZAKDEMO: Missing subtitles
#948
FT: broken voices
#999
LOOMCD: credits freeze
#1026
LOOM: closing credits flicker
#1097
Simon 2 hebrew EXEC
#1121
DOTT: Crash when adding stamp to contract
#1156
ScummVM 0.5.1 for Dreamcast
#1165
DC: Intro problems
#1174
COMI: Sound que buffer overflow
#1285
FOA: Invalid actor
#1287
ALL: SDL crash (regression)
#1310
FOA: Crash when talking to Sophia
#1333
ALL: crash when clicking the F5 options menu (regression)
#1366
MM V1: Dave doesnt stop moving lips
#1390
DIG: Crashes when trying to open 3rd door in Nexus
#1391
COMI: Crashes on island
#1392
CMI: Strangeness in the NUT renderer
#1395
DIG: Crash (segfault)
#1420
FT: Text actor flicker (reopens 778281 I guess)
#1450
LOOMCD: Subtitles config option is not honored
#1463
Mac OS X: Mouse click don't always register when windowed
#1467
FT: Music for Bunnies Plays Continuously
#1474
COMI: An extra Wally-head appears when he weeps
#1489
COMI: Text scrolls away during ship view
#1535
Crash on imuse sound assert
#1545
WISHLIST: FT and DIG further compression (SAN, BUN files)
#1561
COMI: volume setting doesn't work
#1567
scummvm is not 64-bit clean
#1586
COMI: Part III frozen
#1617
COMI: LeChucks colours appear messed up
#1634
FT: crashes after taking welding torch
#1649
COMI: Graphics are incorrectly layered
#1651
DIG: Hang up when first meet Maggie in the "library"
#1652
FT: Crash on bartender scene
#1673
I cannot speak with the gardener
#1677
COMI - Guybrush vanishes after cutscene
#1685
SAM: graphics glitches while talking in snukey's restaurant
#1770
MI1: crash after intro
#1806
WINCE: iPaq time display problem
#1815
COMI: Guybrush dissapears after cut scene
#1879
BASS: Boy and fake gardener refuse to talk / lock up
#1899
BASS: Lock up when talking to the gardner
#1912
Crash when you enter the church
#1913
Ooops, I've found the cause, it's the translation. Sorry!!!
#1919
PALM: ScummVM disables auto power off
#1920
PALM: ScummVM breaks auto-off
#1924
FT: Movies Cut Short/Audio Error
#1928
COMI: Hang at start of part 3, during crew song
#1932
FT: Actor priority bug
#1933
MI1: Game crashes when the church in town is entered.
#1963
BASS: Locked characters + interaction = freeze
#1986
MI2: Native MT-32 mode corrections
#2012
BASS: "Invalid Mode(16)" crash/exit
#2050
BASS: Unresponsive characters
#2079
SIMON2: The game don\'t run
#2080
SIMON2: The game don\'t run
#2170
Problem Selecting dialog with mouse wheel
#2181
MI1 SegaCD: not all swordfighting dialog is selectable
#2201
BS1: EKG machine bleep repeat
#2224
ITE: MT32 Emu distortion at Tycho Nordpfoth
#2225
MONKEY2 FMTOWNS iMuse Bug
#2247
SIMON1: Dissapearing Box at Swampling
#2249
Box at Swampling disappears
#2269
MANIACNES: characters fly upstairs, ignoring walls
#2283
ZAKV1 Problems walking to martian pyramid sarcophagus
#2290
black boxes overpaint animations
#2298
Mi2towns Kanji crashes at start with MT32 enabled
#2312
Mi2towns Kanji crashes at start
#2313
INDY4Towns Kanji crashes with Font-Rom enabled
#2324
Palette color error in Loom FM-Towns
#2351
F5 Key randomly doesn't work
#2359
MT-32: Problems with ITE.
#2361
DIG: Crystal robot command sequence crashes if overloaded
#2367
BASS: Game hangs towards the end
#2372
DOTT: Not completable on PSP
#2389
PSP ScummVM Save Not Working
#2405
BASS: breakdown on the bottom level
#2406
BASS: Robot stuck, can't progress
#2418
Sega CD Monkey Island insult issues
#2486
DEB: Debian package creation problem
#2515
HE SPYFOX 2: Lift glitch when reloading
#2523
INDY 3: Crash on PS2 Port
#2525
INDY 3(VGA & FMTOWNS: Won't start for PS2 port
#2534
MMNES - Walking and talking doesn't display properly
#2552
ZAKTOWNS: Some keyboard shortcuts don't work
#2573
COMI: A/V out of synch in intro movie
#2587
MM: Dreamcast: gives a "no valid games" error.
#2588
Kyra: Dreamcast: Gives "no version of Kyrandia found" error
#2618
SPY FOX 1: Prevents continuation of game
#2633
SOMI SegaCD: Dialog Option Problems
#2634
FOA FM-TOWNS: Black boxes during logo sequence
#2646
Kyrandia problem with Translation
#2680
PAJAMA3: Weird Graphics with Soda Cans
#2684
FF "Itemheap overflow" on start
#2695
ZAK V1 C64: Minor Graphics Glitch when entering a room
#2696
PUTTZOO: Crash on startup
#2717
BASS: Can't communicate with Piermont
#2730
DOTT: Graphic glitches while kite comes down
#2764
SYMBIAN: FOA crashes in balloon scene
#2857
PSP: DOTT Crash when washing the carriage
#2858
INDY3: Graphic/script? error
#2875
SYMBIAN: SCUMM crash at screen moving
#2902
Three crashes for Symbian S60V3
#2924
MI2 FM-TOWNS: Intro credits drawn incorrectly
#2948
SYMBIAN: SAM: crash at ball of twine
#3002
WINCE: scummvm.ini induced crash
#3007
WINCE: Broken Sword II Crash when using items
#3018
MAZE: Dutch version doesn't start
#3042
SPYFOX 1: Graphics overdrawn in the "Go Fish!" game
#3112
SQ2: Walk glitch
#3116
BASS: stucked when Joey is on my way to the exit
#3120
WINCE: time is removed from taskbar
#3164
GOB3:Hebrew Version Crashes ingame
#3197
FREDDI 1: DUTCH MAC version crashes on startup
#3212
WATER: Corrupted graphics after loading saved game
#3221
WINCE: AGI games function keys
#3231
PUTTRACE: After loading saved game the screen is incomplete
#3240
INDY3: Music volume can not be set
#3247
Inaccurate music rendering
#3372
WINCE: consecutive left click bug
#3375
WINCE: GOB3: Crash when looking at object
#3413
LURE: unsupported version
#3428
Lure of Tempres German MD5
#3466
ZAK FM-TOWNS: Mars button crash
#3514
Indy3 FMTowns Spanish Fanmade Freezes on starts
#3601
German DOS version crashes when talking to the dragon
#3606
PALMOS: BASS crashes when loading
#3610
COMI: Crashes just after beginning of Pt3
#3613
LURE/DOS: ScummVM 0.11.0 quits on talking to dragon
#3765
WII: Pressing "j" via Wii-Mote instead of "y"
#3776
GCC 3.3: Cannot Compile M4
#3795
BASS: PSP: Crash when entering door with actor exiting
#3837
TINSEL: Discworld 1, German (?) CD
#3879
IHNM: Crash when trying to speak with the 2 entity
#3915
MONKEY: Can't load a save of the final scene
#3920
Woodruff MD5
#3924
KYRA1: MidiParser - Exceeded polyphony
#3946
MICKEY: Spaceship computer does not give clues
#3953
GOB3 : Unknown Spanish version
#3955
Full Throttle crashes while driving
#3997
GUI: Crash when trying to add a game
#3999
LOOM: Non ASCII chars in-game dialogs not supported
#4017
ITE: Crash when get to storm
#4051
DOG: UNKNOWN Windows Dutch version
#4073
Wiki Datafiles - Missing Needed Files
#4104
DWII crashes after logo movies on PPC OSX 10.5.6
#4119
AGI: in game hotkey Ctrl + d used by debugger
#4138
Act III - Alchemist Glitch
#4250
Full Throttle (Russian) crashes on Scumm VM 0.13.0
#4316
COMI: Guybrush walks in place; ESC doesn't stop speech
#4348
SCUMM FM-TOWNS: Kanji text overwrites
#4367
MONKEY: Wrong Palette for Amiga-Versions
#4387
SCI: KQ5 French floppy checksum
#4394
SCI: Pepper's Adventure In Time 1.000 English
#4436
DC: Drascula (Spanish) Intro Movie Crash
#4442
Unable to select subtitles in Atlantis and Simon 1
#4443
BALLOON: Missing background when loading a game on a level
#4534
SYMBIAN: COMI: Sound crash
#4541
KQ1: King's text at the start of game flashes by too quickly
#4553
Waxworks: Can't load cemetery savegame from outside cemetary
#4557
FREDDI4: Voice is heard but the mouth doesn't move
#4592
Discworld Neon Edition German crashes when trying to start
#4621
GOB3: Cannot continue in game
#4648
No ScummVM tools package for MacOS X available for download
#4651
SWORD1: voice speech faster than normal (Motorola ZN5)
#4657
BASS: crash switching screen mode during intro cutscene
#4659
NIPPON: Crash trying to read letter
#4670
NIPPON: Crash when examining parcel
#4671
NIPPON: Wrong labels
#4682
Urban runner FR md5
#4688
ITE: Shiala rescue bug
#4694
OS X: make static is missing zlib
#4727
COMI: no sound and error massage on Symbian V6
#4739
Kyrandia 3 Russian MD5
#4765
ITE: MidiParser::hangingNote(): Exceeded polyphony!
#4793
KYRA2: MD5 unknow in spanish version
#4825
The Legend of Kyrandia: Book Two: Hand of Fate - polish
#4842
RTZ: Stall / Audio Loop after not playing a "few" hours
#4873
MI2: graphical glitches
#4937
Gameplay issue / Fighting bugs
#4940
ECOQUEST2: Audio Irregularities
#4945
signature mismatch in laura bow 2 introduction
#5002
PEPPER demo: sound glitch
#5063
QFG1 VGA: Game crashes entering Tower Room in Erasmus's Hous
#5067
ECOQUEST2: Graphical glitch
#5089
ISLANDBRAIN: No coloured text
#5100
QG3: Restoring from opening screen breaks game
#5137
QFG3: Text Window Glitch
#5157
PEPPER: Speech balloon colors
#5186
KQ5: Graphical glitch after defeating Mordack
#5202
LB2CD: Safe doesn't stay open
#5208
KQ4: background doesn't update when falling off stairs
#5212
SQ1EGA: Some channels are not turned off in the Kerona Bar
#5214
HOYLE4: Text boxes are transparent
#5220
LSL1/Spanish:Larry becomes stuck entering the bathroom
#5221
LSL1/Spanish: Larry and Fawn get stuck before the discodance
#5234
SQ1EGA: Kerona Bar Stuck Notes
#5235
SQ1EGA: Sprite Animation Palette Screwed Up
#5246
Hoyle3 EGA: Same Crashes as VGA
#5265
LB2Floppy & LB2CD: Actor takes strange path
#5286
LB2Floppy: Murderer stuck at mastodon room
#5291
LAURABOW2 CD: Crash at the introduction
#5297
MOTHERGOOSE: Bug 3051163 not fixed as of r52298
#5301
QFG1VGA: Combat non-responsive when fighting weapon master
#5322
SQ5: Crashes on load BattleCruiser game
#5351
SCUMM: Wrong charset used when pressing pause key
#5369
MMNES: Crash After Ed Leaves if in His Room Before Doorbell
#5403
LSL2 Crashes (GfxPort Error)
#5484
ECOQUEST1 German: Graphic glitches
#5488
Qfg2: crash loading save game of imported character
#5493
Crash at Submarine pilot session
#5495
Eco Quest 1 - Ending crashed
#5497
KQ4: music hangs using MT-32
#5519
SQ4 German: crash when flying in Skate-O-Rama
#5556
GOB Engine: IOS version mouse unusable
#5557
SQ4 CD English - Roger won't enter 2nd screen
#5628
Freddi Fish 1-4 Cursor Missing in ScummVM Wii Homebrew?
#5655
PHARKAS: Karaoke ball animation
#5739
Indiana Jones fate of atlantis talkie version does not start
#5740
Sam and Max german cd version does not start (ipod)
#5741
Sam and Max english cd version does not start (ipod)
#5785
Ringworld: Spanish CD MD5
#5786
Ringworld: Spanish CD MD5
#5820
SCI: LONGBOW - Crash in the Sherwood forest.
#5821
IHNM: Game doesn't work on iOS devices.
#5868
KQ6 - Freezing when picking up nightingale's letter
#5932
Soltys WINCE: Scummvm crash at start
#5941
qfg1 VGA graphics palette crash
#5959
ANDROID: TOON - Unable To Examine Fish Bowl Chest
#6010
LOOM: Switching between MT-32 and AdLib crashes ScummVM
#6015
SIMON1DOS French : subtitle glitch in introduction
#6027
Gold Rush Apple IIGS: crash on first screen
#6037
SCUMM: MI2 Dancing Skeletons Game Loop
#6069
SCUMM: accented characters not displayed in msg boxes
#6072
COMPOSER: The Little Samurai crash on start
#6099
ZAK - Can't use anything in Shuttle Bug
#6100
PS2: Crash on Loom (PCE)
#6158
ANDROID: BASS Touch Screen Alignment Issues
#6241
SCI: Longbow: MT32 does not sound right
#6257
ANDROID: borders in 4:3/unstretched mode flicker
#6289
Problem with Zak Mckracken Amiga and C64 versions
#6342
INDY3: PC Versions Not Looping Sound Effects
#6351
SCUMM: "Game Paused" label is not properly displayed
#6360
MONKEY2: Crash During "Dream Sequence"
#6397
Eye of the Beholder spanish version "game not found"
#6398
Eye of the Beholder 2 spanish version "game not found"
#6400
SCI: PQ1VGA - crash at the gun locker
#6418
EcoQuest 2 - Das Geheimnis Des Regenwaldes [GERMAN]
#6421
TINSEL: DW 2 assertion on start
#6432
SYMBIAN: remove macro conflict in system headers
#6433
SIMON2: Problem during intro in french talkie version
#6436
KYRA2: Music volume glitch after fadeout
#6439
remove macro conflict in system headers
#6482
PUTTZOO : Graphic Glitch on Lion Cup close up scene
#6521
NEVERHOOD: buggy waterfall sound
#6620
RINGWORLD2: F5 to save doesn't work the first time
#6626
SYMBIAN: WINTERMUTE: script.cpp:491: warning: dereferencing type-punned pointer will break strict-aliasing rules
#6662
The Neverhood random crash in Hall of Chronicles
#6675
ANDROID: SCUMM MI2 - Music Audio Distorted
#6698
DREAMWEB: Crash after intro on OSX 10.9.4
#6714
SPYFOX3: Spy Fox's head disappears briefly when looking at keycard device
#6715
Android-Port Cursor jumps in upper left corner
#6743
ANDROID: ScummVM fails to start V5.0 (Lollipop) devices
#6880
Android: Crashes on BT keyboard (dis)connect
#6930
SHERLOCK: Holmes in wrong position after loading a savegame
#7006
Linux: Scummvm config file
#7157
DEB package for Debian, is not installable.
#7177
SHERLOCK: The crash in the rumsey shop- spanish version
#7252
Secondary data file path
#7298
Modularization
#7310
Support for zip games
#7340
ini-entry for mp3, ogg dir
#7345
Mouse movement recording/playing feature
#7349
INDY3: Unable to get IQ Points
#7361
Speech off/on option.
#7363
add an optioonal CDDA path configuration for each game
#7375
Config file: look in current directory first
#7379
Amiga MI2 and Amiga INDY 4 music
#7391
recording videos like in ZSNES
#7396
Adding MP3 and Ogg Support
#7426
Global and local configuration files
#7469
Add NES Maniac Mansion german
#7479
advanced fullscreen option
#7483
[Windows] scummvm.ini is in the wrong position
#7497
MACOSX: Make Bundle Ignores ./configure
#7507
Language Packs, again
#7549
return to scummvm gui
#7553
INDY3: IQ Points support
#7590
WIN32 MIDI Device Selection
#7633
GUI: make it possible to revert to "default" savepath
#7701
Wii: Support Nunchuk
#7727
WinCE/PocketPC screen alignment on WVGA devices with scalers
#7779
GC : Save to Memorycard
#7789
Both text and speech in SQ4
#7790
TV-Out option for PSP
#7796
SCI: Add option to hear MIDI sfx instead of digital
#7809
teenagent czech version
#7859
[Linux] Move ~/.avidemux to a proper place (follow
#7935
GDI Port: CD Audio playing patch
#8093
SAM: Conroy song hack
#8368
edge3x.cpp for new 3x scaler
#8386
GUI: Visible active tab
#8878
DRASCULA: correcting errors
#8881
MADE: Rodney's Funscreen rename
#9226
MMC64: Radio Crash Fix
#9559
Crash when repeatedly going in and out of full screen on OS X
#9601
WME: Helga Deep in Trouble - graphics glitch
#9699
LOL: Unknown Spanish Floppy version
#9794
SCI: GK1: Scoring sound missing
#9804
No ScummVM version
#9814
Gabriel Knight 1 - Chapter Intros Slow
#9842
SCI: KQ7 Win ES: Wrong video palette
#9859
SCI: GK2: Video Sync Issues for 1930.vmd
#9888
TITANIC: Nothing happening using hose on SuccUBus
#10005
Add 6xbrz filter or Hq5x
#10079
SCI: SHIVERS1: GMM save games don't show useful picture
#10087
TITANIC: Assertion failure using volume slider
#10174
WIN32: no output for command line usage
#10181
SCI: LSL7: Unable to save
#10195
GUI: Add screenshot save directory parameter
#10203
MI3 Disc 2 troubles
#10319
FULL THROTTLE: Not understandable language in pause mode
#10334
CMD: Strange behaviour when trying to launch a game by gameid
#10346
Horse clips through fountain in Banbury Cross cutscene
#10379
SCI: SQ6 (German version) Wilco walking in the air
#10415
PQ4 CD - Game Crashes On Entering Bitty Kitty Club
#10442
TITANIC: Game crashes on Floor 38
#10505
Series LSL crashes
#10506
Series LSL crashes
#10507
Series LSL crashes
#10508
Series LSL crashes
#10528
SPY FOX 3 GERMAN: Crash in the Hair Dressing Room.
#10545
BusyTown Best Christmas Ever Richard Scary
#10555
clarify subtitle speed direction
#10561
SCUMM: Indiana Jones 3 (FM-Towns) disorted playback in Venice
#10677
SCI: SQ3 DOS MD5
#10762
QFG4: Screenshots within savegames obscured by control panels
#10776
QFG4: Resting in Nikolai's house results in consecutive moonrises
#10859
QFG4 room entry causes rightmost pixel line rendering error
#10902
KYRA2: Add support for Polish floppy version
#10988
Blade Runner lockup when entering Eisenduller Gravity Room
#10998
Freddi Fish 1: handle on grandma's door remains there when the door opens
#11023
QFG4: Colorful glitch when going left from town
#11045
QFG4: castle doors don't seem to get oiled
#11165
SCI: Hoyle 5 - Uninitialized read
#11213
QFG3 saving crash - Assertion `isValidRect()' failed.

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. This also displays the link and description of a single ticket:

[[TicketQuery(id=123)]]

This is displayed as:

#123
MI CD Crashing when loading new rooms...

A more compact representation without the ticket summaries is:

[[TicketQuery(version=0.6|0.7&resolution=duplicate, compact)]]

This is displayed as:

#73, #76, #107, #122, #155, #179, #182, #183, #221, #224, #226, #242, #248, #251, #265, #274, #279, #283, #288, #292, #302, #303, #304, #330, #388, #409, #448, #451, #453, #464, #473, #534, #547, #558, #567, #574, #585, #596, #597, #607, #612, #622, #623, #630, #649, #658, #661, #672, #675, #685, #698, #734, #742, #789, #809, #820, #825, #827, #850, #874, #933, #948, #999, #1026, #1097, #1121, #1156, #1165, #1174, #1285, #1287, #1310, #1333, #1366, #1390, #1391, #1392, #1395, #1420, #1450, #1463, #1467, #1474, #1489, #1535, #1545, #1561, #1567, #1586, #1617, #1634, #1649, #1651, #1652, #1673, #1677, #1685, #1770, #1806, #1815, #1879, #1899, #1912, #1913, #1919, #1920, #1924, #1928, #1932, #1933, #1963, #1986, #2012, #2050, #2079, #2080, #2170, #2181, #2201, #2224, #2225, #2247, #2249, #2269, #2283, #2290, #2298, #2312, #2313, #2324, #2351, #2359, #2361, #2367, #2372, #2389, #2405, #2406, #2418, #2486, #2515, #2523, #2525, #2534, #2552, #2573, #2587, #2588, #2618, #2633, #2634, #2646, #2680, #2684, #2695, #2696, #2717, #2730, #2764, #2857, #2858, #2875, #2902, #2924, #2948, #3002, #3007, #3018, #3042, #3112, #3116, #3120, #3164, #3197, #3212, #3221, #3231, #3240, #3247, #3372, #3375, #3413, #3428, #3466, #3514, #3601, #3606, #3610, #3613, #3765, #3776, #3795, #3837, #3879, #3915, #3920, #3924, #3946, #3953, #3955, #3997, #3999, #4017, #4051, #4073, #4104, #4119, #4138, #4250, #4316, #4348, #4367, #4387, #4394, #4436, #4442, #4443, #4534, #4541, #4553, #4557, #4592, #4621, #4648, #4651, #4657, #4659, #4670, #4671, #4682, #4688, #4694, #4727, #4739, #4765, #4793, #4825, #4842, #4873, #4937, #4940, #4945, #5002, #5063, #5067, #5089, #5100, #5137, #5157, #5186, #5202, #5208, #5212, #5214, #5220, #5221, #5234, #5235, #5246, #5265, #5286, #5291, #5297, #5301, #5322, #5351, #5369, #5403, #5484, #5488, #5493, #5495, #5497, #5519, #5556, #5557, #5628, #5655, #5739, #5740, #5741, #5785, #5786, #5820, #5821, #5868, #5932, #5941, #5959, #6010, #6015, #6027, #6037, #6069, #6072, #6099, #6100, #6158, #6241, #6257, #6289, #6342, #6351, #6360, #6397, #6398, #6400, #6418, #6421, #6432, #6433, #6436, #6439, #6482, #6521, #6620, #6626, #6662, #6675, #6698, #6714, #6715, #6743, #6880, #6930, #7006, #7157, #7177, #7252, #7298, #7310, #7340, #7345, #7349, #7361, #7363, #7375, #7379, #7391, #7396, #7426, #7469, #7479, #7483, #7497, #7507, #7549, #7553, #7590, #7633, #7701, #7727, #7779, #7789, #7790, #7796, #7809, #7859, #7935, #8093, #8368, #8386, #8878, #8881, #9226, #9559, #9601, #9699, #9794, #9804, #9814, #9842, #9859, #9888, #10005, #10079, #10087, #10174, #10181, #10195, #10203, #10319, #10334, #10346, #10379, #10415, #10442, #10505, #10506, #10507, #10508, #10528, #10545, #10555, #10561, #10677, #10762, #10776, #10859, #10902, #10988, #10998, #11023, #11045, #11165, #11213

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:

406

A graphical use of the macro is with the format=progress attribute:

[[TicketQuery(milestone=0.12.8&group=type,format=progress)]]

For example for one of the upcoming milestones, bars are shown by ticket type:

defect

8022 / 8604

patch

1680 / 1717

enhancement

701 / 893


See also: TracQuery, TracTickets, TracReports, TracGuide

Note: See TracWiki for help on using the wiki.