Article - CS332284

ThingWorx Database Thing query service always limited to 500 rows

Modified: 29-Feb-2024   


Applies To

  • ThingWorx Platform 7.4 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?
This is a printer-friendly version of Article 332284 and may be out of date. For the latest version click CS332284