Wednesday, November 10, 2021

Combination of some fields in a formula where some fields are null

 If IsNull({X_MONEY_RECEIPTS_REP.ORDER_CODE}) Then

    {X_MONEY_RECEIPTS_REP.IDENTITY}

Else

    {X_MONEY_RECEIPTS_REP.IDENTITY}+" / "+{X_MONEY_RECEIPTS_REP.ORDER_CODE}

No comments:

Post a Comment

How to install and configure Oracle Apex 24.1 with ORDS 22, Tomcat 9 and Jasper Report 7 on Oracle Linux 8.10

#########################Install Oracle  APEX 24.1################################ ----------------------------------------------------...