wiki:TicketQuery

TicketQuery Wiki Macro

The TicketQuery macro lets you display ticket information anywhere that accepts WikiFormatting. The query language used by the [[TicketQuery]] macro is described in the 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.

Examples

Example Result Macro
Number of Triage tickets: 1584 [[TicketQuery(status=new&milestone=,count)]]
Number of new tickets: 1584 [[TicketQuery(status=new,count)]]
Number of reopened tickets: 152 [[TicketQuery(status=reopened,count)]]
Number of assigned tickets: 0 [[TicketQuery(status=assigned,count)]]
Number of invalid tickets: 1520 [[TicketQuery(status=closed,resolution=invalid,count)]]
Number of worksforme tickets: 236 [[TicketQuery(status=closed,resolution=worksforme,count)]]
Number of duplicate tickets: 503 [[TicketQuery(status=closed,resolution=duplicate,count)]]
Number of wontfix tickets: 236 [[TicketQuery(status=closed,resolution=wontfix,count)]]
Number of fixed tickets: 4477 [[TicketQuery(status=closed,resolution=fixed,count)]]
Number of untriaged tickets (milestone unset): 2401 [[TicketQuery(status!=closed,milestone=,count)]]
Total number of tickets: 9943 [[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: 10 [[TicketQuery(created=thismonth..,count)]]
Number of closed Firefox tickets: 0 [[TicketQuery(status=closed,keywords~=firefox,count)]]
Number of closed Opera tickets: 0 [[TicketQuery(status=closed,keywords~=opera,count)]]
Number of closed tickets affecting Firefox and Opera: 0 [[TicketQuery(status=closed,keywords~=firefox opera,count)]]
Number of closed tickets affecting Firefox or Opera: 0 [[TicketQuery(status=closed,keywords~=firefox|opera,count)]]
Number of tickets that affect Firefox or are closed and affect Opera: 0 [[TicketQuery(status=closed,keywords~=opera,or,keywords~=firefox,count)]]
Number of closed Firefox tickets that don't affect Opera: 0 [[TicketQuery(status=closed,keywords~=firefox -opera,count)]]
Last 3 modified tickets: #9961, #9866, #9960 [[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 Michael Niedermayer Michael Niedermayer
Summary Test

Format: list

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

This is displayed as:

No results

[[TicketQuery(id=123)]]

This is displayed as:

#123
Fuzzed sample crashes ffplay

Format: compact

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

This is displayed as:

No results

Format: count

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

This is displayed as:

0

Format: progress

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

This is displayed as:

defect

6549 / 8259

enhancement

933 / 1552

task

37 / 48

license violation

9 / 67

art

12 / 12

sponsoring request

2 / 5

Format: table

You can choose the columns displayed in the table format (format=table) using col=<field>. You can specify multiple fields and the order they are displayed 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 7542)

1 2 3 4 5 6 7 8 9 10 11
Ticket Resolution Summary Owner Reporter
#9960 duplicate Broken alac_at since 5.1 mertozan
#9959 invalid Unrecognized option 'autoexit' MB SOFT
#9954 duplicate Can't decode Bink 2 videos biast12
1 2 3 4 5 6 7 8 9 10 11

Full rows

In table format you can specify full rows 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 7542)

1 2 3 4 5 6 7 8 9 10 11
Ticket Resolution Summary Owner Reporter
#9960 duplicate Broken alac_at since 5.1 mertozan
Description

OS: macOS 11.7 ffmpeg5.1.2 and 5.0.1

5.0.1 working perfectly by this command, but 5.1, 5.1.1 and 5.1.2 is broken

I'm using this command:

./ffmpeg -i Safari_\ Dolby_Digital_Plus.m2ts -map 0:0 -vcodec copy -map 0:1 -acodec alac_at Safari_\ Dolby_Digital_Plus_Out.mkv

ffmpeg 5.0.1 result (success)

