Sort Report by Priority

[Lawson02]

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

[skyehansen · Accepted solution]

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]

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]

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.

[Lawson02]

I am trying to mimic the sorting functionality of an external tool that we use to schedule tasks and issues.

[skyehansen]

totally get it -- misread your last reply thinking you were talking about task OR issues, two separate reports -- but you're talking about tasks or issues into one report, so -- unfortunately, my initial answer will still stand -- having both the tasks and issues in one report, they will still sort separately. I do not believe there's a way to get them to intersperse.

[Sven-iX]

Have you tried adding the sort arguments into column8? 

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

[Lawson02]

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