I have found that reports based on saved searches are not immediately updating themselves and get stuck with results from a prior report run even though the searches themselves return accurate updated results and I don’t know why this is happening.
Happened most recently today:
- I createe a custom report template based on a saved search several days ago
- It ran perfectly and the results were correct. The saved search produced 3 hits and the report had 3 rows
- My saved search was based on an staff assignments.
- I did a bulk upload today that applied staff assignments to additional records
- I reran the report and expect there to be 79 rows. There’s the same 3 rows as before
- I ran the saved search. There are 79 contacts as expected
- So my report is stuck with the old results from over a week ago (i.e. the result it had when I first and last ran the report).
- If there’s a built in lag it seems significant (in this particular case, the upload that updated my saved search result was over an hour ago?)
- It’s not caching on my end (I re-accessed the report on an entirely different browser and got the same results)
- I can force feed reports like this to update themselves by editing the search as follows: deselecting my original saved search, reselecting my (same) saved search, rerunning the report, resaving the report but that seems ridiculous to have to do that??? (and especially inconvenient if others need to use and are relying on the same report.)
- Usually when this happens and I notice it I can’t wait to see how long it will take to accurately refresh itself (or if it will EVER do so). With my current project I need to set up dozens of saved searches for numerous other admins, so this problem is onerous and distressing to me.
- It’s not a result of date based filtering. The only filters on this report are Contact Records (where I have indicated the saved search) and Date Contact Created (which I have not touched/am not using)
- As a test, I plan to recheck one of my stuck reports tomorrow just to see if it at least refreshes itself overnight.
It’s irritating to have to babysit my reports like this and not to be able to rely on the results (nor confidently tell my clients to rely on these reports).
Have others noticed this issue? I will log a bug ticket tomorrow if the search still refuses to refresh itself overnight (maybe even if it does eventually refresh itself actually) but mostly wondered if others have ever noticed this behavior.