./ffmpeg -i Safari_\ Dolby_Digital_Plus.m2ts -map 0:0 -vcodec copy -map 0:1 -acodec alac_at Safari_\ Dolby_Digital_Plus_Out.mkv
ffmpeg version 5.0.1-tessus  https://evermeet.cx/ffmpeg/  Copyright (c) 2000-2022 the FFmpeg developers
  built with Apple clang version 11.0.0 (clang-1100.0.33.17)
  configuration: --cc=/usr/bin/clang --prefix=/opt/ffmpeg --extra-version=tessus --enable-avisynth --enable-fontconfig --enable-gpl --enable-libaom --enable-libass --enable-libbluray --enable-libdav1d --enable-libfreetype --enable-libgsm --enable-libmodplug --enable-libmp3lame --enable-libmysofa --enable-libopencore-amrnb --enable-libopencore-amrwb --enable-libopenh264 --enable-libopenjpeg --enable-libopus --enable-librubberband --enable-libshine --enable-libsnappy --enable-libsoxr --enable-libspeex --enable-libtheora --enable-libtwolame --enable-libvidstab --enable-libvmaf --enable-libvo-amrwbenc --enable-libvorbis --enable-libvpx --enable-libwebp --enable-libx264 --enable-libx265 --enable-libxavs --enable-libxvid --enable-libzimg --enable-libzmq --enable-libzvbi --enable-version3 --pkg-config-flags=--static --disable-ffplay
  libavutil      57. 17.100 / 57. 17.100
  libavcodec     59. 18.100 / 59. 18.100
  libavformat    59. 16.100 / 59. 16.100
  libavdevice    59.  4.100 / 59.  4.100
  libavfilter     8. 24.100 /  8. 24.100
  libswscale      6.  4.100 /  6.  4.100
  libswresample   4.  3.100 /  4.  3.100
  libpostproc    56.  3.100 / 56.  3.100
Input #0, mpegts, from 'Safari_ Dolby_Digital_Plus.m2ts':
  Duration: 00:01:34.16, start: 600.000000, bitrate: 27062 kb/s
  Program 1 
  Stream #0:0[0x1011]: Video: h264 (High) (HDMV / 0x564D4448), yuv420p(tv, bt709, top first), 1920x1080 [SAR 1:1 DAR 16:9], 29.97 fps, 29.97 tbr, 90k tbn
  Stream #0:1[0x1100]: Audio: eac3 (AC-3 / 0x332D4341), 48000 Hz, 7.1, fltp, 1664 kb/s
Stream mapping:
  Stream #0:0 -> #0:0 (copy)
  Stream #0:1 -> #0:1 (eac3 (native) -> alac (alac_at))
Press [q] to stop, [?] for help
Output #0, matroska, to 'Safari_ Dolby_Digital_Plus_Out.mkv':
  Metadata:
    encoder         : Lavf59.16.100
  Stream #0:0: Video: h264 (High) (H264 / 0x34363248), yuv420p(tv, bt709, top first), 1920x1080 [SAR 1:1 DAR 16:9], q=2-31, 29.97 fps, 29.97 tbr, 1k tbn
  Stream #0:1: Audio: alac ([255][255][255][255] / 0xFFFFFFFF), 48000 Hz, 7.1, s16, 128 kb/s
    Metadata:
      encoder         : Lavc59.18.100 alac_at
frame=    2 fps=0.0 q=-1.0 size=       1kB time=00:00:00.00 bitrate=6432.0kbits/frame=  446 fps=0.0 q=-1.0 size=   23808kB time=00:00:14.81 bitrate=13163.8kbitsframe=  694 fps=686 q=-1.0 size=   54528kB time=00:00:23.09 bitrate=19344.9kbitsframe=  988 fps=653 q=-1.0 size=   90112kB time=00:00:32.90 bitrate=22436.9kbitsframe= 1326 fps=659 q=-1.0 size=  130560kB time=00:00:44.17 bitrate=24210.0kbitsframe= 1594 fps=634 q=-1.0 size=  164608kB time=00:00:53.12 bitrate=25384.9kbitsframe= 1934 fps=641 q=-1.0 size=  203008kB time=00:01:04.46 bitrate=25797.6kbitsframe= 2269 fps=645 q=-1.0 size=  241920kB time=00:01:15.64 bitrate=26199.5kbitsframe= 2615 fps=651 q=-1.0 size=  274176kB time=00:01:27.18 bitrate=25761.0kbitsframe= 2822 fps=646 q=-1.0 Lsize=  294879kB time=00:01:34.20 bitrate=25641.6kbits/s speed=21.6x    
video:277141kB audio:17703kB subtitle:0kB other streams:0kB global headers:0kB muxing overhead: 0.011910%

But 5.1 and higher versions gives this result (error) Assertion ret <= 0 failed at libavcodec/encode.c:220 -->this error message showing

