Service output InfoTable only returning maxItems 500 records

Forum|Forum|9 years ago
May 11, 2017
4 replies
6699 views

I am trying to use output of a service into another service, but I am only getting 500 records. When I run the same query in Oracle I get more records. Please let me know where and how can I set maxItems for output InfoTable to get full resultset.

Regards,

Hemant

Best answer by ankigupta

Hi Hemant Rastogi,

I had posted regarding Sql Queries Service in this Thread above.

Here it is for the quick reference:

There is a property called Max Rows for the SQL (Query) service type which is defined on the Service info tab of the service and it has a default value of 500. You can change it according to your requirement.

A

ankigupta

5-Regular Member

Hi Hemant Rastogi,

There is a property called Max Rows for the SQL (Query) service type which is defined on the Service info tab of the service and it has a default value of 500. You can change it according to your requirement.

I hope it helps.

A

ankigupta

5-Regular Member

For ThingWorx core Java/JavaScript services with output as Infotable; Max Rows property can be defined on the Mashup by clicking the Service and updating it in the Right Pane.

V

vshanmugavelayu

11-Garnet

Hi Ankit, i have a requirement to limit the number of "Infotable" rows displayed using Grid in the Mashup. Like you mentioned above, is the "Max Rows" a property in Mashup that can be used?

A

ankigupta

5-Regular Member

Hi Varunraj Shanmugavelayudham,

Yes, Max Rows can be used for ThingWorx core Java/JavaScript services with output as Infotable.

Max Rows property can be defined on the Mashup by clicking the Service and updating it in the Right Pane.

H

hrastogi

Author

1-Visitor

Ankit,

Thanks for the response. My issue is I have created the service using SQL Query which is giving me output in a InfoTable. I am using the service in another service (JavaScript based) to manipulate the data.

The issue is from SQL Query service, my InfoTable is being restricted to 500 maxitems records.

Let me know if you have solution for this,.

Regards,

Hemant

A

ankigupta

Answer

5-Regular Member

Hi Hemant Rastogi,

I had posted regarding Sql Queries Service in this Thread above.

Here it is for the quick reference:

There is a property called Max Rows for the SQL (Query) service type which is defined on the Service info tab of the service and it has a default value of 500. You can change it according to your requirement.