Edgewall Software
Modify

Opened 17 years ago

Closed 17 years ago

#7277 closed defect (fixed)

[PATCH] Report order by overridden with grouping

Reported by: Dave Gynn <dgynn@…> Owned by: Matthew Good
Priority: normal Milestone: 0.11
Component: report system Version: 0.11-stable
Severity: normal Keywords:
Cc: Branch:
Release Notes:
API Changes:
Internal Changes:

Description

An SQL report that has a __group__ column and an order by clause gets re-sorted on __group__. The explicit order by is ignored.

An example of this problem is the 'Active Tickets, Mine first' report from the default set of reports. That report gets re-ordered so that "My Tickets" come last.

The attached patch prevents the re-sorting, unless sort parameters have been passed in the request.

Attachments (1)

report-group-order.patch (676 bytes ) - added by Dave Gynn <dgynn@…> 17 years ago.

Download all attachments as: .zip

Change History (3)

by Dave Gynn <dgynn@…>, 17 years ago

Attachment: report-group-order.patch added

comment:1 by anonymous, 17 years ago

Milestone: 0.11

Looks like this was broken with the fix for #7179.

comment:2 by Christian Boos, 17 years ago

Resolution: fixed
Status: newclosed

The fix worked fine for me for the "My Tickets" report, and it looks like it didn't break other reports, so I applied the patch in [7183], thanks!

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.