Skip to main content
InSource Solutions

TN WIS104 How to create a filter in WIS

insource logo large.jpg

 

Description

This article will outline the steps necessary to create a filter in Wonderware Information Server (WIS)/(Suitevoyager).

 

  • Author: Lewis Talley
  • Published: 07/01/2015
  • Applies to: Suitevoyager, Wonderware Information Server (ALL)

 

 

Details

  1. Create a Query “MyCaptionsQuery” as follows:

SELECT 'Start Time' AS StartTime, 'End Time' AS EndTime

Step 1.png

 

2) Create a Query MyHistoryQuery as follows:

SELECT TagName, DateTime, Value

 FROM v_AnalogHistory

 WHERE TagName IN ('Systimesec')

 AND wwRetrievalMode = 'Delta'

 AND wwRowCount = 60

   AND DateTime >= '#StartTime#'

 AND DateTime <= '#EndTime#'

 

Step 2.png

 

3) Create the “destination” content unit.  This content unit “myHistoryContentUnit” will contain the query of data to which it is passed the parameters of the source content unit through the link that you will create:

Step 3.png

 This content unit contains no links and is a destination target which will be configured to show the data passed in as parameters.  A preview of this content unit should show the data which is hard coded in the query, and since we have default parameter values – should produce viable data – displayed as a table.

 

4) Create a link “myParameterLink”to the destination content unit as follows:

Step 4.png

 

5) Create a source content unit “mySourceContentUnit” which will contain the user input via a filter which will be linked to the destination content unit via the link.

Step 5.png