Dynamic Sql Query Screen 2.0 - Overview (O11)

Stable version 2.0.1 (Compatible with OutSystems 11)

Other versions available for 10

Uploaded

on 27 Jan

5.0

(3 ratings)

Details

Component that makes use of AdvanceQuery forge component to make it possible to execute and query any eSpace table and see the results in the Screen. This component might be specially useful when it's not possible to have direct access to the database (Personal Environments).

DISCLAIMER: It is not recommended to keep this application active in a production environment. Despite the implemented security measures, including roles and logs, the application may still pose a risk to data integrity in a production environment.
###############################
Component that makes use of AdvanceQuery forge component to make it possible to execute and query any eSpace table and see the results in the Screen

Notice: This component takes advantage of private and undocumented Platform APIs, which can change without notice. As a result, this component may unexpectedly break as the Platform is upgraded. We advise proper testing to ensure that your applications continue to work as expected when upgrading/patching the Platform.

Release notes (2.0.1)

Release Notes - Version 2.0.1

In version 2.0.1, the application has been completely rebuilt, delivering significant improvements in usability, productivity, and security.

Below are the key highlights of this release:

Search and Filter Functionalities

Added a filter for selecting eSpaces and Entities.
Users can now search for both entities and their corresponding physical tables.
Implemented mandatory use of row limit in queries (configurable via site property).

New SQL Editor

Integrated a modern SQL editor powered by the CodeMirror library.
Result table with horizontal and vertical scrolling and fixed headers.
Added a splitter to dynamically adjust the size of the editor and results area according to user needs.

Operation Modes

Read-Only Mode: Allows only read queries and enforces the use of WITH(NOLOCK) to ensure data integrity.
Write Mode: Grants permission to perform write operations on the database.

User Experience Enhancements

Display of the number of rows returned and the execution time for queries.
Export query results to table, Excel, or JSON formats.
Detailed logging of all executed queries in a log table.
Reuse of previous logs: users can search and reuse previously executed queries.
Autocomplete functionality with support for all DDL, DQL, DML, DCL, and TCL commands available in the database.
Automatic suggestions for OutSystems physical tables based on the selected eSpace, with support for commands like FROM, INNER JOIN, LEFT JOIN, RIGHT JOIN, FULL JOIN, CROSS JOIN, and NATURAL JOIN during typing.