Skip to Content
avatar image
Former Member

Query Execution with Maximum Rows

Dear Community,

I have a question regarding Queries in ABSL. I want to use the execute function with the maximum rows and start rows in order to get a better performance while executing queries.

An example to query BusinessPartners:

var query = BusinessPartner.QueryByIdentification;

var selPara = query.CreateSelectionParams();

var contacts = query.Execute(selPara, dummy , maxRowCount, start);

The second Param (dummy) should be the SortingParameters, but there are no sorting Parameters available for the BusinessPartner BO.

Do you have any suggestions to use the maximum row count to execute queries on the BusinessPartner BO?

Kind Regards,

Lukas

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Oct 20, 2015 at 12:40 PM

    Hello Lukas,

    As you can read in the documentation the SortingParameter is only supported for Custom BOs.

    This is due to the different implementation frameworks of the SAP BOs which are not supporting the sorting in a generic manner.

    As consequence the MaximumRows and StartRow is also not supported. 😔

    I am afraid that there is no solution to this request.

    Sorry,

       Horst

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hello Lukas,

      one another workaround would be to misuse the UI to do the paginating job, becaus UI supports paging. You have to use an UI query then, and bind your nodes to the advanced list pane, set the visibility of this pane to "false", and define the desired number of visible rows, which will be only loaded then. I'm not sure whether only visible rows are loaded or visible rows plus some rows before and after the visible.

      Of course this workaround has a very restricted applicability, but it has some nice features like sorting.

      Best regards,

      Leonid