Bug with query data refresh scheduler

[judyxlam]

My query pulls data from 7 days ago up through yesterday. On the scheduler, I have the refresh rate set at 86400 seconds. My understanding is that the data will refresh once a day but if a user executes the query and there has not been a refresh, the system will automatically refresh the data before delivering the results to the user. By doing so, the elapsed time from the last refresh gets reset.

The user is executing the URL once a day to pull data. The data is refreshed sometimes and sometimes it is not. We are not getting consistent results each day during the URL execution to get data up through the previous day.

For example, today is 12/16. I should data up through 12/15. Instead, I am seeing data only up through 12/14.

But on 12/15, when I executed the URL, I see the data was refreshed up through 12/14.

I agree with other postings that an enhancement need to be made to allow users to better control the data fresh schedule. But in the meantime, can this bug be addressed?

Thank you.