To edit the SQL source for a query:

  • Go to Admin > Developer Links > Schema Browser.
  • 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 (such as the trailing comma in the above source).
  • Return to the Data tab or click Execute Query again to see the revised results.
  • Click Save and Finish to save your changes when complete.


previousnext
 
expand allcollapse all