Expand my Community achievements bar.

The next phase for Workfront Community ideas is coming soon. Learn all about it in our blog!

Sorting a column that has nested list

Avatar

Level 4
Hi, I have a project report. A column has a nested list an the code reads: displayname=Submit to ICAD listdelimiter=‍ listmethod=nested(tasks).lists textmode=true type=iterate valueexpression=IF({name}="Submit to ICAD",{plannedCompletionDate}) valueformat=HTML Now, I need to sort the report by the date showing on this column. Is that possible? I tried adding: sortOrder=1 sortType=asc but is not working. I'm sure there is more I need. Has anyone done this before? Thanks!
Topics

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

2 Replies

Avatar

Level 6
Unfortunately, you cannot sort collections(nested lists). Nor can one apply conditional formatting or summarize any of the data with aggregators. This webinar from last week contained some pretty useful info on collections: http://lp.workfront.com/Collections?o=70160000000RLVQAA4&=#8232;&Last_Campaign__c=70160000000RLVQAA4 and this thread really helped me understand how to use collections correctly when I first ran into them: https://community.workfront.com/p/fo/st/topic=62&post=726#p726

Avatar

Level 4
Thank you Justin. This is very helpful, I will review.