Community Tip - New to the community? Learn how to post a question and get help from PTC and industry experts! X
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
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.
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