Scada-LTS
Scada-LTS copied to clipboard
Added Graphical Component 'Select SQL' for Other SQL Server
Expected Behavior
SQL component requirements:
- Possibility to connect to the Microsoft SQL Server database; (it will also be possible to connect to other SQL database servers)
- Ability to set and execute any select query;
- Possibility to filter records by date, regardless of other clients/application operators; (additionally, the ability to filter using a select query)
- The query result should be presented in the form of a table that dynamically adapts to the query result;
- The component should refresh its state itself at a set interval;
Additionally, it will be possible to set a limit for the query;
Added support for:
- [ ] PostgreSQL Server;
- [ ] Oracle SQL Server;
Linked: #2893
Specifications Scada-LTS Version: 2.7.7.3