Skip to main content
asekar5-Regular Member
5-Regular Member
Jun 28, 2018 7:09 AM UTC
Question

querypropertyhistory does not fetch all the rows between the specified date

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 

10 replies

vxavier5-Regular Member
5-Regular Member
Jun 28, 2018 1:10 PM UTC

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.

Translate
asekar5-Regular MemberAuthor
5-Regular Member
Jun 28, 2018 3:20 PM UTC

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

Translate
PaiChung22-Sapphire I
22-Sapphire I
Jun 28, 2018 2:55 PM UTC

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

Translate
asekar5-Regular MemberAuthor
5-Regular Member
Jun 28, 2018 3:23 PM UTC
@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

Translate
PaiChung22-Sapphire I
22-Sapphire I
Jun 28, 2018 4:37 PM UTC

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?

Translate
Terms & ConditionsAccessibility statement