Data Table

- PI Vision Widget -

Revision History

Revision No.	Date	Author	Document ID	Description of changes
10.1	January 2026	RS	EW_DataTable_v10.1	- Added a trailing zero as a parameter in config. - Added the ability to receive data as recorded and not interpolated in config. - Bugfix: the widget correctly generates the webId when created using pi points. - Bugfix: correctly generates the headers when downloading data as .csv and .xlxs - Bugfix for numbers displayed in the table. They are now displayed correctly based on the browser culture.
10.0	January 2026	RS	EW_DataTable_v10.0	Compatibility PIVision 2025, changed configOptions function functionality and changed colors selection visuals. supportsCollections setted to false.
9.3	October 2025	RS	EW_DataTable_v9.3	With the start date and end time set to the same date, the specific values of the attributes ​​are exported to the .csv .xlsx file.
9.2	June 2025	RS	EW_DataTable_v9.2	Added select REST provider
9.1	May 2025	RS	EW_DataTable_v9.1	Added feature Get Support
9.0	March 2025	AL	EW_DataTable_v9.0	Compatibility with PIVision 2024 and new widget style introduced
8.1	August 2023	MDC	EW_DataTable_v8.1	BugFix
8.0	August 2023	FM	EW_DataTable_v8.0	Compatibility PI Vision 2023
7.2	March 2023	MDC	EW_DataTable_v7.2	Added 1 month interval
7.1	October 2022	MDC	EW_DataTable_v7.1	English language default
7.0	August 2022	AM	EW_DataTable_v7.0	Compatibility PI Vision 2022
6.5	June 2022	MDC	EW_DataTable_v6.5	Label management improvement
6.4	April 2022	MDC	EW_DataTable_v6.4	WebAPI management on a different server
6.3	March 2022	MDC	EW_DataTable_v6.3	BugFix
6.2	March 2022	MDC	EW_DataTable_v6.2	Introduction of "Simple" and "Advanced" modes
6.1	November 2021	CC	EW_DataTable_v6.1	New features
6.0	October 2021	MDC	EW_DataTable_v6.0	Compatibility PI Vision 2021
5.2	July 2021	MDC	EW_DataTable_v5.2	Special characters management
5.1	April 2021	MDC	EW_DataTable_v5.1	BugFix
5.0	March 2021	MDC	EW_DataTable_v5.0	New graphic release and possibility to save a different time range
4.0	October 2020	OS	EW_DataTable_v4.0	Compatibility PI Vision 2020
2.3.1	August 2020	MDV	EW_DataTable_v2.3	Revision of documentation
2.3	December 2019	PC	EW_DataTable_v2.3	Support to data expiration
2.2	May 2019	PC	EW_DataTable_v2.2	Support to &, # and + in element name
2.1	March 2019	GI	EW_DataTable_v2.1	Restyle and revision of documentation
2.1	March 2018	GT	TQS_DataTable_v2.1	Modification of the installation procedure following the modification of the libraries used to download the data in Excel format
2.0.1	January 2018	PC	TQS_DataTable_v2.0.1	Review and add some configuration parameters
2.0	November 2017	GT	TQS_DataTable_v2.0	Restyle widget configuration; Change to the installation procedure
1.0	September 2017	GT	TQS_DataTable_v1.0	First version documentation

Document References

Document	Description
PI Vision Installation and Administration Guide	PI Vision™ user manual from AVEVA

Introduction

The EW Data Table widget displays sampled data in PI Vision, similar to the Sample Data function of PI Datalink, which shows data at regular time intervals starting from the current data in the archive over a time range independent of the display.

This widget lets you set the following parameters:

• Start Time (selectable with a calendar and a clock)
• End Time (selectable with a calendar and a clock)
• Interval (selectable via a combo box)

PI Vision from AVEVA , available since 2017, enables viewing real‑time data from the PI Data Archive and data organized in assets from the AVEVA Asset Framework (PI-AF).
To access PI Vision displays, navigate to:
https://webServer/PIVision (replace “webServer” with the correct name of the webserver machine)

The widget is supported by modern HTML5-compatible browsers on computers, tablets, and phones running Android and iOS.
Configuration is intuitive – simply drag and drop the control into the display.

Definitions, Acronyms And Abbreviations

Acronyms and definitions that are used in the current manual are listed below.

Term	Definition

Operating Principles And Use

To insert the Data Table, select the corresponding icon and navigate to the asset you want to view. Then, drag the control into the display area.

Figure 1 – Widget icon

When you release the mouse, the table is displayed with the same time range as the PI Vision display and an interval of 1 hour.

Figure 2 – Inserting the Data Table

By opening the contextual menu (right-click), further customizations and configurations are available.

Figure 3 – Contextual Menu

Functionality and use

To view the data, set the widget parameters:

• Start Time: selectable with a calendar and clock
• End Time: selectable with a calendar and clock
• Interval: selectable via a combo box

To apply the widget parameters is mandatory to confirm the selections with the provided button situated in the top right of the widget.

Figure 4 - Confirm selections button

