Making an Aggregate out of a Variable

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,

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!

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. 


mvp_badge
MVP

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!

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.

Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.