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

QueryNumberPropertyHistory limit 500 rows

SOLVED
Highlighted

QueryNumberPropertyHistory limit 500 rows

Hi,

I use QueryNumberPropertyHistory service for DAD and DataConnect transformation as suggested:  link.

The problem is that this service returns "only" 500 rows at maximum.

How could I avoid this limit in order to obtain all rows from startDate to endDate?

I have found also this service: QueryPropertyHistory . but it doesn't work properly because it returns all columns instead of one.

GetNumberRow_Service.png

GetNumberRow_ServiceOutput.png

Thank's a lot

Luigi

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted

Re: QueryNumberPropertyHistory limit 500 rows

All querying services on ThingWorks has a default maxItems set to 500. If you want more rows you must specify maxItems value, and no there is no maxItems=Infinite option.

View solution in original post

2 REPLIES 2
Highlighted

Re: QueryNumberPropertyHistory limit 500 rows

All querying services on ThingWorks has a default maxItems set to 500. If you want more rows you must specify maxItems value, and no there is no maxItems=Infinite option.

View solution in original post

Highlighted

Re: QueryNumberPropertyHistory limit 500 rows

Ok Carles,

now, setting as default a number greater then 500 into a myself service it works.

I don't understood why maxItems input text doesn't works.

If I set 600 into maxItems input text, DAD returns 500 rows, always.

Thank's for the support.

Luigi

Announcements

Thingworx Navigate content has a new home! Click here to access the new Thingworx Navigate forum!