Report custom sort help using ValueExpression in Text Mode | Community
Skip to main content
A
AndrewFo2
New Participant
February 22, 2019
Solved

Report custom sort help using ValueExpression in Text Mode

  • February 22, 2019
  • 3 replies
  • 833 views

hello!

i am looking for help with my text mode work around for forcing a sorted order. The piece below populates the values on the report, but does not sort by them, and sorts by the original values. Any help would be great!

displayname=

enumclass=com.attask.common.constants.OpTaskStatusEnum

enumtype=OPTASK

linkedname=direct

name="status"

querysort=status

sortOrder=1

sortType=asc

textmode=true

type=enum

valueexpression=IF({status}="AIR","1",IF({status}="NEW","2",IF({status}="WKL","3",IF({status}="CFA","4",IF({status}="ASC","5",IF({status}="RLV","6",IF({status}="WTR","7",IF({status}="CLS","8",IF({status}="INP","9")))))))))

valueformat=val

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by Doug_Den_Hoed__AtAppStore

Hi Andrew,

You're on the right track with your formula, but in order to sort (or chart, etc.), the value in question needs to persist within the Workfront database. So, if you convert your formula into a calculated custom parameter, you can then refer to it directly in your view (even in graphic mode) and choose the sort option (technically, resulting in a valuefield instead of valueexpression under the hood).

Regards,

Doug

3 replies

Doug_Den_Hoed__AtAppStore
Doug_Den_Hoed__AtAppStore
New Participant
February 23, 2019

Ah! Pardon my presumption, Andrew, and welcome to the feast!

I'd recommend Creating Custom Forms as an appetizer, Using Calculated Custom Data as main course, then Creating a Report as dessert, savoring the "6. Sort" section of the latter, in particular.

Regards,

Doug

A
AndrewFo2Author
New Participant
February 22, 2019

Where do i add the calculated custom parameter? Into the Custom form or?

(I am new to WorkFront)

Thank you for your help!

Doug_Den_Hoed__AtAppStore
Doug_Den_Hoed__AtAppStoreAccepted solution
New Participant
February 22, 2019

Hi Andrew,

You're on the right track with your formula, but in order to sort (or chart, etc.), the value in question needs to persist within the Workfront database. So, if you convert your formula into a calculated custom parameter, you can then refer to it directly in your view (even in graphic mode) and choose the sort option (technically, resulting in a valuefield instead of valueexpression under the hood).

Regards,

Doug

Terms & ConditionsAccessibility statement

Loading footer...