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

    • 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 Transaction Query (CTQ)

      The Transaction Query Report is driven by the Posted Transactions. This Report will match the Payments & Adjustments Report if they are run by the same parameters. Transaction Query Report Criteria Reports > Custom Transaction Query (CTQ) Totals By: ...

    • 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 Query Reports Overview

      Custom Query Reports Overview Custom Query Reports can be custom-built to produce the output and columns you want specifically. A Default Report is System delivered for each Custom Query Report. They all operate in the same way but pull specific ...

    • Schedule Reports using the Job Scheduler

      Reports can be scheduled to run automatically. Date Span options allow for relative options, such as, Yesterday, Current Week, Previous Month, Period End, Previous X days, weeks, months, years, etc. For Example: If the report is set up to always run ...