JobSubmission search results missing objects

[spinifythomas]

Hello Bullhorn Support team,

We've noticed some anomalies with the results we're getting back from the search/JobSubmissions endpoint when providing it query params like:

Code: Select all

query=dateLastModified:[20240118041648 TO 20240118041911]&sort=dateLastModified

The request is pretty much just a search for all the JobSubmissions that have a dateLastModified within a ~5 minute window, usually made very close to 5 minutes ago to almost the current time. If the same request with the same timestamps runs again a couple of minutes later, sometimes there are additional results that were not there the first time. In other words, when it runs the first time it seems to be missing a few JobSubmissions that were modified within the window, and then they appear in the results when the exact same query is run a couple of minutes later.

It's almost like for some of the JobSubmissions there's something cached or like a row's been locked while some other longer-running processing is happening when we make the first request, and then once that's done the dateLastModified gets updated on the JobSubmission and it appears in the results the next time the same request is made.

Is this a known issue? And what's the best workaround to handle this situation?

Kind regards,

Thomas