Query refresh not working when run in queue

When a query is dynamic in a queue followed by an export or report related to the query and the queue is run, the query will produce no results for the report or export. 

Change the query from dynamic to static,

Steps to Duplicate

  1.     Create a dynamic query. Confirm there are results. In my example, the query is called Gifts this quarter.
  2.     In Admin > Queue, create a new queue with Query refresh and Query Export.
  3.     Run the Queue OnDemand.
  4.     Upon opening the CSV, there are no results. There should be results here. I should see the same gifts that are in my query.
  5.     Go back into RE > Admin > Queue and run the same queue OnDemand.
  6.     Open the CSV, and you will now see the data


 Raiser's Edge

Was this article helpful?