Idea - Allow Mod() in an Aggregate

MVP

Allow Mod() in an Aggregate

New

Aggregates & Queries

If you try to use the Mod() (modulus operation, for taking the remainder) function in a Filter of an Aggregate, Service Studio gives an error:

"'Mod' function cannot be executed in the database, so it can't receive any attributes from the aggregate as parameter."

This is nonsense however, as Microsoft SQL Server has the corresponding "%" operator, and Oracle has a MOD() function, so both supported databases know how to perform a modulus operation just fine. Therefore, Mod() should be allowed in an aggregate.

02 Jun 2023

Lourenço Matalonga

I do agree with you on this point. It should definitely be supported. And it would help us , developers using the platform, massively.

Great idea. Would love to see this one implemented sooner than later.

Best regards,

Lourenco Matalonga

08 Jun 2023

Jean Bastos

Agree 100%

18 Jul 2023

Jervie Lazaro

Following this thread.

Agree 100%. Encountered this similar situation also today trying to compute value using this built-in function only to find out that this is not supported inside an aggregate.

Hope this function Mod() be considered available soon.

Thanks in advance!

07 Nov 2023

Alberto Ferreira

I fully agree. Aggregates need a revamp not only with concerns to buildin functions but also related to the use of IN clauses.

08 Nov 2023

Jervie Lazaro

Totally agree with the inclusion on IN clause in aggregates, hopefully this will be available soon. Big help for us developer if we can use and manage aggregates as freely as if we are creating a usual SQL query for in our traditional servers.

10 Nov 2023

Alberto Ferreira

Ok Lazaro, but I do not pretend with IN issue diverts attention from the subject of buildin functions.

Regards

10 Nov 2023

Kilian Hekhuis

MVP

Indeed, for IN we have this Idea, so let's keep the comments to Mod() only here :).

10 Nov 2023

Jervie Lazaro

Yes, totally agree Kilian, :)

Hope Mod() function be available real soon.

10 Nov 2023