wiki:TracQuery

Version 3 (modified by trac, 15 months ago) (diff)

--

Trac Ticket Queries

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.

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.

Note: you must have the REPORT_CREATE permission in order to save queries to the list of default reports. The Save query button will only appear if you are logged in as a user that has been granted this permission. If your account does not have permission to create reports, you can still use the methods below to save a query.

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:

Active tickets against 1.0

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:

Assigned tickets by owner

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:

#17
AddComment fails with July 7, 2005 Trunk
#30
Support webadmin interface
#31
Support webadmin interface
#32
Support webadmin interface
#33
Support webadmin interface
#34
Support webadmin interface
#39
# expanded to %23
#51
anchor links broken in trunk.
#54
Poll macro 'anonymous' votes
#68
Easier install?
#77
MySQL , PostgreSQL Access
#88
support for non-DN groups
#108
bounty plugin ?
#145
Need to be able to manage users as a TRAC_ADMIN
#152
Allow TRAC_ADMINs to change user properties
#156
SVN Commit From Trac
#157
SVN Commit From Trac
#203
tracebacks loading trac pages with ldapplugin enabled
#208
Edit Section
#236
missing import of "inspect"
#253
Can't use centralized trac.ini
#257
macro list killed with plugin
#262
iso8859-2 characters in heading names cause TOC script to crash
#285
WikiCalendarMacro: integrate changes from Wiki attachments
#288
Error when used with the built-in PageOutline macro.
#311
Adding new users only by TRAC_ADMIN
#330
blog view - list index out of range
#331
blog view - list index out of range
#349
Search fails due to "no attribute 'to_unicode'"
#352
inline option might be nicer as an un-ordered list
#374
Unicode Problem?
#378
Select reviewers does not handle groups.
#405
Crash when creating or replying to a topic
#406
control over user registration
#437
ticket dependency
#439
TocMacro broken by Trac r3408
#443
spammers have discovered register and are spamming my trac
#449
KeyError: 'id'
#454
plugin does not work on MS Winzoz XP
#479
GeneralLinkSyntaxPlugin interferes with InterTrac
#493
cross trac db summary page
#504
can't change moderators when creating a new forum
#531
Failure sending notification on creation of ticket: notify() takes at least 3 non-keyword arguments (2 given)
#535
update-index failed
#540
Permission denied with TracAccountManager-0.1.2
#543
passwd files don't reload if trac runs as a standalone server
#548
Form based login uses MD5, though this is not documented.
#562
[Patch] Allow multiple navigation-synced instances on same page
#603
Permssion Error
#616
AttributeError:keys exception
#639
Large p4 depots kill virtual memory (patch included)
#641
View Tickets export to PDF?
#645
p4 client option
#653
Add ability to use spam safe e-mail address
#676
traceback while attempting to register
#691
Add timer counter while ticket is "open"
#695
problems to login in the Internet
#717
Multiple unix groups
#719
Updating TracFrenchTranslation project
#721
Adding component after milestone started
#730
Calendar popups for time entry
#773
Enabling WikiGoodiesPlugin Messes Up QuickJump in the Search Box
#782
does not work with trac 0.10
#783
does not work with trac 0.10
#793
Registering a new User produces error - no such file or directory
#800
Make RBAC compatible with trac 0.10
#812
TracEnv won't upgrade
#826
pagetopdf concatenation error
#856
tags are erased
#873
broken TOC macro, with trac svn
#884
XmlRpcPlugin fails with latest Trac release
#911
Migrating Tracforge from sqlite to Postgresql
#914
click conflict on a day that is both wiki page and milestone date
#917
ping should use base url
#924
TOC Marco for trac 0.10
#935
Compute daily sums by SQL queries and eliminate data collection script
#952
Enabling 'Reply' to a blog post
#969
idealized line
#971
Account Manager Plugin - download without svn
#980
Charset Encoding and Problems
#1013
exception while exporting
#1021
default configuration should include a setting so that mylar trac connector works
#1041
charset problem
#1042
basic auth for xmlrpc
#1109
As of trac 0.11, plugins should use req.href, not env.href
#1114
The TicketPlugin doesn't work with Trac trunk.
#1116
Set permission group of new user
#1122
AttributeError in web_ui.py
#1127
Removing selected account does not update "Assign To" field on new ticket sards
#1133
Unicode error generating PDF
#1135
osx addressBook, iCal, and mail to subversion/trac scripts needed!
#1142
cannot get the plugin working with 0.10
#1149
AttributeError: 'long' object has no attribute 'astimezone'
#1159
ITicketChangeListener problem with trac 0.10.3, python 2.3
#1161
TracBlog day out of range when navigating blog
#1182
'BatchModifyModule' object has no attribute 'get_htdocs_dirs'
#1185
No get_htdocs_dirs method
#1196
Add intertrac support
#1200
Error accessing Admin interface
#1208
AddComment does not allow for characters with codes > 128
#1212
Security issue allowing to download files of the server running trac
#1238
Using mastertickets plugin with already existants tickets cause error
#1239
Using mastertickets plugin with already existants tickets cause error
#1240
Using mastertickets plugin with already existants tickets cause error
#1242
UnicodeEncodeError
#1246
[PATCH] Allow manipulation of htmldoc flags and negation of defaults from trac.ini
#1254
delete button not shown in ticket with 1.1.4 version of ticketdeleteplugin
#1263
pic2plot / Plotutils Plugin
#1266
x.png file not found
#1280
Bug in master tickets plugin when invalid ticket num is entered.
#1313
Error while trying to install Trac RPC plugin to use with Eclipse plugin
#1320
When pings are sent, a completely invalid URL is supplied resulting in a leve 400 error.
#1328
Fails to install in 0.11.x
#1329
No patch for 0.10 available?
#1347
For each wanted page list the page on which it is referenced
#1353
Crashes when encountering any file or directory that is not a project
#1358
reset_password needs to allowed
#1372
[PATCH] crashes if there are non-project directories or other files in directory containing projects
#1373
Plugin to change commit message
#1377
Support of SSL (https)
#1383
How to install?
#1392
Internal error when logging in using tracd
#1398
r2128, 0.10, crashes on login (?)
#1428
What about remembering that user was logined (into cookies)?
#1444
deleting users does not remove information from db
#1457
Automatically determine ENV_PARENT_DIR
#1459
'Fragment' object has no attribute 'replace'
#1498
TracPygmentsPlugin - dont work on 0.10.3
#1511
Attach file feature?
#1538
HideVals on QueryModule
#1539
Internal Error When Moving Trac Ticket
#1547
timeline is empty
#1548
timeline is empty
#1552
failure with trac 0.10
#1553
creation of reviews in changelog/diff view
#1559
0.11 installation fail
#1563
Allow to page to provide it's own template
#1565
reviewer list doesnt contain users
#1572
Cannot log in with users that i create with this plugin.
#1618
Email -> Ticket (Windows)
#1635
Traceback : Incoherent path [trunk] != [tags] rev: 1025
#1638
assertion on trying to look at the tree
#1640
simile timeline displays nothing
#1642
Permission groups are not recognized
#1646
Filter by Author does not work
#1657
File attachment with discussion topic
#1658
Problem with trac and ldap
#1661
RuntimeError: maximum recursion depth exceeded
#1666
Create a desktop app to record time spend on a given task and update ticket when done
#1672
Avoid pdf creation.
#1693
revtreeplugin error on 'show deleted branches'
#1702
update failed
#1704
Non-ascii acronyms
#1716
IntegrityError: duplicate key violates unique constraint "message_pkey"
#1718
'dictionary key must be string' while executing 'ticket.get()'
#1721
Pop from empty list error
#1722
Will it work with trac 0.11dev?
#1729
couldn't upgrade
#1735
'Submit Another' Ticket
#1741
Can Only get TICKET_VIEW_SELF to work
#1746
multi-select pages to be exported
#1753
CtxtnavAddPlugin support for WikiNegotiator
#1764
Search by Chinese character
#1775
Date Format for Billing Date
#1777
AuthRequiredPlugin sets wrong path
#1787
Getting assertion error after logging into master environment.
#1793
Adding comment to any file fails
#1806
'MediaWikiRenderer' object has no attribute 'render_macro'
#1809
errors are generated if blocker field is incorrectly filled in
#1810
errors are generated if blocker field is incorrectly filled in
#1811
errors are generated if blocker field is incorrectly filled in
#1812
errors are generated if blocker field is incorrectly filled in
#1813
errors are generated if blocker field is incorrectly filled in
#1814
errors are generated if blocker field is incorrectly filled in
#1833
"Disallow closing blocked tickets" functionality doesn't work
#1841
MasterTickets with 0.11
#1845
Does not work with Trac 0.11
#1848
Add separate permission for billing reports
#1849
Open tickets in the roadmap should be blue instead of a warning red
#1850
Open tickets in the roadmap should be blue instead of a warning red
#1854
Cannot add a comment on a line
#1855
Cannot add a comment to a line
#1866
How to install your BoilerPlatePlugin
#1869
Breaks TracForge dispatching
#1871
"private" ticket option which is only exposed to users with a particular permission
#1884
troubles with kyrillic fonts
#1885
troubles with kyrillic fonts
#1897
Unable to add comment to peer review
#1899
Syntax-Error when trying to execute Report via management
#1911
IE not supported?
#1921
0.11 support
#1944
Doesn't highlight unless you have a session
#1968
0.11 build doesn't work in 0.11
#2020
pygments_renderer renamed in current 0.11dev
#2031
add htpasswd2 as a method for creating new users
#2098
XMLRPC ticket update doesn't trigger notifications
#2163
Add a filter by milestone
#2178
error when renaming a page with existing link (NameError: global name 'sre' is not defined)
#2179
Timeline always starts at July 2006 instead of selected date
#2180
Patch fails with 0.10-stable rev 6059
#2193
verification for register
#2196
Permission actions needed
#2213
Couldn't find index page for 'TracWebAdmin' (maybe misspelled?)
#2233
Search Binary version controlled files
#2234
[PATCH] Fix for unicode bug
#2248
got error when trying to show any graph
#2250
[PATCH] JSON support
#2278
Add basic authentication support
#2292
ImportError: No module named LuntTrac
#2371
cannot install TracSvnAuthzPlugin with trac 0.11
#2419
Notification system for individual plug-ins
#2442
0.11b1 version problem
#2489
WYSIWYG editor makes it hard to add text below referenced material in "replies"
#2519
trac upgrade after installation of plugin
#2534
default_daysback does not work?
#2537
Can't I install stractistics plugin
#2540
bug in rare circumstances
#2545
TemplateNotFound: Template "fullblog_admin.html" not found
#2548
Error when ticket contains accents
#2638
IOError: Bad path: None
#2679
Special characters in passwords provoke an internal error
#2739
Tracwysiwyg plugin with Trac-0.11b2
#2743
Ticket activity by type
#2775
Installation error with trac 0.11b1
#2781
cannot change ticket
#2783
Support for Trac 0.11
#2798
Sending SMTP fails miserably if MTA does not support AUTH
#2800
Get preferred format SQL fails
#2813
WikiRename 1.2 does not work correctly with TracTags 0.4
#2822
tractags 0.6 api
#2827
TypeError: __init__() got an unexpected keyword argument 'req'
#2829
0.11 version
#2831
Main plugin page layout broken in Safari
#2847
ticket subscription for trac plugin updates
#2848
Support subversion authz *
#2859
AccountMangerPlugin Installation Error
#2870
Using "Delete Changes" causes an error
#2872
'ascii' codec can't decode byte 0xc4 in position 4: ordinal not in range(128)
#2900
TypeError: cannot return std::string from Unicode object on milestone select
#2954
text can not contain ',' in it.
#2962
Incorrect integer value: '' for column 'default_rate'
#2969
Encoding for MIME headers
#2974
CarbonCopySubscriber is not properly invoked on a ticket change event
#2995
Doxygen TracLinks do not work for classes in a namespace
#3016
License definition in setup.py causes "python setup.py bdist_rpm" to fail
#3024
SvnAuthzAdminPlugin on Trac 0.11b2
#3062
billing reports fail - unreachable objects found.
#3077
download form shows information of previous user
#3079
Search error: "TypeError: can't compare datetime.datetime to int"
#3091
[PATCH] Error just after installing
#3115
port the plugin for 0.11
#3141
submodule handling
#3143
All Billing Reports fail with "Report execution failed: ORDER BY column number 0 out of range - should be between 1 and 7"
#3185
Doesn't show up in web admin
#3193
CFAP doesn't allow changing order above currently set order values
#3196
Can't open depgraph
#3218
save selection somehow (like saving reports/queries is possible)
#3224
AttributeError: 'array.array' object has no attribute 'replace'
#3232
Problem with XMLRPC plugins on trac 0.11
#3271
AttributeError: 'unicode' object has no attribute 'trim'
#3279
IndexError: list index out of range
#3288
LookupError: unknown encoding: /trac_new/downloader
#3299
Bug when creating egg package (don´t copying the images)
#3304
Doesn't work for me
#3336
Don't upgrade database after worklog installation
#3338
[Patch] Changes for trac 0.11
#3348
ListTagged(...) fails with UTF-8 pagenames (not ascii) with /tags/0.6
#3349
Cannot Load Plugin
#3354
Redirect loop if account module enabled
#3362
[Patch] Unknown encoding error with TracDownloader, Trac 0.11, Py 2.5
#3368
IOError: cannot open resource
#3375
draft status
#3389
Error with batch ticket modify plugin
#3395
login is not possible via webform, only via apache conf
#3421
Not Compatible with Custom Ticket Workflow?
#3423
[patch] default value does not work
#3438
worklog 'autoreassignaccept' option leaves ticket status in 'assigned' instead of 'accepted'
#3446
tracdownloaderplugin fails on easy_install - Python 2.4
#3449
mastertickets.webui causes genshi traceback
#3454
GitPlugin fails to work, with short error
#3455
Trac breaks
#3479
ignores user privileges settings
#3483
Add ability to send email on blog post
#3496
Private Wikis show up in the Index
#3499
Line Breaks in Tickets Displayed as [[BR]]
#3506
Different workflows for different ticket types
#3508
paging doesn't work in the management reports
#3511
Update for 0.11
#3516
Page navigator with wrong URL when the result from a report has more than 100 records.
#3519
Password Reset Error
#3525
get the names from the database
#3529
Emails aren't being sent when announcer plugin is installed
#3538
Plugin works correctly for logged-in users, but anonymous user (not logged in) can access the private page
#3562
TypeError: previous_rev() takes exactly 2 arguments (3 given)
#3571
Cannot install plugin
#3575
Radio-Button WYSIWYG should be enabled by default the first time
#3585
NameError: global name 'enhancer' is not defined
#3586
NameError: global name 'enhancer' is not defined
#3587
scimming does not work
#3601
Timeline for each plugin
#3625
"System can't find the file"
#3645
It not work on 0.11.1
#3648
No Data displayed in table
#3649
UnicodeDecodeError when try deleting ticket changes
#3654
AssertionError when selecting browse source
#3663
Fail to render without graphviz option
#3682
KeyError: 'fields'
#3686
Skittlish does not work on Trac 0.11
#3687
Skittlish does not work on Trac 0.11
#3688
Skittlish does not work on Trac 0.11
#3692
A folding function does not react.
#3713
New lines in changes don't create new lines in html email
#3714
AnnouncerPlugin does not render wiki text
#3730
Queries are not type safe for PostgreSQL 8.3
#3756
Magrating to Trac 0.11 breaks GraphVisPlugin
#3820
fixes for compatibility with trac v0.11
#3835
Correct permission for ticket modify
#3837
create page does not work
#3848
Loading Failed
#3852
Back Links does not find pages that link with out the wiki: syntax
#3882
Add partial wiki page section include
#3887
Delete Changes doesn't show all changes
#3899
[Patch] SQL query failures with PostgreSQL
#3903
Bad syntax in setup.py
#3910
includemacro patch for Trac 0.12multirepos branch
#3941
How to define a custom field which is in wiki format?
#3953
I can't upload screenshots!
#3958
install in windows
#3976
list all attachments for easy searching
#3980
egg build broken - complains about htdocs/css
#3982
UnicodeDecodeError on ticket "Delete changes"
#4011
revision for wiki pages
#4033
Let Login Module disable the default Trac login module
#4063
postgres upgrade fix
#4074
autocompleteusersplugin egg-building command fails unless package_data is edited in setup.py
#4102
TracTweakUI插件不能正常使用
#4114
rendering of included html does not work
#4117
Too cumbersome to add files to review
#4129
two plugins conflict
#4130
two plugins conflict
#4138
GitPlugin doesn't handle fresh repositories well
#4140
After entering "forgot password" user redirected "in a way that will never complete
#4144
OperationalError: (1054, "Unknown column 'created' in 'where clause'")
#4155
Enabling EmailVerificationModule acct_mgr.web_ui blocks the whole installation
#4169
Strange behaviour when hours remaining are large
#4213
Wiki pages with not ASCII-names
#4216
Postgres 8.3 - broken sql statements in all statistics sections
#4231
Automatically spawn child tickets when parent ticket is created
#4235
timeline links are relative in rss
#4241
Could you list previously saved keywords
#4249
easy_install error
#4267
class=active only appended to manually added entries when SectionEditPlugin is active
#4274
CSS fix for better Trac integration
#4287
Disable WikiFormatting on commit messages
#4292
Re-assigning the TimingAndEstimationPlugin menu as submenu does not work
#4293
Fields don't hide in view or edit ticket
#4309
[PATCH] Folding group box Batch Modify Properties
#4362
Add query to find wiki pages according to vote counts
#4364
SQL for report to sort tickets based on number of votes
#4377
Trachours won't function with non-ascii chars in database fields.
#4409
bug in plugin _launch method
#4427
wiki page not created if assigned a tag
#4465
Tags in the tag cloud are not separated by spaces
#4471
StopIteration error with some repositories
#4488
Short name in HTML Title
#4493
upgrade of trac + ldapplugin does not work
#4494
[Patch] Throws an exception when used with the GitPlugin
#4540
use svn repo too
#4551
Support for draft post queues
#4561
<acct_mgr.web_ui.MessageWrapper object at 0x555556a80190>
#4564
Burndown chart is wrong after moving tickets between milestones
#4565
Creating first review fails
#4592
fullblogplugin sidebar rss link inconsistency
#4604
MessageWrapper hides its .body content
#4635
Fetch account info from LDAP if session email address not exist
#4644
Additional Producer and Formatter
#4647
gitplugin doesn't work with git 1.6
#4652
web interface missing
#4671
Disable access to /account and /settings for specific users
#4680
Infinite redirect loop after resetting the password
#4684
"It does not allow you to create a dependent ticket from the current ticket"
#4702
Port of patch for Trac 0.11 from formalin14(at)gmail(dot)com
#4715
Duplicating records for hours worked on a user in ticket_change table in postgresql
#4730
MySQL error when using Stratistics plugin for first time
#4736
Wrong URL in setup.py
#4745
Admin options don't show up
#4769
Posted zip file newsflashmacro-r5355.zip has wrong unzipped file perms
#4771
could the cloud be a popup tip-like window?
#4794
Enable web admin to declare default sorting column
#4796
Error by uploading small file
#4801
UnicodeEncodeError: 'ascii' codec can't encode characters in position
#4806
Plot the data with gnuplot
#4832
Add additional support for admistration user fields (like in permission)
#4842
post_process_request does not correctly pass content type
#4849
"NameError: global name 'sorted' is not defined" after clicking "Users"
#4913
Bold highlighting of current page
#4954
TypeError: __init__() takes at most 12 arguments (13 given)
#4961
galleryplugin
#4962
galleryplugin
#5161
Account manager password store problem
#5165
Group permissions not working
#5171
Trac Downloader plugin failed on trac 0.11
#5179
Wiki page cut off by nav bar
#5186
How to use permissions and groups
#5196
Notification by email
#5201
Missing __init___.py
#5204
Install process doesn't create tables
#5214
Dropdown menus for "Blocked" and "Blocked By"
#5219
Revtree page stops with StopIteration:
#5221
Include causes warnings
#5231
Error when create or update a ticket
#5252
renaming a wikipage looses the tags
#5254
Error al entrar al stractistics
#5257
TypeError: iterable argument required
#5283
Can't install TracDownloader on 0.11
#5303
Trac 0.11 unknown encoding error when using TracDownloaderPlugin
#5306
TracWysiwygPlugin not showing the radio button in wiki edit page after installing
#5308
Links to nonexistent tickets on Trac fail
#5317
Subscribing to other features
#5347
Tags should optionally be case insensitive
#5359
Batch modify does nothing
#5371
KeyError: u'\xe2'
#5398
feature suggestions - wiki hierarchy, wiki rename, export to docbook
#5405
Error when trying to upgrade database ("object has no attribute 'rollback'", PostgreSQL)
#5409
Graphviz looks for non-existent file 'gvcache'
#5444
anonymous user can see all private wikis
#5450
DB error when adding additonal tickets to blockedby/blocking
#5451
VotePlugin failing on trac-admin upgrade
#5477
Plugin not visible in the Menu selection
#5481
Position Change button below the Reply button and change styling to match Reply button
#5482
UnicodeDecodeError: 'ascii' codec can't decode byte 0xd0 in position 0: ordinal not in range#128#
#5483
unicode suport and multirepos suport
#5485
LDAP Plugin not working with all SSHA variants
#5522
Add an action to change/append the cc field
#5543
german umlauts (äöü) not processable
#5562
Option to specify template to automatically create page from
#5564
Add support for importing the 'time' field
#5565
Add Wiki discussions support
#5585
Notifications not working, seems like the listeners are not being registered
#5591
"IOError Bad Path:" on Windows
#5601
fails create the testmanagment tab
#5602
fails create the testmanagment tab
#5610
Drop down list should show individual keywords and/or tags
#5619
Feature Request: Save draft and/or hide blog posting
#5625
Changes should be appear in timeline
#5654
Preview and commit will not work if there have Chinese character in wiki pages
#5668
MYPAGE_VIEW permission does not exist
#5683
preserve_newlines setting does not work for the preview
#5706
[Patch] Remove obsolete jQuery syntax
#5722
AuthSVN
#5728
Missing submodules support
#5732
Infinite URL redirection when logging in after resetting password
#5734
Display a list of all broken wiki links
#5766
trying to edit a comment with {....} formatting doesn't work consistently
#5781
Ticket filed issue
#5788
[Patch] AttributeError of tag query for ticket
#5792
HidevalsPlugin for trac 0.11.5rc1
#5804
AutoCompleteUsers + AccountManager + LdapAuthStore
#5805
Math plugin for Trac Wiki
#5821
not working - "No module named _bibtex"
#5830
add possibility to 'hide' configuration in adminpage
#5834
Sorting by hours works incorrectly
#5846
Find broken links
#5847
It doesn't sync when remote URL is https and password protected
#5862
Breaks XML-RPC plugins
#5887
Ticket stats failing to start
#5893
SQL query failures with MySQL
#5910
Error with entries without author in timeline
#5911
Announcer breaks AccountManager Plugin
#5937
Not working with tracd & http11
#5974
"plugin" style addition
#5987
Unicode error if tag points to wiki page with non-ascii name
#5992
Is there an account confirmation feature?
#6015
forgot password is not working
#6031
control_field for trac 0.10.4
#6154
Date Picker Missing
#6155
TicketDelete conflicts with DateField
#6156
Tag h1 bad close in ReportScreenFilter
#6180
Downloader: SQL errors when accessing stats pages (and stats admin pages)
#6182
unable to export static image in pdf (dynamic image works)
#6184
ProgrammingError: Cannot operate on a closed cursor.
#6188
Ticket numbers are not showing as links
#6191
Hours tab not present
#6205
plugin busted - don't use
#6208
Error when using the theme
#6218
Genshi UnicodeDecodeError error while rendering template 'ticketdelete_admin.html', line 51, char 135
#6253
Drop downs for TT and table does not work
#6265
Add Path with empty field leads to invalid configuration
#6274
UnicodeDecodeError on UTF-8 encoded filenames
#6275
I have not appeared button change after install plugin
#6278
improper handling of groups
#6289
This plugin breaks AutocompleteUsersPlugin and LoomingCloudsPlugin functionality on create new ticket page
#6302
The timeline returns "Program Error: closed cursor" with Trac 0.11.6
#6320
trac-admin get error message so can't go on
#6329
Login with SessionStore not working after upgrade to Trac 0.11.6
#6333
[Patch] Add Trac 0.12 compatible version
#6347
BlogList macro should count characters in rendered text, not source text
#6361
Weakly-referenced object no longer exists
#6378
[patch] Cannot view tickets with MasterTickets plugin installed when using postgres
#6384
Small patch to also include a listing of the tickets that refer to the specified ticket from either description or comment
#6400
Plugin forces to submit changes on wiki pages twice
#6421
[PATCH] Postgres: Saving changes to tickets blocking/blockedby violates an integrity constraint.
#6438
OSX dot execution failed
#6464
[Patch] pwhash does not work with trac 0.11.6
#6499
SyntaxError in easy_install
#6505
[Patch] TracMetrix plugin encounters internal error "TypeError: milestone_stats_data() takes at least 4 arguments (3 given)"
#6510
Request for Trac import plugin in Python2.6
#6556
Create setup.py for installing as an egg
#6557
Plugin implementing a 'Report Spam' link
#6600
Allow the WorkFlowEditor to use the AdvancedTicketWorkflowPlugin
#6602
plugin doesn't handle absence of 'watchlist_version' from database
#6609
Declared features are not available.
#6611
Does not recognize [wiky:"link" description]
#6712
Section edit for numbered headlines
#6733
doesn't work with wysiwyg plugin
#6736
Google Chrome bug
#6769
setup.py puts README and COPYING in the wrong place
#6770
setup.py puts README and COPYING in the wrong place
#6772
Batch modify disabled even for members of TICKET_BATCH_MODIFY
#6782
i want use tag in discussion
#6794
Traceback in apache error_log : "TypeError: issubclass() arg 1 must be a class"
#6800
Add ability to set a field to the result of a given SQL query
#6817
"forgot password" does not send mail
#6819
Ticket Import plugin doesn't work.
#6822
Re-design ugly HTML login form
#6825
html_output is mandatory in trac.ini
#6859
[patch] Fixing broken ticket diff viewing
#6883
Email to discussion
#6897
problem with get_navigation_items in web_ui.py
#6898
problem with get_navigation_items in web_ui.py
#6906
Ticket descriptions with quotes not displayed properly when hover over depgraph nodes
#6908
[patch] Tagged pages with names containing non-ASCII chars break listing for their tags
#6914
TypeError: milestone_stats_data() takes at least 4 arguments (3 given)
#6921
Request ability to set a field as part of workflow
#6938
Problem while hosting tracgit plugin in trac
#6939
Problem while hosting tracgit plugin in trac
#6944
Checkbox column doesn't show up
#6946
The section 3 that you chose could not find.
#6947
Error on create ticket after implement PrivateTicketsPlugin (TracHoursPlugin installed)
#6951
Error is displayed when clicking the dashboard after installing TracMetrixPlugin
#6966
PDF creation does not work if image macro has no absolute links in it
#6982
Support rendering file from repository
#6991
Ticket import plugin for Python 2.6
#6998
CSV export crash + fix
#7002
A few speed improvments
#7013
r7731 breaks password reset notification
#7020
[Patch] Install leads to Error line 79
#7042
Crash on dev version of Trac
#7047
Doesn't work with mulirepository in trac 0.12
#7062
Test 0.12 branch with multi-repos
#7063
AttributeError: 'TracError' object has no attribute 'acctmgr'
#7075
Short SHA1 checksum as commit reference
#7081
encoding problem
#7088
Segmentation Fault on Ubuntu 64 Bit under Apache Control
#7134
Problems with trac 0.11 and BatchModifyPlugin on ubuntu 9.10
#7138
ProgrammingError: Cannot operate on a closed cursor.
#7147
AttributeError: 'TracError' object has no attribute 'acctmgr' - raised when registering new account
#7196
Enable use of diagrams stored in svn repository
#7199
Get a "You're using a plugin which requires the Clearsilver template engine and Clearsilver is not installed." when using WikiToPdf
#7200
Don't redirect resources (like css) to the login page
#7234
Filter for Visible Tickets on Calendar
#7243
Display 'Browse Source' author as name, rather than email username?
#7254
AttributeError: 'TracError' object has no attribute 'acctmgr' - when creating new user in web admin UI
#7261
include plugin external site authentication
#7284
updating tickets with xmlrpc in the name of a different user
#7299
[Patch] Can't install plugin (Trac 0.12)
#7307
Comment diffs do not work in Trac 0.12 with MasterTicketsPlugin enabled
#7321
Python 2.6 & import sha depreciated
#7335
AttributeError: 'SimpleContainer' object has no attribute 'build' - When I try access a RevTreeView with MergeEnhancer
#7352
repository statistics are blank since migration to 0.12
#7395
[patch] Allow md5 hashed passwords for htpasswd file
#7401
HtPasswdStore mode: update to passwd file changes files group
#7435
Doesn't Show Up in Plugins
#7438
ClientsPlugin
#7489
SyntaxError: 'return' outside function
#7502
[Patch] Totalhours fields for milestones display incorrect value
#7504
'Cannot operate on a closed cursor' exception causes db to appear as if upgrade is needed
#7507
Implement security permissions
#7513
reformatting misses edited ticket comments
#7525
If tags AND content of wiki page are changed, content changes are lost
#7555
AnnouncerPlugin keeps sending mails with always_notify_* disabled completely
#7575
Supplying username allows \r in name
#7597
[Patch] "Environment not found" when clicking on the vote icon of an issue with comments
#7619
cannot add comment to newly created tickets (ValueError: need more than 1 value to unpack)
#7627
UnicodeEncodeError: 'ascii' codec can't encode characters in position 0-6: ordinal not in range(128)
#7678
theme crashes trac. 'has no member named "theme_info"'
#7680
[PATCH] Invalid links when trac is on accessed from top-most path
#7684
SVN and/or zip file is empty
#7696
use wiki formatting on colored text
#7702
Switch from deprecated `sha` module to modern `hashlib` [patch]
#7706
ticket.query does not return more than 100 elements
#7708
Anchor name treated as "wanted link"
#7711
Password retries number
#7724
Display the tickets' summaries in search results
#7725
Display the tickets' summaries in search results
#7739
[patch] Support for l10n
#7743
Error "No handler matched request to /mdashboard/<milestone>" on milestone links
#7760
Update Bitten Announcer for new system
#7771
[PATCH] add_keyword operation
#7799
Add file name of the readme above the contents - github style
#7815
DateField-1.0.1 doesn't MODIFY customfield in TracCustomFieldAdmin-0.2.5
#7827
Editing of last heading and saving, will duplicate last line in that heading
#7828
AttributeError: 'XmppPreferencePanel' object has no attribute 'xmpp_format_setting'
#7833
Deleting a ticket generates error in subscribers.py
#7858
defect in ticket status checking in updating burndown table in DB
#7882
MissingSectionHeaderError: File contains no section headers. file: C:\passwd, line: 1 'pjyang::37af6f35659301a97fd1ef8f944f34de\n'
#7960
Trac 0.12.1: Warning: Error with navigation contributor "AuthRequired"
#7984
Traceback while synchronizing the ticket references from Mercurial changesets
#8035
Component for commit_updater
#8050
Add ability to delete a Test Plan
#8065
Database schema is incorrect or casts are needed (PostgreSQL 8.4 database)
#8073
total number of tickets in a report not visible
#8122
Hours in mainnav appear when logged out
#8184
[Patch] Milestone not start with TypeError
#8231
Integration with DiscussionPlugin
#8290
Graph only shows 0 values for all three series
#8311
Set default master ticket fields to pass to new child ticket
#8318
Tag cloud does not contain spaces when using IE8.
#8338
AttributeError: 'AccountChangeNotification' object has no attribute 'smtp_server'
#8340
UnicodeDecodeError: 'utf8' codec can't decode bytes in position 28-30: invalid data
#8347
No way to limit access to Hours for anonymous users
#8368
Conflict with TimingAndEstimation Plugin
#8369
InternalError with enabled SubversionLink options
#8390
SQL error when using PostgreSQL viewing /hours where no tickets exist
#8393
Tried to use trac 0.12 with gitplugin failes cause of a Oops: read_commit called with empty commit_id
#8395
Trac 0.12
#8402
Can not delete changes for trac version 0.12.1
#8408
'NoneType' object has no attribute 'keys'
#8422
Password file store conflicts with svn password file rule
#8448
topic realm links with #anchors
#8450
Upgrade Error question?
#8459
error under Japanese environment
#8460
Ability to inherit parent component
#8463
automatic notification after import
#8467
Show tags not only on EDIT page
#8475
Problems on trac 0.12?
#8480
Error: "KeyError: 'id'"
#8481
Error: "KeyError: 'id'"
#8483
Repository Statistics don't work!
#8490
AttributeError: 'TracError' object has no attribute 'acctmgr'
#8519
Trac GitPlugin Error
#8520
hours query csv export encoding error
#8559
wiki page location as top menu
#8591
NavAdd active state
#8648
Ticket without cc field makes notification failed
#8649
Ticket without cc field makes notification failed
#8660
WinXP HtDigestStore disables AccountModule because the password store does not support writing
#8670
implement IWikiChangeListener.wiki_page_renamed
#8686
HTTPError 414 Request-URI Too Large
#8710
Admin option to add user email address
#8713
Downloader plugin couldn't be enabled
#8716
TracWysiwyg-0.12.0.3_r9676 , breaks in combination with some other plugins
#8729
Compilation fails on python 2.4 with Syntax Error
#8734
Impossible insert blank line after Code block or Quote block
#8736
AttributeError: 'TracError' object has no attribute 'acctmgr'
#8742
SyntaxError: invalid syntax (core.py, line 205)
#8743
Inconsistencies in milestone date format
#8757
Working with TracTicketChangesets
#8803
TracDiscussion no longer works with Python2.4
#8820
Search fails with: AttributeError: 'NoneType' object has no attribute 'get_node'
#8821
FlexibleReporterNotifcationPlugin not working
#8828
Creating a Forum with empty tags causes breakage
#8859
[Patch] ERROR: Macro TracJSGanttChart(milestone=...) failed
#8877
menu item links fail on trac installations in the root of the server.
#8891
no result in wiki activity
#8904
Encoding error when using Chinese tags
#8915
AttributeError: hdf
#8928
Registering new User fails
#8938
[PATCH] Replace Sha module with Hashlib
#8949
AttributeError: 'NoneType' object has no attribute 'youngest_rev'
#8953
Absolute href are broken if trac is installed in root path
#8970
audocomplete fails to function under Trac 0.12
#8972
include anchor
#8974
Size calculation extracted from SVG goes wrong
#8975
TracImageSVG does not work with port forwarding (ssh)
#9002
After login, user is redirected to project home page, not to viewed page
#9022
[PATCH] remove superflous error message about wiki_namespace
#9031
[PATCH] suppress ticket notification when only status changed
#9032
AttributeError: 'AccountChangeNotification' object has no attribute 'smtp_server'
#9036
TracDiscussion 0.8-r9877 does not work wih TracSpamFilter 0.4.7dev-r10756
#9056
TagsPlugin: Renamed tagged pages are not handled correctly
#9068
ProgrammingError: (1064, "Fehler in der SQL-Syntax. Bitte die korrekte Syntax im Handbuch nachschlagen bei 'c WHERE c.id > 0 ORDER BY c.timestamp LIMIT 30 OFFSET 0' in Zeile 1")
#9078
Login: "Invalid username or password" , trac 0.12
#9083
missing burndown chart
#9146
Cannot install the plugin in Trac-0.11.8dev_r10236-py2.4
#9154
ticket deletion error
#9190
TracListTicketsScript + mod_wsgi
#9197
it doesn't work with python 2.4.x
#9201
A Trac plugin for export of wiki pages/tickets to xml file
#9222
cannot enable all components
#9247
Cast authenticated values to int
#9251
[PATCH] del_field operation
#9255
patch to add colors, and manage special chars
#9257
installation with python 2.4
#9296
Please, consider following patch for Trac 0.12
#9410
Doesn't work with 0.12
#9514
Error: Macro TracJSGanttChart(sample=1) failed
#9525
Display milestone in ticket summary
#9528
KeyError: 'id'
#9534
Overriding explicit start dates
#9548
AttributeError: 'unicode' object has no attribute 'base'
#9550
Add the ability to fetch a bunch of tickets in one go
#9575
WorkflowPlugin breaks when no Accept-Language header is sent
#9583
Specific Date dont work
#9611
Problem with datefield plugin
#9617
In-Reply-To and References Message-IDs should be set to the ID of the "Ticket-Creation" email
#9619
IOError: (22, "invalid mode ('r') or filename")
#9620
Error upon calling /register on recaptchaplugin
#9634
Error on database upgrade
#9658
WindowsError: (5, 'Access is denied')
#9682
AttributeError: 'Ticket' object has no attribute 'is_writeable_field' when using with Agilo plugin
#9685
AttributeError: 'Ticket' object has no attribute 'is_writeable_field' when using with Agilo plugin
#9686
Incompatibility with 0.12 or higher
#9689
'NoneType' object has no attribute 'get_node'
#9694
What does this message mean "Right in place edit start failed."?
#9706
WYSIWYG plugin not working
#9755
Populate user preferences with name and email
#9788
base_path is not prefixed to links on the /bookmark page
#9848
Enhancement the plugin with trac groups
#9863
Storing book's structure
#9876
AttributeError: 'Ticket' object has no attribute '_get_db_for_write'
#9878
Env upgrade after activation failed
#9885
Right/left/center justify table cells
#9951
[patch] set type
#9960
UnicodeDecodeError: 'utf8' codec can't decode byte 0xfc in position 20: invalid start byte
#9967
IOError: [Errno 2] No such file or directory: ''
#10002
Allow accounts to be manually locked
#10042
Compatibility with Trac v0.12
#10051
Exception logging in XML-RPC and JSON-RPC is different
#10097
Seems to break KeywordSuggestPlugin
#10098
GitPlugin TypeError: 'NoneType' object is unsubscriptable
#10099
WindowsError: (5, 'Access is denied')
#10102
Question concerning "base_dir" parameter
#10125
UnboundLocalError: local variable 'data' referenced before assignment
#10146
Setting category via custom field, not title
#10191
integer = boolean
#10199
Add flash captcha to ticket add and update screen
#10200
Add flash captcha to ticket add and update screen
#10201
Add flash captcha to ticket add and update screen
#10207
Cannot update a ticket while changing child ticket to parent ticket (and vice versa) with a 'comment'.
#10215
After user registration, no email verification happens
#10230
`trac-admin ... upgrade` boken on trac v1.0
#10243
Bad file modes
#10247
failed to build EGG on OS X Mountain Lion
#10254
Internal error on 0.11.7
#10256
Support alternative syntax
#10262
Big, red Delete button in 0.11.6
#10273
Add tags to a PageTemplate
#10290
STractistics Plugin is not displayed in the menu bar
#10294
New install impossible on Trac 1.0beta1
#10296
Duplicate tickets when submitting with attachment
#10301
$("script[src~='gridmod']").attr("src") is undefined
#10320
Deleted repos break search
#10368
V0.6 not working on Trac1.0
#10369
TypeError: 'NoneType' object has no attribute '__getitem__'
#10406
Password reset sends out a new password even if the operation fails
#10415
exclude pages from the ListTagged
#10417
XML RPC to fix incompatible autocompletion plugins
#10429
Error of Macro UserProfilesList
#10457
Add operator for set_version, set_milestone
#10491
error on trac 1.0
#10514
error produced by module simplemultiproject.admin_component.smpcomponentadminpanel trac 0.11.7
#10566
Zombie test catalogs in template management page
#10612
WikiLinks using square brackets fails in certain cases
#10652
ProgrammingError: (1146, "Table 'trac_contacts.tags' doesn't exist")
#10713
DirectoryAuthPlugin: can't set dir_scope parameter in trac.ini
#10720
ProgrammingError: operator does not exist: text = integerLINE 1: SELECT * FROM attachment WHERE id=148 ^HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts.
#10724
[PATCH] render inner macros inside the SQLTable macro
#10776
UnicodeDecodeError: 'utf8' codec can't decode byte 0xd6 in position 39: invalid continuation byte
#10779
"forgot your password" no more working on 0.4.2
#10791
fresh install in 0.12.1 fails
#10799
Error when theme is not defined
#10816
sort by alpha option
#10819
Option to exclude Trac documentation
#10822
Peer Review Plug-in Not Working
#10836
"AttributeError: hdf" when trying to access wikitopdf admin panel
#10840
Wrong file permissions in zip package
#10842
Theme change
#10848
Encode data as utf-8 during csv export
#10886
TypeError: unsupported operand type(s) for +: 'NoneType' and 'NoneType'
#10891
OperationalError: near "13": syntax error
#10906
Internal error 500 after attaching file
#10928
trac keep reload itself for each page refresh, after account manager plugin is enabled
#10938
AttributeError: hdf
#10939
Add link in ctxtnav that goes back to previously viewed hack
#10955
Error using advanced query expressions
#10961
Selecting to diff any part of a ticket with changes causes a Trac internal error
#10986
Please upgrade track-hacks.org to 1.0
#11020
How to only notify on ticket creation
#11029
Fails to load in trac 1.0.1
#11051
KeyError: 'ticket-workflow'
#11057
FootNote list isn't displayed when footnote is inside a table
#11060
AnnouncerPlugin doesn't honor always_cc and always_bcc
#11076
I don't see ScrumBurnDown tab on Admin Page.
#11078
Images not available after upload
#11087
picture instead of black screen
#11097
KeyError: 'ticket-workflow'
#11100
static link not working
#11105
OperationalError: near ",": syntax error
#11140
KeyError: 'id' - Error in running report with input arguments
#11178
Notification on new created tickets only
#11181
Show milestones without version on roadmap
#11191
Use plugin's own permissions instead of WIKI_* for TagsPlugin integration
#11210
Trac 1.0 Support
#11227
UnicodeEncodeError with accented characters
#11276
creole links partially supported
#11298
ProgrammingError: relation "tags" does not existLINE 1: SELECT tag FROM tags WHERE tagspace='wiki' AND name='WikiSta... ^
#11301
autocomplete
#11306
[Patch] make sure scope is passed as an int
#11325
AttributeError in installation
#11326
Add links from diagrams
#11337
Draft displays hidden fields with incorrect values.
#11354
UnicodeEncodeError on wiki and ticket notifications containing non-ascii codes
#11359
Plugin works on ClearSilver, Trac now uses Genshi
#11399
Can I set properties in TRAC UI?
#11420
TypeError: 'NoneType' object is unsubscriptable
#11428
Email not sending
#11432
email.utils does not exist in Python 2.4
#11447
ProgrammingError: (1064, "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '== 'status' \n ORDER BY tc.time' at line 4")
#11456
ProgrammingError: relation "codereviews" does not existСТРОКА 1: ...iew, Author, Status, DateCreate, Name, Notes FROM CodeReview... ^
#11504
RevTree version Conflict error for Trac 1.0.1
#11505
RevTree version Conflict error for Trac 1.0.1
#11517
TagModelProvider breaks trac-admin
#11526
AttributeError: 'NoneType' object has no attribute 'youngest_rev'
#11547
Install issue
#11559
Resolver to fetch email addresses from LDAP
#11577
Cannot show Depgraph
#11578
Cannot show Depgraph
#11583
Submit Review causes error
#11631
src_attachment_dir is different from real location
#11636
can't import time, changetime
#11653
Fails: Environment object has no attribute get_db_ctx
#11663
Some tables fail to copy in switch from MySQL to PostgreSQL
#11670
MySQL to PostgreSQL migration fails with worklog usermanual
#11680
Disable emails when submitting hour entries
#11685
TypeError: 'NoneType' object is not iterable
#11701
WindowsError: (5, 'Access is denied')
#11738
IndexError: pop from empty list
#11756
IOError: [Errno 2] No such file or directory: ''
#11819
Adding path containing umlaut gives trac internal error
#11884
Error output barely readable
#11890
Change background color
#11933
IntegrityError
#11936
ldap lookup using username
#11940
Plugin does not load in Trac 1.0
#11957
Fix for using timeline and discussion forum reply/quote with Trac 1.0.1
#11964
Only "task" tickets are returned by ticket.query

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 allows displaying the link and description of a single ticket:

