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

Community Tip - Did you know you can set a signature that will be added to all your posts? Set it here! X

Service unable to return more than 500 rows in the infotable

sponomarenko-3
2-Guest

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

AnnaAn
13-Aquamarine
(To:sponomarenko-3)

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?

Top Tags