Add option to pass in aggregate attribute as input parameter to the server action
370
Views
6
Comments
New
Aggregates & Queries

Add option to pass in aggregate attribute as input parameter to the server action  for calculated attributes.

Currently we are not allowing this functionality to extend its feature.


I'm not sure that's possible, as far as I can tell : 

Outsystems allows you use 2 different types of functions as calculated fields in an aggregate :

1) functions that are offered by the dbms, Outsystems can parse them into the to be executed sql, and so they can be executed by the dbms on the actual data, so you can refer to database fields in there

2) functions that are not offered by the dbms, so Outsystems executes these before executing the actual query, and uses the result of these as parameters into the sql to be executed.  Here you can use any server side function you like, including the ones you created yourself, but as they are executed before going to the dbms, you can't refer to values of individual rows. But all this really is, is a more compact way of calculating some stuff beforehand, and than using that as variable in your aggregate.  This is very compact and uncluttered and makes some level of preprocessing available to client side aggregates without needing some flow logic before it (i.e. without being forced to put it into a data action)

Your example above is of type 2

Thanks for your reply @Dorine Boudry 

Merged this idea with 'Add an option to regexSearch in this aggregate built-in text functions' (created on 27 Jun 2023 08:42:12 by aravind mani)

Add an option to RegexSearch in this aggregate built-in text functions.

It will be very very useful for most of the text level implementations.

For example, If I want to split an alphanumeric string into char and numbers separately.

Hi Aravind,

For me this is a double posting from your side. You already posted this idea but just more generic:

https://www.outsystems.com/ideas/13326/add-option-to-pass-in-aggregate-attribute-as-input-parameter-to-the-server-action/

Furthermore, I believe what you want is possible with Advanced SQL.

See: https://study.com/academy/lesson/regular-expressions-in-sql-server-databases-implementation-use.html

Advanced database query use cases are mostly covered by Advanced SQL.

Aggregates are good for all the lesser advanced topics.

Given this information, do you still find your idea valuable, or can I mark it as out of scope.

Regards,

Daniel

Thanks for the reply @Daniel Kuhlmann , You can make it out of scope. I'll make sure not to create any duplicates.