You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
I have a service that queries customer reports every 10 minutes on a cron job, and I've been noticing data from previous days recently started to "leak" into the next day. Upon further inspection, it seems that there's 2 points at which the report shows data from the previous day: slightly past midnight and at 3am. I was wondering if this is a known issue and if anyone has had success handling it properly without discarding useful data.
Even though I'm requesting data for 'TODAY', I still see data from the previous day at midnight and 3am. My first instinct was to look for a field in the query that would tell me the date for the data returned, but I couldn't find any such field. Does it exist? Otherwise, is there a way to guarantee that the report will only return today's data?
The text was updated successfully, but these errors were encountered:
I have a service that queries customer reports every 10 minutes on a cron job, and I've been noticing data from previous days recently started to "leak" into the next day. Upon further inspection, it seems that there's 2 points at which the report shows data from the previous day: slightly past midnight and at 3am. I was wondering if this is a known issue and if anyone has had success handling it properly without discarding useful data.
I call the report like this
Even though I'm requesting data for
'TODAY'
, I still see data from the previous day at midnight and 3am. My first instinct was to look for a field in the query that would tell me the date for the data returned, but I couldn't find any such field. Does it exist? Otherwise, is there a way to guarantee that the report will only return today's data?The text was updated successfully, but these errors were encountered: