query the local database

[Snoopy_hu]

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]

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]

Hi@VladimirN 

Thanks, I'll try them one by one.

[Snoopy_hu · Accepted solution]

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