Order by when Filtering

[larias]

I'm tryin g to create a filter and have it Order By just story ID but it seems to order BY StoryID and all the sub tasks for that story.  Can I  do this?  Thanks. 

[John Funk]

Hi Iarias,

Can you share the filter you have built so far? And where it is not working as you intend it to?

[larias]

Hi John - Here's my filter.

status = "To Do" OR status = "In Progress" OR status = Resolved ORDER BY issuetype ASC

It's ordering by story first but when there's sub-task under the story it order the sub-tasks before the story. Thanks,

[John Funk]

It is going to order the issues alphabetically - so if the issuetype starts with a value that is after Sub-task (like Task), then it will put the sub-tasks first. You need to order by another field if you want a different result. 

[larias]

This is my result when I use the filter.

AS you can see the stories are out of order.

[John Funk]

you need to order by something other than Issue type

[larias]

Thanks John.  Ordering by something else won't give me filtering I'm looking for.  I guess its not doable what I'm trying to do.

[John Funk]

So what exactly is it that you want to see?

[larias]

I want to see all the SHPO-XXXX story in Ascending order regardless of the Task/sub-task.

[John Funk]

Do an ORDER BY KEY asc