This topic describes how to edit the SQL source for an existing query.

Permissions: To edit a custom SQL query, you must have both the "Editor" role (or higher) and one of the developer roles "Platform Developer" or "Trusted Analyst".

  • Go to (Admin) > Go To Module > Query.
  • Using the navigation tree on the left, browse to the target query and then click Edit Source.
  • The SQL source appears in the source editor.
  • Select the Data tab or click Execute Query to see the results.
  • Return to the Source tab to make your desired changes.
  • Clicking Save will check for syntax errors. If any are found, correct them and click Save again.
  • Return to the Data tab or click Execute Query again to see the revised results.
  • Click Save & Finish to save your changes when complete.

Related Topics

Was this content helpful?

Log in or register an account to provide feedback


previousnext
 
expand allcollapse all