DESCRIPTION

This article is written with step-by-step Instructions to Apply the given SCRIPT in OPQuery (OPQUERY) program for the special or customised report.

NOTE: Please ask an Open Practice Admin user or check if you have access to the instructed programs.

STEPS TO FOLLOW

PART A | Copy/Paste Open Practice Support given script or query 

Select..

From..

Where.. 

PART B | Run the OPQuery

1. Go to Open Practice search bar (top find 🔍 icon)
2. Find OPQuery (OPQUERY) program 
3. Query Utility screen appears
4. Click on Clear button (Tool bar on top)
5. Copy the red written script in email (above)
6. Paste the given script in Query Statement field
7. Click on Execute button 
8. Report appears in Query Result field
    

NOTE: XXX indicates Unknown Value! Which means you need to add required value.
 

Example: Screenshot

 

Things To Know

1. Select = Choose Column/s
2. From = Choose Table/s
3. Where = Filter Row/s

*** Above instruction applied in Open Practice (OP) Version 8.6.0 ***

Please contact Open Practice Support Team, if above instruction does not resolve the issue:
Phone: 1300 366 002
Email:  opsupport@dyedurham.com

Related Article: OP OPQuery: How to export OPQuery report to MS Excel