Skip to main content
Y
YC_109464836-Contributor
6-Contributor
June 20, 2024
Solved

How to exceed the limit of 500 numbers in sql query？

  • June 20, 2024
  • 2 replies
  • 1110 views

Hi everyone.  I want to get all data from my database which  totalNumber  is larger than 500, but the result is only returning 500.  Is there any method to overcome this limit?

YC_10946483_0-1718853871573.png

 

Best answer by Surya_Tiwari

Hi, @YC_10946483  Look at the below community post.

 

https://community.ptc.com/t5/ThingWorx-Developers/Max-number-of-records-of-SQL-query/m-p/831922#M59993

2 replies

S
Surya_Tiwari16-PearlAnswer
16-Pearl
June 20, 2024

Hi, @YC_10946483  Look at the below community post.

 

https://community.ptc.com/t5/ThingWorx-Developers/Max-number-of-records-of-SQL-query/m-p/831922#M59993

Y
YC_109464836-ContributorAuthor
6-Contributor
June 20, 2024

Hi,@ Surya_Tiwari 

Appreciate for your reply

Terms & ConditionsCookie settingsAccessibility statement