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

Community Tip - Did you know you can set a signature that will be added to all your posts? Set it here! X

QueryNumberPropertyHistory limit 500 rows

ldell'aversano
1-Newbie

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

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

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.

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

Top Tags