Another idea... You could do a task report with Task Name, Task Description, and then have a third column display an Updates collection. Something like
displayname=Notes listdelimiter= listmethod=nested(updates).lists textmode=true type=iterate valuefield=message valueformat=HTML
However, to only show notes and not all updates, you'd need an IF statement where Update Type=Notes. Not quite sure how to do that though. Since we got this far, maybe the help desk can help you with the IF statement. ;)
I have followed your suggestion, and it includes all updates. However, I only really want to show Notes posted by the user - not including status updates etc.
I figure that there must be a way to filter it by update type. I have guessed and tried the following but this is not returning any results. Hoping you or someone else can advise what to do!
Thanks everyone for your suggestions.
Polly - that filter removed tasks where the only updates were status/general updates, however I still saw the updates inside the fields where there were multiple nested updates.
Doug - like the various combinations you tried, I also tried your suggestion with NO and it also came out blank.]
May end up logging this with support and see if they have any ideas.
I had the same problem and I opened a support ticket. Apparently, we cannot use filters or expressions for dynamic fields. Here is a response from the support team
This is advanced advanced reporting but if you install the add-on json in Chrome and then add attask/api-internal/metadata to the end of the workfront url you are given a list of the fields available in workfront. You can then navigate to task, since we are using a task report, then updates and it will tell you if it is dynamic or not. Here is a video of this: https://ilos.video/d0WeuZ .
Thank you, Sunil: that explains why we cannot filter on Updates in text mode. I appreciate now knowing the root cause, and having a tool I can use to definitively investigate such situations going forward.