The table displays the timestamp in the first column. Starting from the start time, each subsequent row adds the defined interval until reaching the end time.
Hovering over a column header displays the full context path of the data; clicking the “x” next to a header removes that column. Columns can be resized by dragging the right handle that appears between two columns. A vertical scroll bar appears if necessary.

Figure 5 – Data Table

The Download button lets you generate an XLSX or CSV file (as configured) with the table data. The file is automatically saved in your download folder with a name formatted as DataTable_YYYYMMDDhhmmss.

Using the button shown in Figure 5, you can sort the rows by time in ascending or descending order.

Figure 6 – Sort by time ascending/descending

Customization and configuration

The widget configuration allows you to change appearance elements such as colours, text size, and language.

Language

In the Language section, select the language for labels and configuration parameters.

Figure 7 – Language choice

Modality

The modality section allows the user to modify:

Figure 8 – Modality section

Mode:

• Simple mode: The table’s time range is directly linked to the display’s timebar; only the interval can be changed.
• Advanced mode: (Default) provides additional configuration options.

Figure 9 – Simple mode

Figure 10 - Advanced mode

Data retrieve mode:

• Interpolated (default): Retrieves data as interpolated between start time and end time with the specified interval.
• Recorded: Retrieves data as recorded. The data of the attributes are taken based on the timestamps of the first attribute present in the first column that is used to generate the table. In our case, the values for 3d_plot_y and 3d_plot_z, are taken based on the timestamps of 3d_plot_x.

Figure 11 - Data retrieved as recorded

If there is no recorded data for the selected attribute in the selected time range an alert will be present.

Figure 12 - No data found alert

If there are too many requests for the attributes in the table an alert will be present.

Figure 13 - High volume of data requested

Update Inverval:
The interval in seconds between each update of the data present in the table.

Format:
Choose the export format (XLSX or CSV) for the table data.
If the same Start and End Time are chosen for the export, the generated file will contain the punctual values of the datasources.

Figure 14 - Same start/end date

Figure 15 - Generated .csv file

Configurations

In the configuration section the user can modify:

Figure 16 – Configurations

• Server WebAPI: Specify the WebAPI server if it differs from the PI Vision server.
• Number of decimals: Customize the number of decimal places to display.
• Trailing zeros: If the number of decimals is more than 0 this option will appear. If checked, the values will have trailing zeros if the number of decimals does not match the number chosen in the number of decimals configuration. For example if the number of decimals is 3, the number 50,3, will become 50,300.
• Save interval in configuration: Select this option so that the widget is independent of the display’s time range; it will then use the dates defined in the widget.
• Show Element name: the name of the element containing the attribute will be displayed as the header of the table.
• Date format: Customize how timestamps are displayed in the table.
• Rest Provider: Allows the user to select between default or custom protocol for api requests.

Asset order

Allows the user to decide the assets order and the label to be displayed for said asset.

Figure 17 - Asset order

Appearance settings

In this section is possible to change the graphic settings of the widget for:

• Title;
• Title size;
• Title color;
• Text size;
• Table max height;
• Table header text color;
• Table header background color;
• Table text color;
• Table background color;
• Selected row color;
• Background color of the widget;
• Table borders color;

Figure 18 - Appearance Settings

Colors Selection

To select a color click on the color’s dropdown menu. The Gradient panel will open. From this panel the user can select which color, transparency or color format he wants. A second panel named Palette view is present if the user wants to select from a few pre-determined colors. Confirm with the button .

Figure 19 - Choice of color

Contacts

Get Support button (read Get Support documentation)

Link to e-matica.com (click on the icon)

Link to widget online documentation (click on link)

Figure 20 – Contacts

Installation

Requirements

In order to install the product, minimum requirements are listed in the table below:

Software	Version	Note
PI Vision	2025 (*)	Requirements are linked to the PI Vision correct functioning

Table 1 - Installation prerequisites

(*)This widget is also compatible with PI Vision 2024, 2023, 2022, 2021, 2020 and 2019.

We suggest using Google Chrome for full compatibility with the widget.

Installation procedure

Widget Installer

To install the widget’s files and common libraries using the widget installer follow the guide at this link:
https://documentation.e-matica.com/docs/WidgetInstaller.

Manual installation

The installation procedure includes a copy of the folders and files in the default path of the PI Vision.
In particular, it is necessary to copy the following files in the folder

...\PIPC\PIVision\Scripts\app\editor\symbols\ext

1. Copy Files:
   Copy the following files into the folder:
   ..\PIPC\PIVision\Scripts\app\editor\symbols\ext

   • sym-EWDataTable.js
   • sym-EWDataTable-config.html
   • sym-EWDataTable-template.html

2. Copy Folders:
   In the folder ..\PIPC\PIVision\Public, copy the following:

   • Images: Contains the control icon EWDataTable.png
   • Libs: Contains the libraries: EWClasses.js, moment.js, and xlsx.min.js

Notes And References

For more information about Vision PI refer to documentation on AVEVA © portal.
For information about the web service to refer to the specific documentation.