Articles in this section

Standardized Stored Query Guidelines

  • Updated

Overview

New Stored Query

Modify an Existing Stored Query

Delete Stored Query

 

Overview

Welcome to Stored Query Development. This article will guide you on the steps after an approved workitem is assigned to you. 

All query development should be done in the DEV environment of Profile EMR.

There are different Stored Query request that are received: 

  1. New Stored Query
  2. Modify an Existing Stored Query
  3. Delete Stored Query

New Stored Query

  1. Log into DEV Env with your Support Analyst account. Select Z - DO NOT USE - IMITS POS. 
  2. Always start with the stored query template
    •  
      • In the top menu, click Report> Stored Queries
        Note: If you are not able to locate the query template, it can be imported from the workitem folder EMR-6778. Here is the link: \\vch\departments\PCAC_EMR\01 - PCCEMR\Work Items\00 - All Items (JIRA)\EMR-6778 Standardize Stored Queries\Dev (Jaffa)
  3. Right click on the Custom Stored Query Name and select Open from the dropdown
  4. Select Save button and rename the Stored Query 
  •  
    • Name: Follow existing naming conventions
    • Example: Active Clients with Active Problem by POS and Problem Code
    • Description: Add a brief description of the query and include user defined fields
    • Example: Shows active clients with active problem_ Enter POS and Problem Code
    • POS: Generally left blank (unless explicitly approved and documented on Jira)
    • Privacy: Left blank
  • Add to Where to Select segment as per requirements. Refer to the following helpfile Find Objects Query
  • Ensure that on the Output Tab the following header is present:
    NOTE: This is always yesterday’s data
    CONFIDENTIAL USE:  ALL VCH DATA MUST BE KEPT ON THE VCH NETWORK (NOT PERSONAL DEVICES OR C:DRIVES).  
  • Follow the usual Profile EMR Workflow 

 

Modify an Existing Stored Query

  1. Log into Support Env as Support Analyst account. Select Z - DO NOT USE - IMITS POS.
  2. Go to Report>Stored Queries and look for the query that requires to be updated
  3. Click on the Export query to disk file to export the ihq file to the workitem folder.
  4. Log into DEV Env with your Support Analyst account. Select Z - DO NOT USE - IMITS POS. 
  5. Go to Report>Stored Queries and click on Import query to disk file and select the previously saved out ihq file from the workitem folder 
  6. Update the query as per request
  7. Add columns from the custom stored query if not already part of the query
  8. Ensure that on the Output Tab the following header is present:
    NOTE: This is always yesterday’s data
    CONFIDENTIAL USE:  ALL VCH DATA MUST BE KEPT ON THE VCH NETWORK (NOT PERSONAL DEVICES OR C:DRIVES). 
  9. Follow the usual Profile EMR Workflow
  10. Use the Standard Query TestCase template: Validate Stored Queries - Base Test Case Template

 

Delete Stored Query

  1. Log into Support Env as Support Analyst account. Select Z - DO NOT USE - IMITS POS.
  2. Go to Report>Stored Queries and look for the query that requires to be updated
  3. Click on the Export query to disk file to export the ihq file to the workitem folder.
  4. Right-click and select Delete 
  5. "Do you want to delete the stored query "name of the query"? Window appears
  6. Click Yes to proceed
  7. Follow the usual Profile EMR Workflow