How to use if else expression for oracle field

[SumanKoduri]

Hi,

I've a field in oracle if it is empty i need to assign 0 or field value 

I tried this if(empty(items('Apply_to_each_8')?['LOCK_ID']),0,items('Apply_to_each_8')?['LOCK_ID']) 

but it is not working properly, how to do that?

[SumanKoduri · Accepted solution]

@{if(empty(item()?['LOCK_ID']),0,int(item()?['LOCK_ID']))}

Done!!!

[alrez]

Hi,

Thanks for the follow up! Hopefully this can be helpful for future communities members.

Regards,

Alex

-------

Community Support Team _ Alex Rezac
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.