Expand my Community achievements bar.

Join us LIVE in San Francisco on November 14th for Experience Makers The Skill Exchange. Don't miss out on this free learning event!
SOLVED

Displaying attributes of custom typeahead field in a Workfront report

Avatar

Employee

I have a typeahead custom field (of type 'Project') defined in one of my custom form; custom form is attached to Issues. Name of project is "Resource By" in example below.

 

I want to create an issue report and display description and owner of the attached project on that issue report. When I try that, I am able to only display name of project, but cannot display anything else. See attached screen shot.
 
Name: (this works fine)
valuefield=Resource By:name
textmode=true
valueformat=customReferenceObjectAsString
displayname=Resource Project Description
 
 
Description: (this does not work)
valuefield=Resource By:description
textmode=true
valueformat=customReferenceObjectAsString
displayname=Resource Project Description
 
I tried a lot of other combinations (using valueexpression and other), but nothing worked.
 
Is that possible to show attributes of custom typeahead field in a report?
Topics

Topics help categorize Community content and increase your ability to discover relevant content.

1 Accepted Solution

Avatar

Correct answer by
Employee Advisor

This should work for the description field, I tried it on my end and was able to pull it in. 

Let me know if you run into any issues! 

displayname=Requested By Project Description
textmode=true
valueexpression={DE:Resource By:description}
valueformat=HTML

 

View solution in original post

8 Replies

Avatar

Community Advisor

I believe it's still not possible to show anything other than the ID and the name.

Avatar

Correct answer by
Employee Advisor

This should work for the description field, I tried it on my end and was able to pull it in. 

Let me know if you run into any issues! 

displayname=Requested By Project Description
textmode=true
valueexpression={DE:Resource By:description}
valueformat=HTML

 

Avatar

Employee

@NicholeVargas : This solves majority of my requirements, but I have one more requirement. Is it possible to show a custom field from that project? I have a custom field named "Engineering Manager". I tried following and it did not work.

 

displayname=Requested By Project Description
textmode=true
valueexpression={DE:Resource By:Engineering Manager}
valueformat=HTML

 

displayname=Requested By Project Description
textmode=true
valueexpression={DE:Resource By:DE:Engineering Manager}
valueformat=HTML

 

Avatar

Employee Advisor

Reporting on Typeahead fields in Workfront is fairly limited. You can pull in native fields using valueexpressions, but not custom fields, as far as I'm aware. I also connected with a few folks in Professional Services and they didn't think it was possible either. I have shared this feedback with the Workfront Product team for additional consideration as they are looking to improve reporting capabilities in the near future! 

Avatar

Level 7

We are still in need of the functionality to pull a custom field through a typeahead field into a report.  Any update from product as to when this will be available?