./ffmpeg -i Safari_\ Dolby_Digital_Plus.m2ts -map 0:0 -vcodec copy -map 0:1 -acodec alac_at Safari_\ Dolby_Digital_Plus_Out.mkv
ffmpeg version 5.1.2-tessus Copyright (c) 2000-2022 the FFmpeg developers
  built with Apple clang version 11.0.0 (clang-1100.0.33.17)
  configuration: --cc=/usr/bin/clang --prefix=/opt/ffmpeg --extra-version=tessus --enable-avisynth --enable-fontconfig --enable-gpl --enable-libaom --enable-libass --enable-libbluray --enable-libdav1d --enable-libfreetype --enable-libgsm --enable-libmodplug --enable-libmp3lame --enable-libmysofa --enable-libopencore-amrnb --enable-libopencore-amrwb --enable-libopenh264 --enable-libopenjpeg --enable-libopus --enable-librubberband --enable-libshine --enable-libsnappy --enable-libsoxr --enable-libspeex --enable-libtheora --enable-libtwolame --enable-libvidstab --enable-libvmaf --enable-libvo-amrwbenc --enable-libvorbis --enable-libvpx --enable-libwebp --enable-libx264 --enable-libx265 --enable-libxavs --enable-libxvid --enable-libzimg --enable-libzmq --enable-libzvbi --enable-version3 --pkg-config-flags=--static --disable-ffplay
  libavutil      57. 28.100 / 57. 28.100
  libavcodec     59. 37.100 / 59. 37.100
  libavformat    59. 27.100 / 59. 27.100
  libavdevice    59.  7.100 / 59.  7.100
  libavfilter     8. 44.100 /  8. 44.100
  libswscale      6.  7.100 /  6.  7.100
  libswresample   4.  7.100 /  4.  7.100
  libpostproc    56.  6.100 / 56.  6.100
Input #0, mpegts, from 'Safari_ Dolby_Digital_Plus.m2ts':
  Duration: 00:01:34.16, start: 600.000000, bitrate: 27062 kb/s
  Program 1 
  Stream #0:0[0x1011]: Video: h264 (High) (HDMV / 0x564D4448), yuv420p(tv, bt709, top first), 1920x1080 [SAR 1:1 DAR 16:9], 29.97 fps, 29.97 tbr, 90k tbn
  Stream #0:1[0x1100]: Audio: eac3 (AC-3 / 0x332D4341), 48000 Hz, 7.1, fltp, 1664 kb/s
Stream mapping:
  Stream #0:0 -> #0:0 (copy)
  Stream #0:1 -> #0:1 (eac3 (native) -> alac (alac_at))
Press [q] to stop, [?] for help
Output #0, matroska, to 'Safari_ Dolby_Digital_Plus_Out.mkv':
  Metadata:
    encoder         : Lavf59.27.100
  Stream #0:0: Video: h264 (High) (H264 / 0x34363248), yuv420p(tv, bt709, top first), 1920x1080 [SAR 1:1 DAR 16:9], q=2-31, 29.97 fps, 29.97 tbr, 1k tbn
  Stream #0:1: Audio: alac ([255][255][255][255] / 0xFFFFFFFF), 48000 Hz, 7.1, s16, 128 kb/s
    Metadata:
      encoder         : Lavc59.37.100 alac_at
Assertion ret <= 0 failed at libavcodec/encode.c:220
zsh: abort      ./ffmpeg -i Safari_\ Dolby_Digital_Plus.m2ts -map 0:0 -vcodec copy -map 0:1
#9959 invalid Unrecognized option 'autoexit' MB SOFT
Description
ffmpeg started on 2022-10-04 at 14:56:31
Report written to "ffmpeg-20221004-145631.log"
Log level: 48
Command line:
"D:\\GB32\\ffmpeg.exe" -report -f dshow -video_size 1920x1080 -framerate 30 -rtbufsize 48k -i "video=Full HD 1080P PC Camera" -probesize 32 -an -vcodec libx264 -x264-params "nal-hrd=cbr:force-cfr=1:keyint=250" -preset medium -profile high -pix_fmt yuv420p -tune zerolatency -b:v 1000K -bufsize 1500k -f mpegts srt://192.168.1.202:9856 -f mpegts - "|" ffplay -autoexit -loglevel 8 -window_title MBLive_Webcam -x 1280 -noborder -probesize 32 -analyzeduration 0 -fflags nobuffer -flags low_delay -framedrop -strict experimental -i -
ffmpeg version 5.1.2-full_build-www.gyan.dev Copyright (c) 2000-2022 the FFmpeg developers
  built with gcc 12.1.0 (Rev2, Built by MSYS2 project)
  configuration: --enable-gpl --enable-version3 --enable-shared --disable-w32threads --disable-autodetect --enable-fontconfig --enable-iconv --enable-gnutls --enable-libxml2 --enable-gmp --enable-bzlib --enable-lzma --enable-libsnappy --enable-zlib --enable-librist --enable-libsrt --enable-libssh --enable-libzmq --enable-avisynth --enable-libbluray --enable-libcaca --enable-sdl2 --enable-libaribb24 --enable-libdav1d --enable-libdavs2 --enable-libuavs3d --enable-libzvbi --enable-librav1e --enable-libsvtav1 --enable-libwebp --enable-libx264 --enable-libx265 --enable-libxavs2 --enable-libxvid --enable-libaom --enable-libjxl --enable-libopenjpeg --enable-libvpx --enable-mediafoundation --enable-libass --enable-frei0r --enable-libfreetype --enable-libfribidi --enable-liblensfun --enable-libvidstab --enable-libvmaf --enable-libzimg --enable-amf --enable-cuda-llvm --enable-cuvid --enable-ffnvcodec --enable-nvdec --enable-nvenc --enable-d3d11va --enable-dxva2 --enable-libmfx --enable-libshaderc --enable-vulkan --ena  libavutil      57. 28.100 / 57. 28.100
  libavcodec     59. 37.100 / 59. 37.100
  libavformat    59. 27.100 / 59. 27.100
  libavdevice    59.  7.100 / 59.  7.100
  libavfilter     8. 44.100 /  8. 44.100
  libswscale      6.  7.100 /  6.  7.100
  libswresample   4.  7.100 /  4.  7.100
  libpostproc    56.  6.100 / 56.  6.100
