Expand my Community achievements bar.

SOLVED

Return object fields for values in text mode

Avatar

Level 1

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?

Topics

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

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

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...

 

(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.

View solution in original post

2 Replies

Avatar

Correct answer by
Community Advisor

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...

 

(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.