Skip to main content
LinnieCi
Level 4
April 27, 2020
Frage

Getting status name to display in valueexpression

  • April 27, 2020
  • 1 Antwort
  • 648 Ansichten

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!

    Dieses Thema wurde für Antworten geschlossen.

    1 Antwort

    SarahWilkersonCA
    SarahWilkersonCA
    Level 7
    July 15, 2022

    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

    Allgemeine NutzungsbedingungenAccessibility statement

    Loading footer...