Edgewall Software
Modify

Opened 17 years ago

Closed 14 years ago

#4721 closed defect (fixed)

ticketquery seems not to respect sort of custom fields ...

Reported by: ThurnerRupert Owned by: Matthew Good
Priority: normal Milestone: 0.11.6
Component: report system Version: 0.11.3
Severity: normal Keywords: query macro
Cc: macke@… Branch:
Release Notes:
API Changes:
Internal Changes:

Description

[[TicketQuery(status=closed&keywords=~swanxp&order=myfield)]]

produces an ouput which is not ordered accordingly.

Attachments (0)

Change History (12)

comment:1 by anonymous, 17 years ago

Version: 0.10.3

comment:2 by Christian Boos, 17 years ago

Keywords: query macro added
Milestone: 0.11

Trying out here:

 [[TicketQuery(status=closed&keywords=~genshi&order=priority)]]

#3836
Author value in RSS feed is not compliant with RSS 2.0 specs.
#3847
No more Next Ticket/Previous Ticket from Query
#3848
"active" item in mainnav: not there with Genshi?
#3849
webadmin-genshi needs titles
#3925
whitespace not preserved in `{{{ }}}` blocks
#4249
Error reporting fails for some Genshi syntax errors
#4272
Available Reports page always asks if I want to delete "this report"
#4337
Document Genshi version required for r4399 to work
#4454
Trac 0.11 and Apache trouble
#4558
Import genshi.core.Attrs from genshi.core, not just genshi
#4647
Cannot view changesets
#4777
r4782 breaks ticket query page with stable Genshi (0.3.6)
#5099
Remaining issues with Genshi post-509
#5603
Allow macros to return Genshi streams
#5931
[PATCH] compliance with Genshi's strict mode
#5932
TypeError: expecting datetime, int, long, float, or None; got <class 'genshi.template.eval.Undefined'>
#6374
get rid of macros.html in favor of xi:include'd snippets
#6835
XHTML served as text/html, causes rendering problems
#7154
Link to custom stylesheet removes IE pre-7 hacks
#7401
Please lower Genshi requirement to 0.4.4
#7684
Render error on error pages and wiki edits
#7816
UnboundLocalError: local variable 'data' referenced before assignment
#7842
[patch] Allow manage genshi.max_cache_size from ini file
#7959
UnicodeDecodeError: 'ascii' codec can't decode byte 0xe8 in position 4: ordinal not in range(128)
#8286
MacroList macro broken
#8365
Trac trunk requiring Genshi "0.6dev_r960" but only "0.6dev_r0" available
#8513
Genshi template syntax in ticket_subject_template
#8595
Add IDs to the labels in the ticket modification form
#8770
site.html template is not applied to wiki formatted content
#9056
Refactor trac.mimeview.pygments.GenshiHtmlFormatter for clarity.
#9165
Render Wiki Content to Genshi Markup Stream
#9197
trac search pops internal error: "KeyError: u'Path'" when language = zh_CN
#9240
Genshi>=0.6dev-r1072 as dependency of Trac 0.12dev not found
#9294
Trac 0.11.7 incompatibility with Genshi 0.6
#10126
TracError: Genshi UnicodeEncodeError error while rendering template (fresh Trac install)
#10438
Please fix documentation about the variables available to customize templates
#10569
checking catalog utility which supports genshi markups
#10635
Custom Query / Reports are very slow
#10879
Trac becomes very slow with many (>50) milestones
#10892
TypeError: 'NoneType' object is not iterable --- enumerating late links (layout.html)
#11184
IndexError: pop from empty list when trying to add attachment
#11218
Genshi UnicodeEncodeError after entering comment containing a hyperlink sourrounded by brackets
#11261
Genshi UnicodeEncodeError error while rendering template (unknown template location)
#11780
UnicodeError with its traceback should be logged while rendering genshi template
#12677
glitch in ITemplateStreamFilter backward compatibility support
#12866
String isn't extraced from _("...") in py:with attribute
#13046
ParseError: duplicate attribute: line 281, column 33 - when rendering simple report
#13122
trac.util.tests.html.TracHTMLSanitizerLegacyGenshiTestCase: TypeError: decode() argument 1 must be string, not None
#13253
UnicodeEncodeError raised while rendering timeline rss when author of event is unknown and unicode

vs.

query:status=closed&keywords=~genshi&order=priority

Indeed.

comment:3 by Christian Boos, 17 years ago

Milestone: 0.11
Resolution: worksforme
Status: newclosed

… but it does work as expected for 0.11dev.

comment:4 by ThurnerRupert, 17 years ago

Milestone: 0.11
Resolution: worksforme
Status: closedreopened

comment:5 by ThurnerRupert, 17 years ago

Resolution: fixed
Status: reopenedclosed

allow me to set it to fixed, then it shows up as not working in 0.10.3 and as working in 0.11 pls.

comment:6 by Christian Boos, 17 years ago

well, all what's left to do is to find the corresponding changeset then ;)

comment:7 by Christian Boos, 17 years ago

Probably fixed by r4349.

comment:8 by Marcus Lindblom <macke@…>, 14 years ago

Cc: macke@… added
Resolution: fixed
Status: closedreopened
Version: 0.10.30.11.3

