Is there a way to fully display the Resolve Project Status (instead of the status abbreviation) in a combined column on an issue report?

[SLuna74]

We'd like to combine two data elements in a single column, displaying the Resolve Project Status.  In a combined column, the project status is abbreviated.  Can we override the abbreviation? 

 

Combined column text:

column.6.displayname=Status

column.6.llinkedname=

column.6.makeFieldEditable=false

column.6.namekeyargkey.0=resolveProject

column.6.namekeyargkey.1=status

column.6.querysort=resolveProject

column.6.sharecol=true

column.6.textmode=true

column.6.valueexpression=IF({resolvingObjCode}="PROJ",{resolveProject}.{status},"")

column.6.valuefield=resolveProject:status

column.6.valueformat=HTML

column.7.Column=Preview

column.7.sharecol=true

column.7.textmode=true

column.7.value=<br>

column.7.valueformat=HTML

column.7.width=1

column.8.displayname=Status

column.8.llinkedname=

column.8.makeFieldEditable=false

column.8.namekeyargkey.0=resolveProject

column.8.namekeyargkey.1=status

column.8.querysort=resolveProject

column.8.textmode=true

column.8.valueexpression=IF({resolvingObjCode}="PROJ","",{status})

column.8.valuefield=name

column.8.valueformat=HTML

 

[_Manish_Singh]

Hello @SLuna74 - I did not completely grasp the question, but if you are looking for the full status name, this might be helpful to you. I have modified few lines in column.6

column.6.displayname=Status
column.6.enumclass=com.attask.common.constants.ProjectStatusEnum
column.6.enumtype=PROJ
column.6.linkedname=resolveProject
column.6.makeFieldEditable=false
column.6.namekey=view.relatedcolumn
column.6.namekeyargkey.0=resolveProject
column.6.namekeyargkey.1=status
column.6.querysort=resolveProject:status
column.6.sharecol=true
column.6.textmode=true
column.6.type=enum
column.6.valueexpression=IF({resolvingObjCode}="PROJ",{resolveProject}.{status},"")
column.6.valueformat=HTML
column.7.Column=Preview
column.7.sharecol=true
column.7.textmode=true
column.7.value=<br>
column.7.valueformat=HTML
column.7.width=1
column.8.displayname=Status
column.8.llinkedname=
column.8.makeFieldEditable=false
column.8.namekeyargkey.0=resolveProject
column.8.namekeyargkey.1=status
column.8.querysort=resolveProject
column.8.textmode=true
column.8.valueexpression=IF({resolvingObjCode}="PROJ","",{status})
column.8.valuefield=name
column.8.valueformat=HTML

[SLuna74]

Thank you so much, Manish!

Right now, the combined field shows the project status abbreviated (CUR instead of CURRENT).  We're simply wanting the full status name displayed and not the abbreviation.

I used the updated column 6 information and the column still abbreviates the status name.  I'm wondering if that's forced by the combined field functionality and not editable.

[_Manish_Singh]

Hello @SLuna74 - Are you trying to combine Resolve Project:Status and Project Status of the issue into a single column?

If so, I'm getting the full name directly without using text mode. Combining the last two columns would also provide the full name.

[SLuna74]

We're trying to create a combined column to only show the project status when an issue is resolved by a project but show the issue status if the issue has not been converted to a project.

[_Manish_Singh]

Give this a try..

column.6.displayname=Combined Column
column.6.enumclass=com.attask.common.constants.OpTaskStatusEnum
column.6.enumtype=OPTASK
column.6.linkedname=direct
column.6.namekey=status
column.6.querysort=status
column.6.sharecol=true
column.6.textmode=true
column.6.type=enum
column.6.valueexpression=IF({resolvingObjCode}!="PROJ",{status},"")
column.6.valueformat=val
column.7.sharecol=true
column.7.textmode=true
column.7.value=<br>
column.7.valueformat=HTML
column.7.width=1
column.8.enumclass=com.attask.common.constants.ProjectStatusEnum
column.8.enumtype=PROJ
column.8.linkedname=resolveProject
column.8.namekey=view.relatedcolumn
column.8.namekeyargkey.0=resolveProject
column.8.namekeyargkey.1=status
column.8.querysort=resolveProject:status
column.8.textmode=true
column.8.type=enum
column.8.valueexpression=IF({resolvingObjCode}="PROJ",{resolveProject}.{status},"")
column.8.valueformat=val

Result:

1) show the issue status if the issue has not been converted to a project = New
2) show the project status when an issue is resolved by a project = Current

[SLuna74]

This is super close!  It's definitely listing out Project statuses completely but still abbreviates the resolving object status.  Is there a resolving object status reference we could make in the IF({resolvingObjCode}!="PROJ",{status},"")?

[_Manish_Singh]

At this stage, I am uncertain because the text mode worked correctly for me. However, it appears there is an issue with the last column (column 8 in your case). Column 6 seems fine.