Task list in text mode | Community
Skip to main content
D
Dan-Ingham
April 13, 2022
Question

Task list in text mode

  • April 13, 2022
  • 4 replies
  • 1548 views

Hi I have a text mode for a field in view that gives me a list of all the tasks on the project with status

It seems to be ordering the tasks out of sync

Is there a way to sort by task number of task due date

As part of the concat formula I also want to include due date, but it pulls through as blank

Any help would be much appreciated

Textmode below with bold highlights of parts not working and attached picture of output

displayname=Tasks Names - % Complete - Due Date - Progress Status

listdelimiter=<p>

listmethod=nested(tasks).lists

querysort=task:dueDate

sortOrder=1

sortType=asc

textmode=true

type=iterate

valueexpression=IF({numberOfChildren}=0&&{status}='NEW',CONCAT("TO START - ",{name},' - ',{percentComplete},' - ',{dueDate},' - ',{progressStatus}),IF({numberOfChildren}=0&&{status}='INP',CONCAT("IN PROGRESS - ",{name},' - ',{percentComplete},' - ',{dueDate},' - ',{progressStatus}),IF({numberOfChildren}=0&&{status}='CPL',CONCAT("COMPLETE - ",{name},' - ',{percentComplete},' - ',{dueDate},' - ',{progressStatus}),IF({numberOfChildren}=0&&{status}='CPL:A',CONCAT("PENDING APPROVAL - ",{name},' - ',{percentComplete},' - ',{dueDate},' - ',{progressStatus}),IF({numberOfChildren}=0&&{status}='CPL:I',CONCAT("OPEN ISSUE - ",{name},' - ',{percentComplete},' - ',{dueDate},' - ',{progressStatus}),' ')))))

valueformat=HTML

Many thanks Dan

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

4 replies

imgrund
Adobe Employee
imgrundAdobe Employee
Adobe Employee
April 13, 2022

Hi Dan - at the moment, there isn't a way to sort a collection 😥

At my last agency, we worked with @Doug Den Hoed‚ and his Magic Reports tool so that we could get the collection to sort and to have conditional formatting.

D
Dan-InghamAuthor
April 14, 2022

Thanks for the info Anthony

much appreaciated

skyehansen
Community Advisor
skyehansenCommunity Advisor
Community Advisor
April 13, 2022

I'm wondering why you chose to use the "dueDate" field instead of "plannedCompletionDate". I've never seen dueDate used, have no idea what it does, and just was wondering if you would share a bit about what you use this field for and how you access it in Workfront.

D
Dan-InghamAuthor
April 14, 2022

Hi Skye

You are 100% correct i dont know why i had used dueDate

i changed to plannedCompletionDate instead to provide what i needed

Many thanks for the help

Doug_Den_Hoed__AtAppStore
Community Advisor
Doug_Den_Hoed__AtAppStoreCommunity Advisor
Community Advisor
April 14, 2022

Thanks for the tag, @Anthony Imgrund‚.

@Dan Ingham‚, what Anthony's referring to is our Hot Sheet solution, which efficiently distills your upcoming work down to those tasks planned to finish (or overdue) within the next 3, 4, or 5 business days across all projects, by every program within an entire portfolio.

👽 HOWEVER 👽

After Skye's tip and despite Anthony's assertion it is not possible (which is the case in my experience, too), can you confirm that your querysort trick:

querysort=task:plannedCompletionDate

DID INDEED allow you to sort a collection (as your screen shot seems to indicate)?

Regards,

Doug

D
Dan-InghamAuthor
April 19, 2022

Hi @Doug Den Hoed‚

Many thanks for the info just to confirm it didn't resolve the sort

querysort=task:plannedCompletionDate

Many thanks Dan

Doug_Den_Hoed__AtAppStore
Community Advisor
Doug_Den_Hoed__AtAppStoreCommunity Advisor
Community Advisor
April 19, 2022

Well, shucks, Dan.

That's unfortunate, but leaves my world view undisturbed. Thanks for confirming.

Regards,

Doug

Terms & ConditionsAccessibility statement

Loading footer...