We have a Forms process that invokes workflow to save the partially completed form to a Waiting folder and then once the final approval is done invokes a second workflow that retrieves the entry using Search Repository and fills the final data in. The Search Repository is not returning the result. I have spent 3 hours troubleshooting it as the tests in designer and the client work fine.

Using Search Repository to search for a single entry match in a single text field, a drop down "Pending" field, and a folder search. Once retrieved we make it the starting entry and go from there. Looks like this:

The token we're using in the search is the Forms _Start Date token which I previously write to the metadata of the form sort of as a serial # if you will.

This search returns no results during any real world tests as per below:

However, if I Track Tokens directly ahead of the Search Repository I return:

If I copy and paste that token into Test Query in the Workflow Designer on the failed instance it returns the result as expected: (Returned 1 result)

If I use the same search syntax in the client and paste that token value into the advanced search it also returns the result.

Why is it failing in the real world?