Show generated SQL

You can view the SQL  code generated by a query.   

SQL = Structured Query Language is a programming language used to talk to databases. With SQL, you can store, manipulate, and retrieve data from relational databases. 

To view SQL code:

  1. At the Query Manager screen, after you've defined and run a query, click View, and then select one of the following options:
    1. Show SQL.  EmpowerHR displays the generated SQL in a raw form, without prompting for, and performing parameter substitution.
    2. Show SQL with Parameters.  EmpowerHR prompts you to enter parameters, and then displays the SQL with substituted parameters.
  2. To save the SQL script, at the SQL window, click File, and then select Write to File. 
  3. Save the file.

 


Next topic

Advanced query manager






© 2023 Fusion5. All rights reserved.