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

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

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

 

Surya_TiwariAnswer
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

View in thread

2 replies

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

Translate
YC_109464836-ContributorAuthor
6-Contributor
June 20, 2024

Hi,@ Surya_Tiwari 

Appreciate for your reply

Translate
Terms & ConditionsAccessibility statement