Performing a Generic SQL Query
- Go to Administration (Gears)
- Click Generic SQL
- Under Available Columns, click on the triangle to the left of Patient's folder
- Select PATIENTID then click the Add=> button to add it to the “Show These Columns”. Continue doing this with each of the columns to appear on the report.
- Click View Data and the View Data Screen will appear with the data. Click Save Data To File button at the bottom of the screen to save the information to disk.