Doesn't seem to work anymore?! The list above is ordered strictly by ticket # and I get the same in my install (0.11.3).

comment:9 by Christian Boos, 14 years ago

Milestone: 0.110.11.6

See TicketQuery:

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

… Also, using "&" as a field separator still works but is deprecated.

If you use ',' then it works (example of comment:2):

 [[TicketQuery(status=closed&keywords=~genshi,order=priority)]]

#3925
whitespace not preserved in `{{{ }}}` blocks
#4647
Cannot view changesets
#4777
r4782 breaks ticket query page with stable Genshi (0.3.6)
#5099
Remaining issues with Genshi post-509
#7684
Render error on error pages and wiki edits
#7816
UnboundLocalError: local variable 'data' referenced before assignment
#7959
UnicodeDecodeError: 'ascii' codec can't decode byte 0xe8 in position 4: ordinal not in range(128)
#8365
Trac trunk requiring Genshi "0.6dev_r960" but only "0.6dev_r0" available
#9240
Genshi>=0.6dev-r1072 as dependency of Trac 0.12dev not found
#10569
checking catalog utility which supports genshi markups
#10879
Trac becomes very slow with many (>50) milestones
#11184
IndexError: pop from empty list when trying to add attachment
#3847
No more Next Ticket/Previous Ticket from Query
#3848
"active" item in mainnav: not there with Genshi?
#4249
Error reporting fails for some Genshi syntax errors
#4272
Available Reports page always asks if I want to delete "this report"
#4337
Document Genshi version required for r4399 to work
#4454
Trac 0.11 and Apache trouble
#4558
Import genshi.core.Attrs from genshi.core, not just genshi
#5603
Allow macros to return Genshi streams
#5931
[PATCH] compliance with Genshi's strict mode
#5932
TypeError: expecting datetime, int, long, float, or None; got <class 'genshi.template.eval.Undefined'>
#6374
get rid of macros.html in favor of xi:include'd snippets
#7154
Link to custom stylesheet removes IE pre-7 hacks
#7401
Please lower Genshi requirement to 0.4.4
#7842
[patch] Allow manage genshi.max_cache_size from ini file
#8286
MacroList macro broken
#8513
Genshi template syntax in ticket_subject_template
#8595
Add IDs to the labels in the ticket modification form
#9056
Refactor trac.mimeview.pygments.GenshiHtmlFormatter for clarity.
#9165
Render Wiki Content to Genshi Markup Stream
#9294
Trac 0.11.7 incompatibility with Genshi 0.6
#10126
TracError: Genshi UnicodeEncodeError error while rendering template (fresh Trac install)
#10438
Please fix documentation about the variables available to customize templates
#10635
Custom Query / Reports are very slow
#10892
TypeError: 'NoneType' object is not iterable --- enumerating late links (layout.html)
#11218
Genshi UnicodeEncodeError after entering comment containing a hyperlink sourrounded by brackets
#11261
Genshi UnicodeEncodeError error while rendering template (unknown template location)
#11780
UnicodeError with its traceback should be logged while rendering genshi template
#12677
glitch in ITemplateStreamFilter backward compatibility support
#12866
String isn't extraced from _("...") in py:with attribute
#13046
ParseError: duplicate attribute: line 281, column 33 - when rendering simple report
#13122
trac.util.tests.html.TracHTMLSanitizerLegacyGenshiTestCase: TypeError: decode() argument 1 must be string, not None
#13253
UnicodeEncodeError raised while rendering timeline rss when author of event is unknown and unicode
#3849
webadmin-genshi needs titles
#6835
XHTML served as text/html, causes rendering problems
#8770
site.html template is not applied to wiki formatted content
#9197
trac search pops internal error: "KeyError: u'Path'" when language = zh_CN
#3836
Author value in RSS feed is not compliant with RSS 2.0 specs.

So the support for the deprecated '&' separator doesn't seem to work for specifying the order.

comment:10 by Marcus Lindblom <macke@…>, 14 years ago

Ok. comma works and I'm fine with that. I didn't catch the deprecation of &, sorry about that.

comment:11 by Christian Boos, 14 years ago

Thanks for the feedback.

Fixing the backward compatibility for order seems indeed to be more trouble than it's worth, so unless someone comes up with a simple fix, I propose this doc fix:

  • trac/ticket/query.py

     
    10641064
    10651065    For compatibility with Trac 0.10, if there's a second positional parameter
    10661066    given to the macro, it will be used to specify the `format`.
    1067     Also, using "&" as a field separator still works but is deprecated.
     1067    Also, using "&" as a field separator still works (except for `order`)
     1068    but is deprecated.
    10681069    """
    10691070
    10701071    def expand_macro(self, formatter, name, content):

comment:12 by Christian Boos, 14 years ago

Resolution: fixed
Status: reopenedclosed

Doc fix applied in r8862.

Modify Ticket

Change Properties
Set your email in Preferences
Action
as closed The owner will remain Matthew Good.
The resolution will be deleted. Next status will be 'reopened'.
to The owner will be changed from Matthew Good to the specified user.

Add Comment


E-mail address and name can be saved in the Preferences .
 
Note: See TracTickets for help on using tickets.