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

[smishra-31]

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 

[zyuan1]

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]

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

[zyuan1]

8.4.2