cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

How it will behave if I will pass 0(Zero) as a max rows in SQL Query Service.

smishra-31
5-Regular Member

How it will behave if I will pass 0(Zero) as a max rows in SQL Query Service.

Hi,

 

Does anyone has ever set a 0(Zero) as a max rows in their SQL Query service?

 

What type of behavior they have found in setting 0 as a max rows instead of 500(default one)?

 

I tried it and it seems it is returning the n number of rows. (where n is the total number of rows returned from sql database.)

I want this type of result where I don't have to set manually the max rows number, which is by default is 500.

 

Can anyone confirm this from ThingWorx Community or PTC team.

 

Thanks & Regards,

Shashank 

3 REPLIES 3

I'm using pgSQL, and I tried maxrow=0 in QueryPropertyHistory Service.  I get 500 rows of result as well, and more than that, it contains a message showing:

First 500 rows of 767961. Use a mashup to view additional results.

smishra-31
5-Regular Member
(To:zyuan1)

Hi,

 

Thanks @zyuan1 for your quick reply.

Can you please confirm your thingworx version too on which you have checked this.

I have tested this on ThingWorx 8.2 version.

 

Thanks & Regards,

Shashank

8.4.2

Announcements