Notification Policy Queries always get no results
We are trying to enable our first Notification Policy to modify Incidents on a schedule but the Queries are failing to pull anything. I have tested the queries by copying them over to HelpDesk and in SQL (with a few modifications for the environment) and they work fine but when I run them as a Notification Policy in Tasks I get no results, just "This Notification Policy has been executed however the query did not return any rows, so none of the policy actions will perform their configured duties".
For reference, here is my query:
SELECT T0.[workitem_number] AS 'workitem_number' FROM [HD_workitem_current_view] T0 WHERE T0.[workitem_status_lookup_id] = 550 AND T0.[workitem_assigned_to_worker_id] IN (361,263,300,354,350,256,392,266,326,313,417,342,281,250,258,269,316,192,439,306,359,233,346,401,467,412,441,297,319,365,340,328,398,377,344,348,275,272,278,443,374) AND DATEDIFF(DAY, T0.[workitem_modified_on], GETDATE()) > 16
I initially built the query with straight SQL but then went back and built it with the Query Builder and got almost identical code. Both queries run fine in SQL on the server. I even tried removing the time paramter to increase the results but it made no difference. I have even tried running the queries in some of the built in and they also get no results.
I found some reference in this forum about 'enabling the client' if you have not been using Notification Policy Queries (in this case for Carbon Copy). Is there some setting I am missing?