axStart: Cannot mix old-style sorting with new-style Group By or Order By on a query.

[Blog bot]

Источник: http://axstart.spaces.live.com/Blog/...C0A0!417.entry
==============


When working with AX2009 I run into a minor change in the query objects of AX. This change deals with the AX 4.0 Datasource property ordermode. In AX 4.0 this property could be set to Order by (default) or Group by. In AX 2009 two new nodes appears in our query object: Order by and Group by.


If you combine the AX 4.0 and AX 2009 concept an error, like the title of this document, appears. I saw some remarkable things, during investigation of this issue:

• Queries built in AX 4.0 and upgraded to AX 2009 will continue working the old way;
• Building a new query in AX 2009 will always work the new way because the property order mode is not available anymore; The report wizard in AX2009 still makes a data source query with the order mode on the data source query. (bug?)

Источник: http://axstart.spaces.live.com/Blog/...C0A0!417.entry