TN HistClient116 How To save a Historian Client Query into favorites.

 

 

This Tech Note will walk you through creating a query in Historian Client Trend and then saving the query via a sql file into the Favorites are for future use. In this example we are going to generate a query on two tags named ReactTemp and ReactLevel for a 30 minute period then saving it as our Reactor query.

 

• Author: Alex Daevnport    
• Published: 12/18/2015
• Applies to: Historian Client

 

 

 

1 Open your Historian Client Query via Start - All Programs - Wonderware  - Historian Client. Select the tags from the Tag Picker that you wish to use in your query. In this example ReactTemp and ReactLevel have been selected.

 

 

2 Click on Query Type and select History values as seen below.

 

 

3 Select which columns you wish to display by checking/unchecking the relevant boxes. As yo make the selection the Results will update.

 

 

4 Click on the Time Tab and click on the middle Time column and select 30 minutes.

 

 

5 In this example (optional) you can select the Format Tab and Wide Query Format.

 

 

6 Once finished with the options you wish to select click on the SQL Tab in the Results Tab.

 

 

7 Click on File - Save then name the SQL Query as appropriate. In this case it's been named Reactor.sql and keep this at the default location. Click the Save button.

 

 

 

8 Click on the Query type option and select Favorites. The query you saved will now be available to use or even edit further.

 

 

9 Click on the Query you saved and the Data Tab the data for that moment will now be displayed.