Article - CS332284
ThingWorx Database Thing query service always limited to 500 rows
Modified: 12-Aug-2025
Applies To
- ThingWorx Platform 7.1 to 9.6
Description
- The same query when executed on the database returns many more rows than 500
- Unable to see all data from query service in ThingWorx
- How to remove the limitation on Max Rows for SQL (query) services
- Is there any limit for Max Rows parameter of SQL Query services?
- Complete rows are not loading for the user in ThingWorx SQL query service
This is a printer-friendly version of Article 332284 and may be out of date. For the latest version click CS332284