Panther p_occurs_between returns "Your query did not return any results"
Issue
When trying to use the Data Explorer macro p_occurs_between()
, I expect to see data returned. Data Explorer displays a message that says, "Your query did not return any results."
Resolution
To resolve this issue, try the following steps:
- Make sure the macro's first parameter indicates a time before the second parameter. For example, if you try
p_occurs_between(current_date-1, current_date-2)
this will return no data becausecurrent_date-1
is yesterday andcurrent_date-2
is the day before yesterday, sop_occurs_between()
will look for data that occurred after yesterday and before the day after yesterday.- When using dates in
p_occurs_between()
without specifying times in hours or minutes, note that the query acts the same as if you added the time stamp00:00:00
to each date. This will almost always exclude all data from the latter date.
- When using dates in
- Make sure there is data available in your target time range. For example, if you try
p_occurs_between(current_date-2, current_date-1)
and no data appears, it's possible that data stopped flowing 3 days ago and started again today. To check for this, try a query using a larger time window than you need, likep_occurs_since(current_date-5)
or similar.
Cause
This can be caused by a misconfiguration or by targeting a time range when no data was flowing.