Add "Store in Variable" as Context option for Aggregates/Advanced SQL


A lot of times I want to store the result of an aggregate into a variable. And most of the cases this aggregate has some joins resulting in a nice record. 

Currently to store the results you need to create a Structure with the same Entity definition and then create a variable with that structure as Data Type. This takes some time to create and this can easily be accelerated by Service Studio.

Please implement a "Store in Variable" option in the Context menu of an Aggregate/Advanced SQL and when selecting this option create a variable with the same definition as the selected Aggregate and place these in an Assign widget. It would also be perfect of any changes to the Aggregate would also result in definition changes of the variable/structure but that would a nice bonus. 

Created on 19 Dec 2019
Comments (0)