You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

After 24.10 update, BOs don't honour the default sort order of the underlying DB View/Table

Summary:

We have noticed that after 24.10 update, Business Objects don't honour the default sort order of the underlying DB View/Table

Has anyone else noticed this lately and is there a quick fix?

We can't add Order By/Transforms in 100s of API calls in several screens in several Apps, as a workaround.

Content (please ensure you mask any confidential information):

Say my DB View DDL has an inherent sort order mentioned on field1, so if I simply query "select * from MyDBView" in a SQL Commandline/Tool, the rows received follow the sort order setup for Field1 values.
But inside Business Object in VBCS, we see the sort order is not respected anymore.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!