How does conditional statement work on advanced query?

How does conditional statement work on advanced query?

  

I want to know how to use if and case statement in advanced query. I've been searching in outsystems community but I cant find anything related to my question. Thanks

Advance query is dependent on the database language syntax so fo sql server you could use case when

Karl Jarobe Bernardo wrote:

I want to know how to use if and case statement in advanced query. I've been searching in outsystems community but I cant find anything related to my question. Thanks

Hi Karl,

can you tell us more about what you want to achieve?


Cheers,

Julius


Hi Karl,

As mentioned by Eric, Advance query is dependent on the database language syntax.

Example:


Similarly, you can also use the If() in Advance SQL Query (in server action) without any changes in core sql syntax.

Hope it helps.


Kind Regards,

Benjith Sam