[[TicketQuery(id=123)]]

This is displayed as:

#123
Use tags plugin API for handling gallery tags

A more compact representation without the ticket summaries is also available:

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

This is displayed as:

#17, #30, #31, #32, #33, #34, #39, #51, #54, #68, #77, #88, #108, #145, #152, #156, #157, #203, #208, #236, #253, #257, #262, #285, #288, #311, #330, #331, #349, #352, #374, #378, #405, #406, #437, #439, #443, #449, #454, #479, #493, #504, #531, #535, #540, #543, #548, #562, #603, #616, #639, #641, #645, #653, #676, #691, #695, #717, #719, #721, #730, #773, #782, #783, #793, #800, #812, #826, #856, #873, #884, #911, #914, #917, #924, #935, #952, #969, #971, #980, #1013, #1021, #1041, #1042, #1109, #1114, #1116, #1122, #1127, #1133, #1135, #1142, #1149, #1159, #1161, #1182, #1185, #1196, #1200, #1208, #1212, #1238, #1239, #1240, #1242, #1246, #1254, #1263, #1266, #1280, #1313, #1320, #1328, #1329, #1347, #1353, #1358, #1372, #1373, #1377, #1383, #1392, #1398, #1428, #1444, #1457, #1459, #1498, #1511, #1538, #1539, #1547, #1548, #1552, #1553, #1559, #1563, #1565, #1572, #1618, #1635, #1638, #1640, #1642, #1646, #1657, #1658, #1661, #1666, #1672, #1693, #1702, #1704, #1716, #1718, #1721, #1722, #1729, #1735, #1741, #1746, #1753, #1764, #1775, #1777, #1787, #1793, #1806, #1809, #1810, #1811, #1812, #1813, #1814, #1833, #1841, #1845, #1848, #1849, #1850, #1854, #1855, #1866, #1869, #1871, #1884, #1885, #1897, #1899, #1911, #1921, #1944, #1968, #2020, #2031, #2098, #2163, #2178, #2179, #2180, #2193, #2196, #2213, #2233, #2234, #2248, #2250, #2278, #2292, #2371, #2419, #2442, #2489, #2519, #2534, #2537, #2540, #2545, #2548, #2638, #2679, #2739, #2743, #2775, #2781, #2783, #2798, #2800, #2813, #2822, #2827, #2829, #2831, #2847, #2848, #2859, #2870, #2872, #2900, #2954, #2962, #2969, #2974, #2995, #3016, #3024, #3062, #3077, #3079, #3091, #3115, #3141, #3143, #3185, #3193, #3196, #3218, #3224, #3232, #3271, #3279, #3288, #3299, #3304, #3336, #3338, #3348, #3349, #3354, #3362, #3368, #3375, #3389, #3395, #3421, #3423, #3438, #3446, #3449, #3454, #3455, #3479, #3483, #3496, #3499, #3506, #3508, #3511, #3516, #3519, #3525, #3529, #3538, #3562, #3571, #3575, #3585, #3586, #3587, #3601, #3625, #3645, #3648, #3649, #3654, #3663, #3682, #3686, #3687, #3688, #3692, #3713, #3714, #3730, #3756, #3820, #3835, #3837, #3848, #3852, #3882, #3887, #3899, #3903, #3910, #3941, #3953, #3958, #3976, #3980, #3982, #4011, #4033, #4063, #4074, #4102, #4114, #4117, #4129, #4130, #4138, #4140, #4144, #4155, #4169, #4213, #4216, #4231, #4235, #4241, #4249, #4267, #4274, #4287, #4292, #4293, #4309, #4362, #4364, #4377, #4409, #4427, #4465, #4471, #4488, #4493, #4494, #4540, #4551, #4561, #4564, #4565, #4592, #4604, #4635, #4644, #4647, #4652, #4671, #4680, #4684, #4702, #4715, #4730, #4736, #4745, #4769, #4771, #4794, #4796, #4801, #4806, #4832, #4842, #4849, #4913, #4954, #4961, #4962, #5161, #5165, #5171, #5179, #5186, #5196, #5201, #5204, #5214, #5219, #5221, #5231, #5252, #5254, #5257, #5283, #5303, #5306, #5308, #5317, #5347, #5359, #5371, #5398, #5405, #5409, #5444, #5450, #5451, #5477, #5481, #5482, #5483, #5485, #5522, #5543, #5562, #5564, #5565, #5585, #5591, #5601, #5602, #5610, #5619, #5625, #5654, #5668, #5683, #5706, #5722, #5728, #5732, #5734, #5766, #5781, #5788, #5792, #5804, #5805, #5821, #5830, #5834, #5846, #5847, #5862, #5887, #5893, #5910, #5911, #5937, #5974, #5987, #5992, #6015, #6031, #6154, #6155, #6156, #6180, #6182, #6184, #6188, #6191, #6205, #6208, #6218, #6253, #6265, #6274, #6275, #6278, #6289, #6302, #6320, #6329, #6333, #6347, #6361, #6378, #6384, #6400, #6421, #6438, #6464, #6499, #6505, #6510, #6556, #6557, #6600, #6602, #6609, #6611, #6712, #6733, #6736, #6769, #6770, #6772, #6782, #6794, #6800, #6817, #6819, #6822, #6825, #6859, #6883, #6897, #6898, #6906, #6908, #6914, #6921, #6938, #6939, #6944, #6946, #6947, #6951, #6966, #6982, #6991, #6998, #7002, #7013, #7020, #7042, #7047, #7062, #7063, #7075, #7081, #7088, #7134, #7138, #7147, #7196, #7199, #7200, #7234, #7243, #7254, #7261, #7284, #7299, #7307, #7321, #7335, #7352, #7395, #7401, #7435, #7438, #7489, #7502, #7504, #7507, #7513, #7525, #7555, #7575, #7597, #7619, #7627, #7678, #7680, #7684, #7696, #7702, #7706, #7708, #7711, #7724, #7725, #7739, #7743, #7760, #7771, #7799, #7815, #7827, #7828, #7833, #7858, #7882, #7960, #7984, #8035, #8050, #8065, #8073, #8122, #8184, #8231, #8290, #8311, #8318, #8338, #8340, #8347, #8368, #8369, #8390, #8393, #8395, #8402, #8408, #8422, #8448, #8450, #8459, #8460, #8463, #8467, #8475, #8480, #8481, #8483, #8490, #8519, #8520, #8559, #8591, #8648, #8649, #8660, #8670, #8686, #8710, #8713, #8716, #8729, #8734, #8736, #8742, #8743, #8757, #8803, #8820, #8821, #8828, #8859, #8877, #8891, #8904, #8915, #8928, #8938, #8949, #8953, #8970, #8972, #8974, #8975, #9002, #9022, #9031, #9032, #9036, #9056, #9068, #9078, #9083, #9146, #9154, #9190, #9197, #9201, #9222, #9247, #9251, #9255, #9257, #9296, #9410, #9514, #9525, #9528, #9534, #9548, #9550, #9575, #9583, #9611, #9617, #9619, #9620, #9634, #9658, #9682, #9685, #9686, #9689, #9694, #9706, #9755, #9788, #9848, #9863, #9876, #9878, #9885, #9951, #9960, #9967, #10002, #10042, #10051, #10097, #10098, #10099, #10102, #10125, #10146, #10191, #10199, #10200, #10201, #10207, #10215, #10230, #10243, #10247, #10254, #10256, #10262, #10273, #10290, #10294, #10296, #10301, #10320, #10368, #10369, #10406, #10415, #10417, #10429, #10457, #10491, #10514, #10566, #10612, #10652, #10713, #10720, #10724, #10776, #10779, #10791, #10799, #10816, #10819, #10822, #10836, #10840, #10842, #10848, #10886, #10891, #10906, #10928, #10938, #10939, #10955, #10961, #10986, #11020, #11029, #11051, #11057, #11060, #11076, #11078, #11087, #11097, #11100, #11105, #11140, #11178, #11181, #11191, #11210, #11227, #11276, #11298, #11301, #11306, #11325, #11326, #11337, #11354, #11359, #11399, #11420, #11428, #11432, #11447, #11456, #11504, #11505, #11517, #11526, #11547, #11559, #11577, #11578, #11583, #11631, #11636, #11653, #11663, #11670, #11680, #11685, #11701, #11738, #11756, #11819, #11884, #11890, #11933, #11936, #11940, #11957, #11964

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:

