Skip to main content
D
DavidCo3
New Participant
February 8, 2019
Question

Collections and custom fields

  • February 8, 2019
  • 10 replies
  • 1741 views
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.

10 replies

D
DavidCo3Author
New Participant
February 15, 2019
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
The_Real_Melinda_Layten
The_Real_Melinda_Layten
New Participant
March 7, 2023

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!

    Doug_Den_Hoed__AtAppStore
    Doug_Den_Hoed__AtAppStore
    New Participant
    March 7, 2023


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

     

    Regards,

    Doug

    Doug_Den_Hoed__AtAppStore
    Doug_Den_Hoed__AtAppStore
    New Participant
    February 14, 2019
    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
    N
    NRYNR
    New Participant
    February 14, 2019
    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."
    D
    DavidCo3Author
    New Participant
    February 13, 2019
    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
    A
    Anonymous
    February 12, 2019
    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
    D
    DavidCo3Author
    New Participant
    February 11, 2019
    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
    N
    NRYNR
    New Participant
    February 8, 2019
    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
    D
    DavidCo3Author
    New Participant
    February 8, 2019
    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
    Doug_Den_Hoed__AtAppStore
    Doug_Den_Hoed__AtAppStore
    New Participant
    February 8, 2019
    ...perhaps valueexpression={successor}.{DE:custom field}....? Regards, Doug Doug Den Hoed - AtAppStore Got Skills? Lend a hand! https://community.workfront.com/participate/unanswered-threads
    Doug_Den_Hoed__AtAppStore
    Doug_Den_Hoed__AtAppStore
    New Participant
    February 8, 2019
    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
    Terms & ConditionsAccessibility statement

    Loading footer...