Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

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

Open
2 tasks
Limraj opened this issue May 23, 2024 · 0 comments
Open
2 tasks

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

Limraj opened this issue May 23, 2024 · 0 comments
Assignees
Milestone

Comments

@Limraj
Copy link
Collaborator

Limraj commented May 23, 2024

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 Limraj added this to the 2.7.8 milestone May 23, 2024
@Limraj Limraj self-assigned this May 23, 2024
@Limraj Limraj modified the milestones: 2.7.8, 2.8.0 May 24, 2024
@Limraj Limraj modified the milestones: 2.8.0, 2.9.0 Jul 30, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

1 participant