Skip to main content
S
smishra-311-Visitor
1-Visitor
July 9, 2019
Question

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

  • July 9, 2019
  • 3 replies
  • 1543 views

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

Z
zyuan15-Regular Member
5-Regular Member
July 9, 2019

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.

    S
    smishra-311-VisitorAuthor
    1-Visitor
    July 9, 2019

    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

    Z
    zyuan15-Regular Member
    5-Regular Member
    July 9, 2019

    8.4.2

      Terms & ConditionsAccessibility statement