QueryNumberPropertyHistory limit 500 rows

[ldell'aversano]

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.

Thank's a lot

Luigi

[CarlesColl · Accepted solution]

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.

[ldell'aversano]

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