Splitting the commandline.
Reading option '-report' ... matched as option 'report' (generate a report) with argument '1'.
Reading option '-f' ... matched as option 'f' (force format) with argument 'dshow'.
Reading option '-video_size' ... matched as AVOption 'video_size' with argument '1920x1080'.
Reading option '-framerate' ... matched as AVOption 'framerate' with argument '30'.
Reading option '-rtbufsize' ... matched as AVOption 'rtbufsize' with argument '48k'.
Reading option '-i' ... matched as input url with argument 'video=Full HD 1080P PC Camera'.
Reading option '-probesize' ... matched as AVOption 'probesize' with argument '32'.
Reading option '-an' ... matched as option 'an' (disable audio) with argument '1'.
Reading option '-vcodec' ... matched as option 'vcodec' (force video codec ('copy' to copy stream)) with argument 'libx264'.
Reading option '-x264-params' ... matched as AVOption 'x264-params' with argument 'nal-hrd=cbr:force-cfr=1:keyint=250'.
Reading option '-preset' ... matched as AVOption 'preset' with argument 'medium'.
Reading option '-profile' ... matched as option 'profile' (set profile) with argument 'high'.
Reading option '-pix_fmt' ... matched as option 'pix_fmt' (set pixel format) with argument 'yuv420p'.
Reading option '-tune' ... matched as AVOption 'tune' with argument 'zerolatency'.
Reading option '-b:v' ... matched as option 'b' (video bitrate (please use -b:v)) with argument '1000K'.
Reading option '-bufsize' ... matched as AVOption 'bufsize' with argument '1500k'.
Reading option '-f' ... matched as option 'f' (force format) with argument 'mpegts'.
Reading option 'srt://192.168.1.202:9856' ... matched as output url.
Reading option '-f' ... matched as option 'f' (force format) with argument 'mpegts'.
Reading option '-' ... matched as output url.
Reading option '|' ... matched as output url.
Reading option 'ffplay' ... matched as output url.
Reading option '-autoexit' ...Unrecognized option 'autoexit'.
Error splitting the argument list: Option not found

Why -autoexit is unrecognized?

#9954 duplicate Can't decode Bink 2 videos biast12
Description

Summary of the bug: It doesn't wanna decode Bink 2 videos How to reproduce:

ffmpeg -i 1.bik -c:v libvpx -b:v 1M -c:a libvorbis -f webm output.wbm

This is the error i get btw

[bink @ 00000184b4761880] Bink 2 video is not implemented

[bink @ 00000184b4761880] Could not find codec parameters for stream 0 (Video: none (KB2i / 0x6932424B), none, 961x530): unknown codec

Consider increasing the value for the 'analyzeduration' (0) and 'probesize' (5000000) options

Input #0, bink, from 'flatline_react_v20_assim_rt02.bik':

Duration: 00:00:25.00, start: 0.000000, bitrate: 6114 kb/s

Stream #0:0[0x0]: Video: none (KB2i / 0x6932424B), none, 961x530, 60 fps, 60 tbr, 60 tbn

Stream mapping:

Stream #0:0 -> #0:0 (? (?) -> vp9 (libvpx-vp9))

Decoder (codec none) not found for input stream #0:0
1 2 3 4 5 6 7 8 9 10 11


See also: TracQuery, TracTickets, TracReports

Last modified 18 months ago Last modified on Apr 17, 2021, 4:33:53 PM
Note: See TracWiki for help on using the wiki.