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

querypropertyhistory does not fetch all the rows between the specified date

Aquamarine

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 10

Re: querypropertyhistory does not fetch all the rows between the specified date

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.

Re: querypropertyhistory does not fetch all the rows between the specified date

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

Re: querypropertyhistory does not fetch all the rows between the specified date

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

Re: querypropertyhistory does not fetch all the rows between the specified date


@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

Re: querypropertyhistory does not fetch all the rows between the specified date

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?

Re: querypropertyhistory does not fetch all the rows between the specified date


@PaiChung wrote:

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?


Yes. I'm not using the maxItems parameter at all. But just checked by giving that parameter if it could have an impact.  Whatever value I give, it fetched those many records which means those many records are logged.

 

My requirement is to provide a start and end date, fetch all records. I do not want to miss out on any records.

 

There isn't any timezone issue.

Re: querypropertyhistory does not fetch all the rows between the specified date

But when you leave MaxItems blank it will always default to 500 records.

Are you sure you have less than 500 records?

Generally we set MaxItems to a rather large number like 1000000 if we need to be sure to get all the records and don't know how many to expect.

Re: querypropertyhistory does not fetch all the rows between the specified date

I'm sure the value stream has more than 500 records. If I set the MaxItems to 1000000, then the result shows records beyond the date range entered

 

Thanks,
Arvind

Re: querypropertyhistory does not fetch all the rows between the specified date

You may have to pass in a start and end date then, together with maxItems.