4
 Followers
20
 Likes

Automatic creation of structures when working with Advanced SQL Queries

Aggregates & Queries
On our radar

I can have an advanced SQL query that selects more than 10 columns, and maybe I would want only to test some behavior, and I cannot do so if I don't create a structure first. Then, if something changes (and it normally does) I have to go and edit the structure again. Structure creation should be automatically, based on the Advanced SQL Query output.

Created on 14 Oct 2016
Comments (7)
Merged this idea with 'Auto-create Output Entities / Structures for Custom SQL Statements' (created on 05 Jul 2018 15:12:17 by PJ M)

since you know which tables and fields are coming back for the SQL statement, you can automatically create the output structure for the SQL statement. If you don't know the type of data in a field, make it a TEXT type. But if I do something like this:

select {Car}.[Id] as CarId, {Owner}.[Id] as OwnerId from

{Car} inner join {Owner} on {Car}.[OwnerId] = {Owner}.[Id]


You know the structure will be like this:

CarOwner{

CarId: CarIdentifier,

OwnerId: OwnerIdentifier

}


OS doesn't need to make me manually create that structure and add it to the SQL Statement. This will save SOOO much time.



This comment was:
- originally posted on idea 'Auto-create Output Entities / Structures for Custom SQL Statements' (created on 05 Jul 2018 by PJ M)
- merged to idea 'Automatic creation of structures when working with Advanced SQL Queries' on 14 Sep 2018 08:47:16 by Vasco Pessanha

Changed the category to Aggregates & Queries




This comment was:
- originally posted on idea 'Auto-create Output Entities / Structures for Custom SQL Statements' (created on 05 Jul 2018 by PJ M)
- merged to idea 'Automatic creation of structures when working with Advanced SQL Queries' on 14 Sep 2018 08:47:16 by Vasco Pessanha

perhaps a duplicate of this idea https://www.outsystems.com/ideas/2682/Automatic+creation+of+structures+when+working+with+Advanced+SQL+Queries



This comment was:
- originally posted on idea 'Auto-create Output Entities / Structures for Custom SQL Statements' (created on 05 Jul 2018 by PJ M)
- merged to idea 'Automatic creation of structures when working with Advanced SQL Queries' on 14 Sep 2018 08:47:16 by Vasco Pessanha
Merged this idea with 'Advanced SQL Structure Suggestion' (created on 07 Sep 2018 06:25:58 by JitendraYadav)

This comment was:
- originally posted on idea 'Auto-create Output Entities / Structures for Custom SQL Statements' (created on 05 Jul 2018 by PJ M)
- merged to idea 'Automatic creation of structures when working with Advanced SQL Queries' on 14 Sep 2018 08:47:16 by Vasco Pessanha

Hi Team,


Please gives us option in advanced SQL to auto suggest/create relevant structure with the same definition.


Thanks!



This comment was:
- originally posted on idea 'Advanced SQL Structure Suggestion' (created on 07 Sep 2018 by JitendraYadav)
- merged to idea 'Auto-create Output Entities / Structures for Custom SQL Statements' on 14 Sep 2018 08:46:37 by Vasco Pessanha


This comment was:
- originally posted on idea 'Auto-create Output Entities / Structures for Custom SQL Statements' (created on 05 Jul 2018 by PJ M)
- merged to idea 'Automatic creation of structures when working with Advanced SQL Queries' on 14 Sep 2018 08:47:16 by Vasco Pessanha

Changed the category to Aggregates & Queries




This comment was:
- originally posted on idea 'Advanced SQL Structure Suggestion' (created on 07 Sep 2018 by JitendraYadav)
- merged to idea 'Auto-create Output Entities / Structures for Custom SQL Statements' on 14 Sep 2018 08:46:37 by Vasco Pessanha


This comment was:
- originally posted on idea 'Auto-create Output Entities / Structures for Custom SQL Statements' (created on 05 Jul 2018 by PJ M)
- merged to idea 'Automatic creation of structures when working with Advanced SQL Queries' on 14 Sep 2018 08:47:16 by Vasco Pessanha
views
558
Followers
4