Using Query Filters via Scripts

<< Click to Display Table of Contents >>

 

Using Query Filters via Scripts

To setup and confirm whether a Query is correct is only one of the steps to use it. Runtime usage and modifications on filter values for a Query can be checked in the next script. The SetVariableValue method is responsible for configuring a Query, according to values passed via script.

Set query = Screen.Item("E3Browser1").Item("Query1")
Query.SetVariableValue "IniDate", _
  Application.GetObject("Data.InternalTag1").Value
Query.SetVariableValue "FinalDate", _
  Application.GetObject("DataFH.InternalTag2").Value
Screen.Item("E3Browser1").Requery()

 

The Requery method allows new Query parameters to be really used, as a new Query is executed by respecting these new values.

Was this page useful?