search

SCADA-LTS / Scada-LTS

Scada-LTS is an Open Source, web-based, multi-platform solution for building your own SCADA (Supervisory Control and Data Acquisition) system.
GNU General Public License v2.0
727 stars 292 forks source link

Added Graphical Component 'Select SQL' for Other SQL Server #2894

Open Limraj opened 4 months ago

Limraj commented 4 months ago

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:

Linked:

2893

Specifications Scada-LTS Version: 2.7.7.3