Made with the HMIx AI Generator
This resource was created with AI on ai.hmix.tech. Describe what you need and generate your own HMI controls in minutes — free.
Custom Web Control
About SQL Query Table
SQL Query Table is a Custom Web Control for SCADA and HMI applications that displays the result of a SQL query as a read-only table. It provides a fixed column header, vertical and horizontal scrolling, and a row count chip in the title bar. The runtime script executes the query on each request, so operators always see current data directly on the screen.
Key Features
- Periodic refresh: Raises the QueryRequested event on start, whenever connectionString or query changes, and every refreshInterval seconds.
- Change highlighting: Cells whose values differ from the previous refresh are highlighted automatically, so operators spot process changes at a glance.
- Resilient error handling: Query errors appear in an inline band while the last valid data remains visible.
- Row count chip: Shows the number of returned rows in the title bar.
- Manual refresh: The refreshNow method triggers an immediate query and restarts the refresh timer.
Customization
All ten properties are set in the engineering tool and can be bound to PLC tags. The title property sets the title bar text, connectionString holds a DSN with a read-only user, and query defines the SQL statement. The refreshInterval property sets the period in seconds with a minimum of one second. The emptyMessage property is shown when a query returns no rows, and invalidFormatMessage reports malformed result data. The rowCountSuffix property sets the word displayed after the row count, and backgroundColor sets the control background. The resultData and errorMessage properties are written by the runtime script.
Use Cases
Ideal for production order lists, batch records, alarm history views, shift reports, and any operator screen that needs live database content alongside process graphics.
Compatibility
Works with WinCC Unified (TIA Portal) and WinCC V8. The runtime script that executes the query must be provided in the project, and the database must be reachable from the runtime server.
AI-Generated: This custom web control was automatically generated using AI. Please test and validate it before deploying in production environments.
⚠️ AI-Generated: This custom web control was automatically generated using AI technology. It may contain errors or unexpected behavior. Users are responsible for testing and validating before using in production environments.