cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Service unable to return more than 500 rows in the infotable

sponomarenko-3
1-Newbie

Service unable to return more than 500 rows in the infotable

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?

1 ACCEPTED SOLUTION

Accepted Solutions

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

View solution in original post

3 REPLIES 3

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

View solution in original post

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:

chrish
1-Newbie
(To:AnnaAn)

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

Announcements