Hi,

 some functions like Inverse Trigonometric functions are unable to execute in the database.

How can I use that in Aggregate?

Example:- ATAN2( x_num, y_num )


Thank you,

Nandini

These values are passed to function, will they be according to a query? Because in an Aggregate you can not use it. Do you need this for a filter?

You will have to either download a forge component which implements it, or you can write some C# extension yourself to expose these functions to outsystems.

Nandini T S wrote:

Hi,

 some functions like Inverse Trigonometric functions are unable to execute in the database.

How can I use that in Aggregate?

Example:- ATAN2( x_num, y_num )


Thank you,

Nandini

When the database you use already supports functions like that, you can resort to using an Advanced SQL instead of an Aggregate. E.g. 

SELECT ATAN2({Table}.[x_num],{Table}.[y_num]) FROM {Table} 



Hi Nandini T S,

You can try to see if your platform BD supports those operations, as Wouter Teensma suggested.

In case is not possible, you can simply use the methods of this forge component (as the Arctangent): https://www.outsystems.com/forge/component-overview/516/trigfunctions .

Regards,