Custom Queries

Use this page to create and view custom SQL queries for enterprise reports.

• To view the details of an existing query, click the query name in the Custom Query List. The query displays in the Custom Query field below.

• To run the query, click the Run Query icon in the list.
• To delete the query, click the del icon in the list.
• To create a new query, enter the following information:
  • Query Name. Enter a name for the query.
  • Lock Query. Select this box if you want to ensure that nobody edits the query.
  • Team. From the drop-down list, select the team that is allowed to view and use the query.
  • Description. Enter a brief description of the query.
  • Custom Query. Enter the SQL query in this field.
• To save the query, click Save.