DECODE function

[Anonymous]

Hello,
I would like to implement a decode function.
e.g.
DECODE (al1.dcf_status,
'PART RECEIVED', 'RECEIVED',
al1.dcf_status
)
when I define an expression like:
row1.DCF_STATUS =="PART RECEIVED"?"RECEIVED":row1.DCF_STATUS
it does not work.
Why?
Any ideas??
Thanks
Didier

[Anonymous]

Hello

row1.DCF_STATUS =="PART RECEIVED"?"RECEIVED":row1.DCF_STATUS

If the filed type is a String, change to the following expression:
row1.DCF_STATUS.equals("PART RECEIVED")?"RECEIVED":row1.DCF_STATUS
Best regards

shong

[Anonymous]

Is this syntax correct for 3 values:
row1.DCF_STATUS.equals("VERIFIED")?1 row1.DCF_STATUS.equals("CLOSED")?1 row1.DCF_STATUS.equals("RECEIVED")?1:0))
thanks
Didier

[Anonymous]

Hello

Is this syntax correct for 3 values:

Yes, you can
Best regards

shong

[DSingh1654264730]

Could you please​ tell me why we are using ( :row1.DCF_STATUS ) in last.