SCV SQL Previewer

You can run SQL queries in the SCV database and preview the result.

To run adhoc queries on the SCV database:

  1. Select Utilities > SCV SQL Previewer.
  2. Specify the required SQL query.
  3. Select the Application variable to use only if the query contains application variable.
    Note: You can select the default System application variable or the Application variable for a specific cycle.
  4. Click Replace Variable to update the query and display the actual value of the variables.
  5. Click Execute to CSV. The results are downloaded as a CSV file.
Note: 
  • The number of records that are exported is limited to 300 to prevent performance issues.
  • The query execution time is limited to 10 minutes.