Skip to main content
S
sponomarenko-31-Visitor
1-Visitor
May 6, 2016
Solved

Service unable to return more than 500 rows in the infotable

  • May 6, 2016
  • 2 replies
  • 2680 views

Hi, everybody

We found a limitation which blocks our functionality.

We have a service returning infotable which executes SQL query via JDBC extension.

And the result is cut on 500 rows maximum.

How could we remove this limitation?

Best answer by CarlesColl

If you have a maxItems parameters set it to a bigger number

2 replies

C
CarlesColl1-VisitorAnswer
1-Visitor
May 6, 2016

If you have a maxItems parameters set it to a bigger number

A
AnnaAn14-Alexandrite
14-Alexandrite
May 17, 2016

Hi Ponomarenko,

If you are returning InfoTable in your SQL Query, you will see in the "Service Info" tab of your service, there is an input of "Max Rows", which will allow you input a bigger return items number as you want:

    C
    chrish1-Visitor
    1-Visitor
    February 6, 2017

    Is there a way to set "Max Rows" to NOT LIMIT the return set at all?

    Terms & ConditionsAccessibility statement