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
Views
Replies
Total Likes
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
Views
Replies
Total Likes
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,
Views
Replies
Total Likes
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
Views
Replies
Total Likes
Views
Replies
Total Likes
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.
Views
Replies
Total Likes