Automatic convert the result set of an aggregate into a structure
457
Views
2
Comments
New
Aggregates & Queries

Sometimes we group the values of an aggregate for project needs.

and it would be nice if we could extract the output of the aggregate and create automatically a structure with the output. Because sometimes we might need to send the result into an actions an do some logic. 

with this we would need to have to create an structure manually.

you can (kind of) already do this :

1) so after creating the aggregate : 

2) create a new local variable in the place where you have that aggregate, and for the datatype, choose a record or list of your aggregate output (in the suggestions)

I personally think, you can leave it at that, just use a record or record list matching the output, no need to really make a structure in most cases, as it will only have very limited usability outside the direct environment of this single aggregate.

3) but if you like you can then make a structure based on your local variable

4) and if you don't really need that local, delete it afterwards

5) now you can make for example output list of this structure 

Dorine

Yes, I understand that. It would do the trick. I was just think in a more direct way but like this is fine.

thanks. :)