Skip to Content

Maximum No of Infoobjects / Records Returned by Query Builder

All,

Can you please share with me where to increase the number of records returned by a Query Builder? No mater how I modify my select statements, I always get 1000 records.

Thanks,

Recca

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Jun 14, 2017 at 10:27 PM


    Thanks Jyothirmayee and Bharath,

    Jyothirmayee's solution actually solved my issue. I even tested with TOP 9000 and
    I was getting the same count. I appreciate it.

    Thanks,

    Recca

    Add comment
    10|10000 characters needed characters exceeded

  • Jun 14, 2017 at 05:21 PM

    BI Platform SDK returns max 1000 objects as Query result.

    Please post the query in following format:

    SELECT TOP 1-1004 * FROM CI_INFOOBJECTS,CI_APPOBJECTS,CI_SYSTEMOBJECTS

    -

    - Bharath


    Add comment
    10|10000 characters needed characters exceeded