Hello, I have a variable that is structured like big table, I would like to create an aggregate out of that variable so I can manipulate it without using a thousand functions. Is there a way to do that?


Best,

Hi Vinicius,

When you say a variable it's data type is list of something right?

In that case, you can use ListFilter or some other actions from the System.

Solution

Vinicius Seixas wrote:

Hello, I have a variable that is structured like big table, I would like to create an aggregate out of that variable so I can manipulate it without using a thousand functions. Is there a way to do that?


Best,

Hi Vinicius,

I guess you want to manipulate a list like you do in an aggregate but without having to go to the database (you already have the list). As Nuno wrote, you can use the built-in actions. Or if you want something more complete, you can try this extension which enables you to use LINQ https://www.outsystems.com/forge/component-overview/1293/dynamic-linq


Cheers!

Solution

António Pereira wrote:

Vinicius Seixas wrote:

Hello, I have a variable that is structured like big table, I would like to create an aggregate out of that variable so I can manipulate it without using a thousand functions. Is there a way to do that?


Best,

Hi Vinicius,

I guess you want to manipulate a list like you do in an aggregate but without having to go to the database (you already have the list). As Nuno wrote, you can use the built-in actions. Or if you want something more complete, you can try this extension which enables you to use LINQ https://www.outsystems.com/forge/component-overview/1293/dynamic-linq


Cheers!

Is this using a query in a list? Like, I have a variable, and I would use a (query) to manipulate that variable?

Vinicius Seixas wrote:

António Pereira wrote:

Vinicius Seixas wrote:

Hello, I have a variable that is structured like big table, I would like to create an aggregate out of that variable so I can manipulate it without using a thousand functions. Is there a way to do that?


Best,

Hi Vinicius,

I guess you want to manipulate a list like you do in an aggregate but without having to go to the database (you already have the list). As Nuno wrote, you can use the built-in actions. Or if you want something more complete, you can try this extension which enables you to use LINQ https://www.outsystems.com/forge/component-overview/1293/dynamic-linq


Cheers!

Is this using a query in a list? Like, I have a variable, and I would use a (query) to manipulate that variable?

If you use the extension I shared with you can use a query-like syntax on your list like you would do with an advanced query. But try it and check if it covers your use case. 


So it wouldn't necessarily turn it into an aggregate, but it would give me the option to manipulate it. That's something at least. Thank you.