Skip to main content
DavidCo3
Level 10
Feb 8, 2019 4:12 AM UTC
Question

Collections and custom fields

OK - I'm pretty sure that I've asked this before but I just can't find any notes on this. The following collection works fine on an assignment report to give me the name of the successors task/s. listdelimiter= listmethod=nested(task.successors).lists name=Successor Task shortview=false textmode=true type=iterate valuefield=successor:name valueformat=HTML What actually I want to do is get data from a custom field. I guess it should be the following, but it doesn't work (blank results). I've tried swapping around the location of the DE and also putting in { } various places. Please tell me what I've done wrong! Thanks listdelimiter= listmethod=nested(task.successors).lists name=Successor Task shortview=false textmode=true type=iterate valuefield=DE:successor:customfieldname valueformat=HTML David Cornwell
This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

12 replies

Doug_Den_Hoed_AtAppStore
Community Advisor
Doug_Den_Hoed_AtAppStoreCommunity Advisor
Community Advisor
Feb 8, 2019 4:41 AM UTC
Hi David, The "https://community.workfront.com/discussions/community-home/digestviewer/viewthread?MessageKey=e7f72765-3f68-4648-a503-ba61f50ebc76&CommunityKey=aaafaff0-5e4e-4e38-8903-f1f990935567&tab=digestviewer#bme7f72765-3f68-4648-a503-ba61f50ebc76">last time we discussed this (albeit on predecessors), I apparently tried but conceded that I could not find a textmode solution to retrieve the custom data (LAZY READ); but if you find a way, good on yah. Regards, Doug Doug Den Hoed - AtAppStore Got Skills? Lend a hand! https://community.workfront.com/participate/unanswered-threads
Translate
Learn more at www.atappstore.com, email doug.denhoed@atappstore.com, or tag me here @Doug_Den_Hoed_AtAppStore.
Doug_Den_Hoed_AtAppStore
Community Advisor
Doug_Den_Hoed_AtAppStoreCommunity Advisor
Community Advisor
Feb 8, 2019 4:45 AM UTC
...perhaps valueexpression={successor}.{DE:custom field}....? Regards, Doug Doug Den Hoed - AtAppStore Got Skills? Lend a hand! https://community.workfront.com/participate/unanswered-threads
Translate
Learn more at www.atappstore.com, email doug.denhoed@atappstore.com, or tag me here @Doug_Den_Hoed_AtAppStore.
DavidCo3Author
Level 10
Feb 8, 2019 8:28 AM UTC
Thanks Doug, but unfortunately that doesn't work for me. I wonder if @Melinda Layten has a lightning bolt of insight on how I can get at the custom data on a referenced collection of successors? David Cornwell
Translate
NRYNR
Level 10
Feb 8, 2019 6:10 PM UTC
Hi David, Here's an example that works using a value expression. "https://wf-pro.com/textmode/text-mode-views-collections/#successors"> https://wf-pro.com/textmode/text-mode-views-collections/#successors I would imagine that{successor}.{DE:Field Name} would work in the expression to reference custom data. Narayan Raum "https://suntrustedo.my.workfront.com/dashboard/view?ID=5c1bf1f90046e70adeecf882731a47b9"> Workfront Center of Excellence Delivery Lead Enterprise Data & Governance Execution (EDGE) SunTrust Bank
Translate
DavidCo3Author
Level 10
Feb 11, 2019 3:15 AM UTC
Thanks Narayan - I can already get it to work for the successor task name (or other standard fields) but not custom data. Not sure if it is a limitation of the fact I'm accessing a collection on a referenced object (Task) from an Assignment report. David Cornwell
Translate
Anonymous
Feb 12, 2019 8:06 PM UTC
You shouldn't need the successors. since you are already on that object. Just the custom field name should work. Melinda Layten Technical Project Manager - API and Integration Workfront
Translate
DavidCo3Author
Level 10
Feb 13, 2019 2:09 AM UTC
Hi Melinda, Successors is the collection of successors, and I believe you do need to use successor to reference the fields in each successor. For example, the following successfully shows the name of the successor tasks. I just can't work out how to show custom data from the same task: listdelimiter= listmethod=nested(task.successors).lists name=Successor Task shortview=false textmode=true type=iterate valuefield=successor:name valueformat=HTML David Cornwell
Translate
NRYNR
Level 10
Feb 14, 2019 9:07 PM UTC
Hi David, Here's an example of loading "https://workfrontpro.com/textmode/text-mode-views-collections/#successors"> custom data on the successor task . Let me know how it goes. Thanks, Narayan Raum Delivery Lead, "https://suntrustedo.my.workfront.com/dashboard/view?ID=5c1bf1f90046e70adeecf882731a47b9"> Workfront Center of Excellence Enterprise Data & Governance Execution (EDGE), SunTrust Bank "Quickly and efficiently delivering digital solutions with real-time results to our partners."
Translate
Doug_Den_Hoed_AtAppStore
Community Advisor
Doug_Den_Hoed_AtAppStoreCommunity Advisor
Community Advisor
Feb 14, 2019 11:39 PM UTC
Well done Narayan! The key components of valueexpression, CONCAT, and the curly brace / DE: prefix / dot syntax you've presented in your example are worth studying. Regards, Doug Doug Den Hoed - AtAppStore Got Skills? Lend a hand! https://community.workfront.com/participate/unanswered-threads
Translate
Learn more at www.atappstore.com, email doug.denhoed@atappstore.com, or tag me here @Doug_Den_Hoed_AtAppStore.
DavidCo3Author
Level 10
Feb 15, 2019 2:38 AM UTC
Hi Narayan, In the end I realised that I had an error in an IF statement and this was preventing the data from showing because I already had the rest correct :D Your info was right for people running a task report. It might be worth adding another example for others who are referencing task successors from another object like an Assignment report like I was doing. If so, the listmethod line is: listmethod=nested(task.successors).lists Cheers David Cornwell
Translate
The_Real_Melinda_Layten
The_Real_Melinda_Layten
Level 3
Mar 7, 2023 2:45 PM UTC

OK, super late to the discussion but with type ahead fields I was doing a lot of testing and came up with this to show a custom field on a project at the Program Level

 

displayname=Sch Man ML
listdelimiter=‍
listmethod=nested(projects).lists
textmode=true
type=iterate
valueexpression=concat({DE:ET - Scheduling Manager:name})
valueformat=HTML

 

 

Same Melinda Layten - Now at  Freeman Company as a Workfront System Admin!

Translate
    Doug_Den_Hoed_AtAppStore
    Community Advisor
    Doug_Den_Hoed_AtAppStoreCommunity Advisor
    Community Advisor
    Mar 7, 2023 3:07 PM UTC


    Welcome back Melinda — we’ve missed you! I look forward to catching up.

     

    Regards,

    Doug

    Translate
    Learn more at www.atappstore.com, email doug.denhoed@atappstore.com, or tag me here @Doug_Den_Hoed_AtAppStore.
    Terms & ConditionsAccessibility statement

    Loading footer...