Expand my Community achievements bar.

Join us LIVE in San Francisco on November 14th for Experience Makers The Skill Exchange. Don't miss out on this free learning event!

Text Mode Sorting Multiple Columns In Custom View

Avatar

Level 2

Hi all.

I can get my multiple column sorts to work fine in my associated report, but I can't seem to get them to sort properly in my initial view. I am trying to sort by three different columns. All three show the little sort icon when I'm in edit mode, but only the first sorted column actually seems to be sorting in the View (and it's the only one showing a sort "arrow" in the normal view). I'm fairly new to WorkFront, and definitely not an expert. Maybe one of you WF gurus on here can help me see what I'm missing.

Here is the textmode for my first sorted column (which seems to be working):

displayname=Risk/Issue

linkedname=direct

namekey=Risk or Issue

querysort=DE:Risk or Issue

row.0.styledef.applyallcases=true

row.0.styledef.case.0.comparison.icon=false

row.0.styledef.case.0.comparison.isrowcase=true

row.0.styledef.case.0.comparison.leftmethod=DE:Risk or Issue

row.0.styledef.case.0.comparison.lefttext=DE:Risk or Issue

row.0.styledef.case.0.comparison.operator=cieq

row.0.styledef.case.0.comparison.operatortype=string

row.0.styledef.case.0.comparison.righttext=Issue

row.0.styledef.case.0.comparison.trueproperty.0.name=fontstyle

row.0.styledef.case.0.comparison.trueproperty.0.value=bold

row.0.styledef.case.0.comparison.trueproperty.1.name=textcolor

row.0.styledef.case.0.comparison.trueproperty.1.value=0c6aca

row.0.styledef.case.0.comparison.trueproperty.2.name=bgcolor

row.0.styledef.case.0.comparison.trueproperty.2.value=feecc8

row.0.styledef.case.0.comparison.truetext=

sortOrder=1

sortType=asc

styledef.case.0.comparison.icon=false

styledef.case.0.comparison.isrowcase=true

styledef.case.0.comparison.leftmethod=DE:Risk or Issue

styledef.case.0.comparison.lefttext=DE:Risk or Issue

styledef.case.0.comparison.operator=cieq

styledef.case.0.comparison.operatortype=string

styledef.case.0.comparison.righttext=Issue

styledef.case.0.comparison.trueproperty.0.name=fontstyle

styledef.case.0.comparison.trueproperty.0.value=bold

styledef.case.0.comparison.trueproperty.1.name=textcolor

styledef.case.0.comparison.trueproperty.1.value=0c6aca

styledef.case.0.comparison.trueproperty.2.name=bgcolor

styledef.case.0.comparison.trueproperty.2.value=feecc8

styledef.case.0.comparison.truetext=

styledef.case.1.comparison.icon=false

styledef.case.1.comparison.leftmethod=DE:Risk or Issue

styledef.case.1.comparison.lefttext=DE:Risk or Issue

styledef.case.1.comparison.operator=cieq

styledef.case.1.comparison.operatortype=string

styledef.case.1.comparison.righttext=Risk

styledef.case.1.comparison.trueproperty.0.name=textcolor

styledef.case.1.comparison.trueproperty.0.value=03a219

styledef.case.1.comparison.trueproperty.1.name=fontstyle

styledef.case.1.comparison.trueproperty.1.value=bold

styledef.case.1.comparison.truetext=

textmode=true

usewidths=true

valuefield=Risk or Issue

valueformat=customDataLabelsAsString

width=100

Second sorted column (NOT working):

displayname=#

linkedname=direct

namekey=IIT Risk/Issue Priority

querysort=DE:IIT Risk/Issue Priority

sortOrder=2

sortType=asc

styledef.case.0.comparison.icon=false

styledef.case.0.comparison.leftmethod=DE:IIT Risk/Issue Priority

styledef.case.0.comparison.lefttext=DE:IIT Risk/Issue Priority

styledef.case.0.comparison.operator=notnull

styledef.case.0.comparison.operatortype=double

styledef.case.0.comparison.righttext=

styledef.case.0.comparison.trueproperty.0.name=fontstyle

styledef.case.0.comparison.trueproperty.0.value=bold

styledef.case.0.comparison.trueproperty.1.name=textcolor

styledef.case.0.comparison.trueproperty.1.value=0c6aca

styledef.case.0.comparison.trueproperty.2.name=align

styledef.case.0.comparison.trueproperty.2.value=center

styledef.case.0.comparison.truetext=

textmode=true

valuefield=IIT Risk/Issue Priority

valueformat=customNumberAsString

width=50

Third sorted column (NOT working):

linkedname=direct

namekey=Exposure

querysort=DE:Exposure

sortOrder=3

sortType=asc

styledef.case.0.comparison.icon=false

styledef.case.0.comparison.leftmethod=DE:Exposure

styledef.case.0.comparison.lefttext=DE:Exposure

styledef.case.0.comparison.operator=cieq

styledef.case.0.comparison.operatortype=string

styledef.case.0.comparison.righttext=Critical

styledef.case.0.comparison.trueproperty.0.name=fontstyle

styledef.case.0.comparison.trueproperty.0.value=bold

styledef.case.0.comparison.trueproperty.1.name=bgcolor

styledef.case.0.comparison.trueproperty.1.value=eac6c9

styledef.case.0.comparison.truetext=

styledef.case.1.comparison.icon=false

styledef.case.1.comparison.leftmethod=DE:Exposure

styledef.case.1.comparison.lefttext=DE:Exposure

styledef.case.1.comparison.operator=cieq

styledef.case.1.comparison.operatortype=string

styledef.case.1.comparison.righttext=Major

styledef.case.1.comparison.trueproperty.0.name=bgcolor

styledef.case.1.comparison.trueproperty.0.value=feecc8

styledef.case.1.comparison.truetext=

styledef.case.2.comparison.icon=false

styledef.case.2.comparison.leftmethod=DE:Exposure

styledef.case.2.comparison.lefttext=DE:Exposure

styledef.case.2.comparison.operator=cieq

styledef.case.2.comparison.operatortype=string

styledef.case.2.comparison.righttext=Moderate

styledef.case.2.comparison.trueproperty.0.name=bgcolor

styledef.case.2.comparison.trueproperty.0.value=e8f1ff

styledef.case.2.comparison.truetext=

textmode=true

valuefield=Exposure

valueformat=customDataLabelsAsString

width=100

5 Replies

Avatar

Community Advisor

Hi Nathan,

You have the right idea: what counts in getting a column to sort are (simply) these three properties:

querysort=DE:IIT Risk/Issue Priority

sortOrder=2

sortType=asc

That said, I believe that Sort only takes effect once the View is set in a Report at design time. If you're looking at a Report's results and then select a different View, all bets are off: all you can then do is click one column at a time to toggle its sorting, solo.

Regards,

Doug

Avatar

Level 2

Thank you, Doug!

I really appreciate your feedback.

Is there any way to sort three columns in a normal project view (not in a report)? That's the issue I seem to be having. Maybe it's not possible. I'm not sure what the limitations are on sorting. I can get the one column to sort, but not the other two (however, in the report they are sorting fine).

Thanks again,

Avatar

Community Advisor

Hi Nathan,

Alas, you are correct: there is no way to make a view sort on more than one column in a Project List. Instead, you must make a report, where you can then order by up to three columns, as we've discussed above.

Regards,

Doug

Avatar

Level 2
Thank you for your kind assistance! Nathan Roberts doTERRA

Avatar

Level 2

I am just trying to sort a View by 1 Grouping and 1 Sorted Column, but cannot seem to get it to work. Found this thread helpful, maybe there is help?

I found this original Reply helpful. I have a fairly simple Report/View with just 1 grouping. I then want to sort by 1 column within those groupings.

My order of operations was:

1) Set groupings in Report Builder mode‚ - I am grouping by "Project"

group.0.linkedname=project

group.0.namekey=view.relatedcolumn

group.0.namekeyargkey.0=project

group.0.namekeyargkey.1=name

group.0.valuefield=project:name

group.0.valueformat=string

textmode=true‚

2) Customize a View

2b) Add Text mode to that Column to drive the Sort - I want to sort by "Ordered Task Name Manual"

linkedname=direct

namekey=Ordered Task Name Manual

querysort=DE:Ordered Task Name Manual

sortOrder=1

sortType=asc

textmode=true

valuefield=Ordered Task Name Manual

valueformat=customDataLabelsAsString

3) Apply that View to the Report by Default

It just does not seem to be sorting by the Column, though.