Custom SQLs can be entered directly into an export to gather information from the ClockOn database tables. 

  1. Create an export using the add button from the Export list screen.  
  2. Specify the name and details required for the export.
  3. Click on Save
  4. Select the export from the list  
  5. Then click on the Custom SQL button.
  6. SQL statements can be entered directly into this screen and can also be run from this screen.  
  7. Click on the Run Command icon and the results will be displayed in the results tab when the run SQL button is selected.
  8. Click on Save