Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

SOLVED

Sorted Grouping

Avatar

Level 9

Hi folks,

I was struggling for a while to figure out how to apply some sort of order (sort) for groupings. My objective was to be able to group a task report by Planned Completion Date, and then ensure that the grouping was displayed in a logical sequence when the report was run (e.g. the oldest Planned Completion Date in the first grouping).

Here is the text mode snippet I used; however, you ALSO HAVE TO have the Planned Completion Date field as a column in your view, and it needs to be sorted (first, and ascending).

group.0.groupdatesby=DY

group.0.displayname=Due

group.0.notime=false

group.0.valuefield=plannedCompletionDate

group.0.valueformat=atDateAsDayString

group.0.namekey=plannedCompletionDate

group.0.linkedname=direct

Hope this helps others who have run into the same issue.

Cheers.

Nick

Topics

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

1 Accepted Solution

Avatar

Correct answer by
Level 9

Here is the text mode snippet I used; however, you ALSO HAVE TO have the Planned Completion Date field as a column in your view, and it needs to be sorted (first, and ascending).

group.0.groupdatesby=DY

group.0.displayname=Due

group.0.notime=false

group.0.valuefield=plannedCompletionDate

group.0.valueformat=atDateAsDayString

group.0.namekey=plannedCompletionDate

group.0.linkedname=direct

View solution in original post

2 Replies

Avatar

Correct answer by
Level 9

Here is the text mode snippet I used; however, you ALSO HAVE TO have the Planned Completion Date field as a column in your view, and it needs to be sorted (first, and ascending).

group.0.groupdatesby=DY

group.0.displayname=Due

group.0.notime=false

group.0.valuefield=plannedCompletionDate

group.0.valueformat=atDateAsDayString

group.0.namekey=plannedCompletionDate

group.0.linkedname=direct

Avatar

Employee

@Nick Valeriote‚ - This is so helpful! In case you hadn't seen it, we have a Virtual User Group coming up on the topic of Advanced Reporting on June 16. We're asking everyone who attends to bring a sample report or text mode solution. If your schedule allows, I'd love for you to attend and share! You can see the event details and registration info on the Events page here in Workfront One.