Please ensure Javascript is enabled for purposes of website accessibility
Powered by Zoomin Software. For more details please contactZoomin

AVEVA™ Historian

Load a saved SQL query file

  • Last UpdatedJan 30, 2025
  • 1 minute read

You can load a saved SQL query file (.sql) and execute it against the database.

To execute a saved query

  1. In the Query Type list in the toolbar, click Favorites.

  2. In the Columns pane, click the Favorites tab.

  3. In the Favorite queries folder box, type the path to the query file. To browse to the folder, click the ellipsis button.

    All .sql files in the folder appear in the Favorite queries window.

  4. Select the query to execute in the window.

  5. To view the query, click the SQL tab in the Results pane.

  6. To view the results, click the Data tab in the Results pane.

TitleResults for “How to create a CRG?”Also Available in