Sorted Grouping | Community
Skip to main content
N
NickVa7
Level 9
May 20, 2020
Solved

Sorted Grouping

  • May 20, 2020
  • 2 replies
  • 808 views

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

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

    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

    2 replies

    N
    NickVa7AuthorAccepted solution
    Level 9
    May 20, 2020

    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

    KristinFarwell
    Adobe Employee
    KristinFarwellAdobe Employee
    Adobe Employee
    May 20, 2020

    @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.

    Terms & ConditionsAccessibility statement

    Loading footer...