847

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 7383)

1 2 3 4 5 6 7 8 9 10 11
Ticket Resolution Summary Owner Reporter
#11964 duplicate Only "task" tickets are returned by ticket.query osimons Tim Groves <groves@…>
#11963 wontfix Provide user name decoration to email notification jun66j5 david.li@…
#11959 cantfix Installation aborts rjollos soenke@…
1 2 3 4 5 6 7 8 9 10 11

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 7383)

1 2 3 4 5 6 7 8 9 10 11
Ticket Resolution Summary Owner Reporter
#11964 duplicate Only "task" tickets are returned by ticket.query osimons Tim Groves <groves@…>
Description

Trac v1.0.1

Method ticket.query is only returning tickets of type task, regardless of the query. Even if I only send {"method":"ticket.query","params":["max=0"]}, only tasks are returned.

#11963 wontfix Provide user name decoration to email notification jun66j5 david.li@…
Description

Provide user name decoration to email notification

#11959 cantfix Installation aborts rjollos soenke@…
Description

Following the instruction on http://forum.qnapclub.de/viewtopic.php?f=80&t=6649&p=167066&hilit=trac#p167066

the idea was to install the masterticketspluign.

Unfortunately the easy_install procedure aborts with the attached picture error stack.

Actual system is a TS410 with Firmware 4.1.0 Build 20140612

and installation of trac like ipkg install python26 py26-trac py26-genshi py26-setuptools svn-py

1 2 3 4 5 6 7 8 9 10 11

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