Return object fields for values in text mode | Community
Skip to main content
November 29, 2023
Solved

Return object fields for values in text mode

  • November 29, 2023
  • 1 reply
  • 771 views

I'm trying to create a report with a filter that shows tasks in projects with a custom field that pulls a group name in a portfolio's custom field. So basically it's [task's project's custom field from portfolio] = $$USER.homeGroupID. At last year's Adobe summit, someone shared how in text mode you can change the value of an expression to something specific so that when you return to standard mode it pulls up the full list of objects and values instead of just the single value field. Can anyone reshare that trick?

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 skyehansen

I think the trick you are talking about might be this one:

https://experienceleague.adobe.com/docs/workfront/using/reporting/reports/custom-view-samples/filter-items-by-comparing-two-fields.html?lang=en

 

(substituting a "FIELD:" in place of your temporary value, using text mode, and then switching back to standard mode -- or copy/pasting the example in the link above and putting it into your report and then switching back to standard, should help you understand how to use it)

 

I don't quite understand your first question though, so not sure what you're planning to do with the trick. 🙂

1 reply

skyehansen
Community Advisor and Adobe Champion
skyehansenCommunity Advisor and Adobe ChampionAccepted solution
November 30, 2023

I think the trick you are talking about might be this one:

https://experienceleague.adobe.com/docs/workfront/using/reporting/reports/custom-view-samples/filter-items-by-comparing-two-fields.html?lang=en

 

(substituting a "FIELD:" in place of your temporary value, using text mode, and then switching back to standard mode -- or copy/pasting the example in the link above and putting it into your report and then switching back to standard, should help you understand how to use it)

 

I don't quite understand your first question though, so not sure what you're planning to do with the trick. 🙂

December 5, 2023

Thanks, @skyehansen! That's exactly what I was looking for!