Community Tip - You can subscribe to a forum, label or individual post and receive email notifications when someone posts a new topic or reply. Learn more! X
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
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.
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
Could it all be MaxItems related? Did you set that?
@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
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?
@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.
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.
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
You may have to pass in a start and end date then, together with maxItems.
thank you... I'm currently involved in doing such as exercise. I have tried passing in start date and end date along with max items. I will keep you posted on this