Bug 327993 - Records in reports not sorted according to the sorting of the query
Summary: Records in reports not sorted according to the sorting of the query
Status: CLOSED FIXED
Alias: None
Product: KEXI
Classification: Applications
Component: Reports and Printouts (show other bugs)
Version: 2.7.4
Platform: Compiled Sources All
: NOR normal
Target Milestone: 2.7
Assignee: Adam Pigg
URL: https://forum.kde.org/viewtopic.php?f...
Keywords:
Depends on:
Blocks: 327995
  Show dependency treegraph
 
Reported: 2013-11-23 23:31 UTC by Jarosław Staniek
Modified: 2016-04-11 11:35 UTC (History)
1 user (show)

See Also:
Latest Commit:
Version Fixed In: 2.7.5


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Jarosław Staniek 2013-11-23 23:31:08 UTC
Records in reports should be sorted according to the sorting of the query from which they are fed. 

Reproducible: Always

Steps to Reproduce:
1. Create query with sorting explicitly set, eg. descending. Save the query.
2. Create report based on this query
3. Open the report.
Actual Results:  
Report is sorted using default order.

Expected Results:  
Report is sorted using order specified by the query.
Comment 1 Jarosław Staniek 2013-11-23 23:46:42 UTC
The same could apply to forms.
Comment 2 Jarosław Staniek 2013-11-24 00:02:08 UTC
Git commit 046a98a86728981ed3eec723a3b6a8670c437973 by Jaroslaw Staniek.
Committed on 23/11/2013 at 23:33.
Pushed by staniek into branch 'master'.

Make records in reports sorted according to the sorting of the query

Probably applies to forms as well.

M  +1    -0    libs/db/queryschema.cpp

http://commits.kde.org/calligra/046a98a86728981ed3eec723a3b6a8670c437973
Comment 3 Jarosław Staniek 2013-11-24 00:03:11 UTC
Git commit b123505679df59ce1edafb29d64508715d07518b by Jaroslaw Staniek.
Committed on 23/11/2013 at 23:33.
Pushed by staniek into branch 'calligra/2.7'.

Make records in reports sorted according to the sorting of the query

Probably applies to forms as well.

M  +1    -0    libs/db/queryschema.cpp

http://commits.kde.org/calligra/b123505679df59ce1edafb29d64508715d07518b
Comment 4 Jonathan Webb 2016-04-11 10:49:08 UTC
I am using 2.8.5 on Linux Mint 17,  I am finding that the records in a report are not sorted, even though they are derived from a query that has sorting applied
Comment 5 Jarosław Staniek 2016-04-11 11:35:31 UTC
This may be related to a different issue. Do you have the same name used for the query and table? If so perhaps renaming the query (and reassigning it to the report) helps?