cancel
Showing results for 
Search instead for 
Did you mean: 

Document Status Name

kedalenechong
Participant
0 Kudos

Hi all

Is it possible to display in Query Document Status Name like in full instead of O and C?

Kedalene

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi,

yes it is possible through case Statement.

Try below for AR Invoice

Select OINV.DocNum,OINV.Docdate,OINV.CardCode,OINV.DocStatus,

Case when OINV.DocStatus = 'O' then 'Open'

When OINV.DocStatus = 'C' then 'Closed'

end as DocStatus

from OINV

Thanks,

Harshal

Answers (2)

Answers (2)

kothandaraman_nagarajan
Active Contributor
0 Kudos

Hi,

Yes it is possible using CASE statement.

Thanks

agustin_marcoscividanes
Active Contributor
0 Kudos

Hi

you can use the CASE clausule in your SELECT

CASE docStatus

WHEN 'O' THEN 'open'

WHEN 'C' THEN 'closed'

end as DocStatus         

Kind regards

Agustín Marcos Cividanes