topic query the local database in ThingWorx Developers

query the local database

Snoopy_hu — Mon, 22 Apr 2024 06:32:11 GMT

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?

VladimirN — Mon, 22 Apr 2024 07:07:45 GMT

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

Snoopy_hu — Tue, 23 Apr 2024 00:25:41 GMT

Thanks, I'll try them one by one.

Snoopy_hu — Mon, 29 Apr 2024 06:38:50 GMT

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