Idea - Add Data Type Editor to SQL (advanced) query output

Add Data Type Editor to SQL (advanced) query output

New

Aggregates & Queries

Can we have the Data Type Editor functionality inside the SQL query "Output Entities / Structures" folder, so we can cut down on useless (global) structures?

A lot of times, the eSpaces are full of structures named like IntegerValue, SomeColumns just to support some common sql output, needlessly littering the data type lists.

25 Jul 2018

Kilian Hekhuis

MVP

Good idea. Although the ability to have "local" structures would also improve this. I just don't think OS will ever implement that. :)

25 Jul 2018

Vasco Pessanha

Changed the category to

Aggregates & Queries

25 Jul 2018

PJ M

Create the structure automatically first, like this idea

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

THEN you can edit whatever it creates for you automatically. That'd be the best!

26 Jul 2018

Gonçalo Soares

One trick to avoid the "SomeColumns" structures that support a single query is to use multiple Outputs with proper names for context.

Still, I like both your idea and PJ M's linked idea better than this solution. It can quickly get complicated, particularly for queries with lots of columns, and referencing the results using "Query.List.Current.TextWrapper.Value" is annoying :-)

24 Nov 2019