Service output InfoTable only returning maxItems 500 records

[hrastogi]

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

[ankigupta]

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.

[ankigupta]

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.

[vshanmugavelayu]

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?

[ankigupta]

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.

[vshanmugavelayu]

I don't see the property "Mad Rows" on the mashup out of the box. should i create that? can you pls be more specific about how to create.

[ankigupta]

Hi Varunraj Shanmugavelayudham​,

Are you using a ThingWorx core services or created a custom JavaScript service or is it a Sql Query?

If it's custom JavaScript service; is it in-turn using any core ThingWorx Service?

Please share more details about your entities/service so that I can understand your query clearly.

[hrastogi]

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

[ankigupta · Accepted solution]

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.

[ankigupta]

Hi Hemant Rastogi​,

Is this issue resolved? Do let me know if you still face any issue.

[hrastogi]

Yes,. Thanks.

[ankigupta]

Great! Could you please mark helpful and correct answers (if any) to close this Thread and let other members know that this Thread has a solution.