Scada-LTS icon indicating copy to clipboard operation
Scada-LTS copied to clipboard

Added Graphical Component 'Select SQL' for Other SQL Server

Open Limraj opened this issue 9 months ago • 0 comments

Expected Behavior

SQL component requirements:

  1. Possibility to connect to the Microsoft SQL Server database; (it will also be possible to connect to other SQL database servers)
  2. Ability to set and execute any select query;
  3. Possibility to filter records by date, regardless of other clients/application operators; (additionally, the ability to filter using a select query)
  4. The query result should be presented in the form of a table that dynamically adapts to the query result;
  5. 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

Limraj avatar May 23 '24 09:05 Limraj