Some Eclipse Foundation services are deprecated, or will be soon. Please ensure you've read this important communication.

Bug 350763

Summary: User-defined Sort Hints in a data set got overwritten in a SQB design session
Product: z_Archived Reporter: Linda Chan <lchan>
Component: BIRTAssignee: Linda Chan <lchan>
Status: RESOLVED FIXED QA Contact:
Severity: normal    
Priority: P3    
Version: 2.6.2   
Target Milestone: 3.7.1   
Hardware: PC   
OS: Windows All   
Whiteboard:

Description Linda Chan CLA 2011-06-29 23:02:28 EDT 
When editing a data set in the Data Set Editor, an user may add own user-defined Sort Hints.  But each time an user activates the SQB designer page in DSE, those sort hints always got overwritten and replaced by the sort keys defined in the query's OrderBy clause. 

This is expected behavior if the OrderBy clause gets changed, as it is not clear how a revised OrderBy clause relates to those user-defined sort hints.
However, if the OrderBy clause did not get changed, the previously defined sort hints should be preserved.
Comment 1 Linda Chan CLA 2011-06-29 23:34:51 EDT 
Delivered fix in org.eclipse.birt.report.data.oda.jdbc.dbprofile.ui.
It now checks that if the OrderBy clause did not get changed in a SQB design session, and will then preserve the SortSpecification provided by the ODA host in a session request.  If the OrderBy clause did get changed, its sort keys will continue to replace the data set sort hints; and users will have to redefine any sort hints that are still applicable on top of the revised OrderBy clause.
Comment 2 Linda Chan CLA 2011-07-01 16:00:29 EDT 
Resolved.