Skip to main content
1-Visitor
August 3, 2020
Question

QueryPropertyHistory not fetching all rows between the specified start and end date

  • August 3, 2020
  • 1 reply
  • 2644 views

Hi

Using QueryPropertyHistory I'm not able to fetch all rows between the specified start and end date. 

  • I'm logging the data in "value changed" mode.
  • It is also not related to max Item, I've checked it by increasing the maxItem.

Please provide a solution because I need this for my graph.

Thanks in advance.

1 reply

1-Visitor
August 3, 2020

For more information I'm attaching the screenshot.

  1. When I put start date as 1st July and end date as 31st July, After 2nd July, I'm getting data for 22nd July, But there are data for 3rd and 4rt July.
  2. When I put start date as 3rd July and end date as 31st July, I'm getting data for 3rd and 4rt July. For the same thing I'm not getting records when I put the '1'st filter
16-Pearl
August 3, 2020

What value did you use for maxItems? Is the total count of data points in this interval less than or equal to maxItems?

1-Visitor
August 3, 2020

I tried with maxItem greater than the total count of data points. I didn't work.

So I removed the maxItem.