query the local database

Hi, everybody.

Why is it that a database query has 5000 pieces of data, but a query in thingworx only has 500 pieces of data?

企业微信截图_17137670402192.png 企业微信截图_17137672529673.png

Best answer by Snoopy_hu

This is here of solution,only Modified here to 500+.

企业微信截图_17143725486097.png

24-Ruby III

Take a look:

"How to return more than 500 rows of Infotable results when running ThingWorx service from composer": https://www.ptc.com/en/support/article/CS398662
"How to add more than 500 rows data into "infotable" in Thingworx": https://www.ptc.com/en/support/article/CS249100
"ThingWorx Database Thing query service always limited to 500 rows": https://www.ptc.com/en/support/article/CS332284
"ThingWorx Display and InfoTable Limit to 500": https://community.ptc.com/t5/ThingWorx-Developers/ThingWorx-Display-and-InfoTable-Limit-to-500/td-p/504225
"QueryNumberPropertyHistory limit 500 rows": https://community.ptc.com/t5/ThingWorx-Developers/QueryNumberPropertyHistory-limit-500-rows/td-p/503004

Author

11-Garnet

Hi@VladimirN

Thanks, I'll try them one by one.

AuthorAnswer

11-Garnet

This is here of solution,only Modified here to 500+.

企业微信截图_17143725486097.png

Sign up