Use user defined function in advance query

Use user defined function in advance query

  
Hi,
I need to use user defined function in advance query. Is there any way to do the same?

Regads,
sunil mane
Hello Sunil Mane,

First of all, welcome to our community..
Can you explain better what do you pretend to do?
What function are you talking and what do you need in that query.

Best Regards,
Gonçalo Martins
Sunil Mane wrote:
Hi,
I need to use user defined function in advance query. Is there any way to do the same?

Regads,
sunil mane
 
 Hello Sunil,

as Gonçalo said, if you could provide a little bit more info, it would help us helping you better. But if what you need is to use the result of an action, you can do it by using an Input Parameter (that will be used inside the query) and set the value of that input as the result of the action.

Hope that helps!

Cheers
Miguel
Sunil Mane wrote:
Hi,
I need to use user defined function in advance query. Is there any way to do the same?

Regads,
sunil mane
 
 Hello,

You cant use Outsystems actions inside Adv Querys because Adv Querys are based on SQL code.

You will have to convert it in SQL or use a for each after the query and then apply the action to each row/record or in last case create your own sql functions.
It may depends on the preformance you need.
Hello all,

You all explained very well almost all about this subject.
However we must know Sunil's real requirements to be able to explain what you need..

Best Regards,
Gonçalo Martins