Skip to main content
L
ldell'aversano1-Visitor
1-Visitor
May 29, 2017
Solved

QueryNumberPropertyHistory limit 500 rows

  • May 29, 2017
  • 1 reply
  • 2128 views

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

Best answer by CarlesColl

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.

1 reply

C
CarlesColl1-VisitorAnswer
1-Visitor
May 30, 2017

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.

L
ldell'aversano1-VisitorAuthor
1-Visitor
May 30, 2017

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

Terms & ConditionsCookie settingsAccessibility statement