Data Export

Process Vision provides comprehensive historical data query and export capabilities. Open it by clicking "History Query" in the main menu.

Query Methods

Query by Date Range

1. Set the "From" and "To" dates.
2. Use the quick buttons: "Today", "This Week", "This Month".
3. Optionally filter by a specific tag (e.g., Temperature.PV, Pressure.SV).
4. Set the result limit (default: 1,000 records).
5. Click "Query" to execute.

Query by Session

1. Enter a session code in the "Session Code" field.
2. Click "Search".
3. The system will load the complete process data for that session.
4. You can also select a previously recorded session from the dropdown.

Query Results

Results are displayed in a table with the following columns:

Column	Description
Timestamp	Time of recording
Tag Code	Data tag (e.g., Temperature.PV)
Value	Recorded value
Quality	Data quality

The bottom of the window shows query statistics: total records and query time.

Available Data Tags

Tag Code	Description
Temperature.PV	Temperature process value
Temperature.SV	Temperature set value
Temperature.Output	Temperature output percentage
Pressure.PV	Pressure process value
Pressure.SV	Pressure set value
Pressure.Output	Pressure output percentage
Process.State	Process state
Process.Progress	Process progress

Statistics

After running a query, the system calculates and displays statistics for the selected tag:

• Min: Minimum value
• Max: Maximum value
• Average: Mean value
• Standard Deviation: Statistical spread
• Count: Number of data points

Click "Refresh Statistics" to recalculate.

Chart View

1. After running a query, click "View Chart" to open the chart window.
2. The chart shows the time-series trend of query results.
3. You can show or hide individual tag data lines.
4. The chart header displays the data point count, start time, and end time.

Exporting Data

Export to CSV

1. After running a query, click "Export CSV".
2. Choose the save location and filename.
3. The CSV file can be opened with Excel or other spreadsheet software.

Export to Excel

1. After running a query, click "Export Excel".
2. Choose the save location and filename.
3. Exports as .xlsx format, directly openable in Excel.

Session Details

When viewing a specific session, the following information is available:

• Session code
• Recipe name used
• Operator name
• Start/End time
• Duration
• Final state
• Associated video file list

Clearing Filters

Click "Clear Filters" to reset all filter criteria to their default values.