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

Custom 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 Encounter Query (CEQ) Report

      The CEQ is a custom report/query tool that queries Encounter Data. Reports > Custom Encounter Query Build a Custom Encounter Query Filter Criteria: Add your filter criteria by clicking the Plus symbol beside "And". The filters you choose will ...
    • Create a Custom Query Report

      Create a Custom Query Report Select the Columns Choose the Columns to display on the Report Output. Select the Columns button. Enter search word(s) in the Search field; or Use the Plus symbols to open a specific category. Select the columns. As you ...
    • Custom Queries - Admin

      Custom Queries - Admin These are custom SQL queries that are written for clients to extract specific information to meet specific needs. There may be a charge for the creation of the Custom Query and will be presented to the client before starting ...
    • Custom Patient Query (CPQ)

      Custom Patient Query (CPQ) The Custom Patient Query report is located in the Patient panel on the Reports screen and is built by the User. The content of this report is Patient related. Demographic Filters Using the Demographic filters, a Patient ...
    • Custom Query Report/Table Filters and Criteria

      Custom Query Report/Table Filters and Criteria Custom Query Reports can be custom-built and the selected parameters can be Saved with the option to Share with other Users. With the ability to save and share, your preferred Reports are accessible ...