Getting status name to display in valueexpression

[LinnieCi]

Hello,

I am creating an issue report with a column that should show resolving project's status name. If that does not exist, the issue's status should display instead. I got this to work, but the results show the status key (EX: CUR, CAN) instead of the actual status name that we associate with these keys.

displayname=Status

namekey=status

querysort=status

textmode=true

valueexpression=IF(ISBLANK({resolveProject}.{status}),{status},{resolveProject}.{status})

valueformat=HTML

Any insight on how to force this to show the status display name, instead of the status key, would be appreciated!

[SarahWilkersonCA]

I have the same question. On an HOURS report in one column, I want to show either project status or issue/request status in an IF valueexpression in a report column.

I know you can use ENUM to pull the status name instead of the acronym, but issue status & project status are 2 different enumclass & enumtype.

--------------------

Request Status

//working text mode

--------------------

enumclass=com.attask.common.constants.OpTaskStatusEnum

linkedname=opTask

namekey=view.relatedcolumn

namekeyargkey.0=opTask

namekeyargkey.1=status

querysort=opTask:status

textmode=false

type=enum

valuefield=opTask:status

valueformat=val

--------------------

Project Status

//working text mode

--------------------

valuefield=project:status

querysort=project:status

valueformat=val

displayname=

enumclass=com.attask.common.constants.ProjectStatusEnum

enumtype=PROJ

type=enum

linkedname=project

namekey=view.relatedcolumn

namekeyargkey.0=project

namekeyargkey.1=status

--------------------

IF statement, if task, show project's status else if request, show request status

//Works, but shows the acronym instead of the full status name ----- HOW DO I SHOW THE FULL STATUS NAME?

--------------------

displayname=Status

textmode=true

valueexpression=IF(ISBLANK({opTask}.{status}),{project}.{status},{opTask}.{status})

valueformat=val