Create a Job to run a Custom Query Report

Create a Job to run a Custom Query Report

Schedule a Custom Query Report 

The Custom Query Reports can be set to run on a schedule. The Custom Query Reports include:

  • Custom Encounter Query
  • Custom Receipt Query
  • Custom Transaction Query
  • Custom Patient Query
  • Custom Appointment Query

InfoCustom Query Reports will show in the My Reports section at the top of the Reports Dashboard after being run by the Job Scheduler and will be automatically marked as Opened.


The Job is set up on the Report instead of in the Job Scheduler.


  1. On the Left Side Menu, select Reports.
  2. Select the Custom Query Report that you want to schedule.


Set up the Job Schedule on a Custom Query Report

Example: Custom Encounter Query


Create a Custom Query Report, or select an already created report.

  1. Run the Report to make sure it has the Criteria that you want.
  2. Select the Save icon .
  3. Select the Job Scheduler icon .



  1. Run Function: Defaults to the name of the Custom Query Report where the job was created.
  2. Criteria: Choose output format as CSV (spreadsheet) or PDF.
  3. For User: If applicable, choose the User that needs to use this report other than yourself. (Defaults to current User.)
  4. Upload Options: If applicable, select the checkbox for Upload to external site and choose the site from the dropdown.
  5. Pattern: Choose how often you want the job to run.
  6. Range:
  • Select a Start Date.
  • Select Time of Day you want the report to run.
  • Select No End Date, # of Occurrences, or select an End Date.
  1. Select Save [F2].





    • Related Articles

    • Create a Custom Query Report

      Select the Custom Query Report There are five Custom Query Reports. Select the one that you want to use. Transactions Panel Custom Encounter Query (CEQ) Custome Receipt Query (CTQ) Custom Transaction Query (CTQ) Patient Panel Custom Patient Query ...

    • Custom Receipt Query (CRQ)

      The Custom Receipt Query is driven by entered/posted Receipts. This report will match the Receipt Management report if it is run by the same parameters: Total By - Receipt - Number Receipt - Is Registered Type = Yes Post Date Range Reports > ...

    • Custom Query Reports Hub

      Custom Query Reports (CQR) Custom Encounter Query = CEQ Custom Receipt Query = CRQ Custom Transaction Query = CTQ Custom Patient Query = CPQ Custom Appointment Query = CAQ Overview Filters and Criteria Create a CQR CEQ CRQ CTQ CPQ CAQ Overview Custom ...

    • Custom Encounter Query (CEQ)

      The CEQ is a Custom Query that queries Encounter Data. Access the CEQ Report by selecting Reports on the left side menu. Select Custom Encounter Query in the Transactions panel. Build a Custom Encounter Query Filter Criteria: Add your filter criteria ...

    • Custom Appointment Query (CAQ)

      Custom Appointment Query (CAQ) The Custom Appointment Query (CAQ) report can be customized to query Appointment information. This report can be used for: A Scheduling List for the day, which gives more detail than the Appointment List Report; and A ...