Table control - filtering historical data using a time picker

This article explains how to use local DateTime variables to filter historical data presented in a table and set the times using a user-friendly time picker in form of a calendar. The GraphWorX display used in the example is added as an attachment.

In GraphWorX, data presented in a Table control can be filtered using local variables. When presenting historical data, the most commonly used filter is limiting the Timestamp range, which can be done in the Filters tab of table settings like this:

To let the operator modify the time range in Runtime, the local variables can be connected to a Label with the TimeDate dynamic. Use the DateFormat and TimeFormat parameters of the dynamic to set the format you want:

Because the Picker parameter above is set to True, clicking on the control in Runtime will show a convenient calendar window to set the desired date and time:

You can also utilize buttons and expressions to set predefined time ranges, for example all data from today (the expression result needs to be a string):

• Related Articles

• Genesis V11 - list of built-in GraphWorX displays

  This article lists all the built-in GraphWorX displays available in the PubDisplay folder after GENESIS V11 installation. The display files are also attached as a backup for users. GENESIS V11 has multiple built-in GraphWorX displays already present ...

• Iconics Suite - Table control - Filtering data with Date Picker using DataSource parameter - solving Web Browser Date Picker incompatibility

  This sample Display (attached file) will show you how to proper use DataSource parameters on Data Base queries with Date Picker in GraphWorX64 and Web Browser (AnyGlass technology) The reason of this article is that Date Picker in Web Browsers ...

• Using Context Time variable to display data from the past

  This article explains how to use the Context Time variable available in Data Historian (or Hyper Historian in v. 10.x), so a GENESIS display can present data from a selected moment in the past. The display file and asset configuration used in the ...

• Iconics Suite - Universal sample Display to present Hyper Historian data

  This article contains sample GraphWorX Display which can be used with any Iconics project that use Hyper Historian. This sample let you display Hyper Historian data for any actual Hyper Historian tag in your project. Sample display view Sample ...

• Iconics Suite - Data storage in Hyper Historian Logger

  Summary: this document describes difference in setting in Hyper Historian Logger. Storage Limit Condition, Actions are described. Hyper Historian Logger - Delete Old Files First test was done using the 'Delete Old Files' option. Condition is Minimum ...