Sort Report by Priority | Community
Skip to main content
Lawson02
Lawson02
Level 6
April 21, 2025
Solved

Sort Report by Priority

  • April 21, 2025
  • 2 replies
  • 705 views

I am trying to sort based on the priority column, how would I go about that? I am doing this on a task and issue report and have 2 ways to go about this. I can either sort the combined field Ex 1 or the hidden field Ex 2 but I don't know how to do either

 

Ex 1.

column.8.displayname=Priority
column.8.enumclass=com.attask.common.constants.TimelinePriorityEnum
column.8.enumtype=OPTASK
column.8.linkedname=opTask
column.8.namekey=view.relatedcolumn
column.8.namekeyargkey.0=opTask
column.8.namekeyargkey.1=priority
column.8.querysort=opTask:priority
column.8.sharecol=true
column.8.textmode=true
column.8.type=enum
column.8.valuefield=opTask:priority
column.8.valueformat=val
column.9.displayname=
column.9.enumclass=com.attask.common.constants.TimelinePriorityEnum
column.9.enumtype=TASK
column.9.linkedname=task
column.9.namekey=view.relatedcolumn
column.9.namekeyargkey.0=task
column.9.namekeyargkey.1=priority
column.9.querysort=task:priority
column.9.textmode=true
column.9.type=enum
column.9.valuefield=task:priority
column.9.valueformat=val

 

Ex 2.

displayname=Test
sortOrder=1
sortType=desc
valueexpression=NUMBER(IF(ISBLANK({opTaskID}), {task}.{priority}, {opTask}.{priority}))
valueformat=Int

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 skyehansen

There's no such thing as a "task and issue report" so judging by what you've attached, I'm wondering if maybe you're talking about an assignment report or a work item report. You appear to be trying to combine two different fields (request and task priority based on whether something is a request or task) and then sorting by the combined result of the two.

 

With this in mind, I don't believe you can sort by a valueexpression (ex 2 above). Nor do I believe that the two priorities can be somehow combined into one magnificent sort (assuming this is what you're going for in ex. 1 above). Best you would be able to do would be to put a sort order on your column 8 and column 9 and sort one set of priorities and then a second set.

 

I do see work items have their own priority -- I'm not sure if these are related to the task and issue priorities or to "My Priority" functionality but this is the only other thing I can think of, that you're trying for.

 

More clarification on your part might be helpful.

2 replies

skyehansen
Community Advisor and Adobe Champion
skyehansenCommunity Advisor and Adobe ChampionAccepted solution
April 21, 2025

There's no such thing as a "task and issue report" so judging by what you've attached, I'm wondering if maybe you're talking about an assignment report or a work item report. You appear to be trying to combine two different fields (request and task priority based on whether something is a request or task) and then sorting by the combined result of the two.

 

With this in mind, I don't believe you can sort by a valueexpression (ex 2 above). Nor do I believe that the two priorities can be somehow combined into one magnificent sort (assuming this is what you're going for in ex. 1 above). Best you would be able to do would be to put a sort order on your column 8 and column 9 and sort one set of priorities and then a second set.

 

I do see work items have their own priority -- I'm not sure if these are related to the task and issue priorities or to "My Priority" functionality but this is the only other thing I can think of, that you're trying for.

 

More clarification on your part might be helpful.

Lawson02
Lawson02Author
Level 6
April 21, 2025

Sorry I am still new to textmode reporting. Yes, I am using an assignment report to pull in either tasks or issues assigned to someone. I have figured out how to group them by priority but cannot get the groupings to sort from Critical - Low. I just tried "My Priority" and it does not relate to the Obj Priority. I do not want to sort by one then the other. If nobody has any marvelous ideas to add I will mark this as resolved as you pretty much answered my question. I was using a report from Report: combined task and issue View and Grouping 

skyehansen
Community Advisor and Adobe Champion
skyehansenCommunity Advisor and Adobe Champion
April 22, 2025

If you're only doing tasks or only doing issues and this is just for a specific individual, I think you should just group them (using the collapse option to group) and then show using the detail view. It gives the same effect as the grouping, but will sort correctly, which the summary page never seems to do.

Sven-iX
Community Advisor
Sven-iXCommunity Advisor
Community Advisor
April 22, 2025

Have you tried adding the sort arguments into column8? 

 

column.8.sortOrder=1
column.8.sortType=desc

Lawson02
Lawson02Author
Level 6
April 22, 2025

Yes I have tried using different variations of that with column.8 and column.9

Terms & ConditionsAccessibility statement

Loading footer...