0
 Followers
11
 Likes

Using AGGREGATE result in another AGGREGATE

Aggregates & Queries
New

Something useful and necessary is using SELECT result in another SELECT.


Very common on major databases systems, the use of subqueries is a must have feature that Outsystems could take a moment to analyze and implement.


This could help implementing various complex situations and avoid the use of recordlists, structures and local variables.


Imagine: you are creating/editing an Aggregate and you can choose database entities and also another created and "same-scope" Aggregates to use in the joins.

Created on 19 Nov 2018
Comments (3)

Changed the category to Aggregates & Queries


I would love this to contain options like EXISTS and IN.

Currently if I want to achieve this I have to write advanced SQL.

views
174
Followers
0