Skip to main content
A
asekar5-Regular Member
5-Regular Member
June 28, 2018
Question

querypropertyhistory does not fetch all the rows between the specified date

  • June 28, 2018
  • 2 replies
  • 3228 views

querypropertyhistory does not fetch all the rows between the specified date (start date and end date) even though the specific value stream has entries for a specific time period 

2 replies

V
vxavier5-Regular Member
5-Regular Member
June 28, 2018

Hi,

 

How are you logging the data? If it is in "value change" mode, did the data change in that period of time? 

 

Cheers,

Vinicius.

A
asekar5-Regular MemberAuthor
5-Regular Member
June 28, 2018

Hi Vinicius,

 

            Yes.. the data is streaming from kep and I'm sure that data exists for a specific period of time. Data change type is set to value

 

Arvind

P
PaiChung22-Sapphire I
22-Sapphire I
June 28, 2018

Could it all be MaxItems related? Did you set that?

A
asekar5-Regular MemberAuthor
5-Regular Member
June 28, 2018
@PaiChung wrote:

Could it all be MaxItems related? Did you set that?

Hello Chung,

 

         Thanks for your reply.

 

I do not think it could be related to max items. When I set this, it does not honor the start date and end date parameters. Total number of rows fetched is equal to max items in this case.

 

Arvind

P
PaiChung22-Sapphire I
22-Sapphire I
June 28, 2018

Ok so you aren't missing entries just because you are only pulling 500 records but there might be 1000 in the timespan you are requesting.

Could there be a timezone offset? are you requesting data for a location that is in a different time zone compared to your location?

Terms & ConditionsCookie settingsAccessibility statement