Order By multiple fields only working for the first field
Mohammad Latifi
I'm New Here 
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
Hi,
I'm trying to sort my JQL query results based on 2 fields:
project = xxx and type not in (Epic,Subtask) and parent in (a,b,c,...) order by parent ASC,status ASC
The parent list is the list of epics (i.e. a,b,c,... are epics). The output of this query only sorts the tickets based on `parent` and does not do any sorting based on `status`. So I get all the tickets from parent `a` at the top but they are sorted based on `key` and not `status`. For example, the statuses are in this order: OPEN, CLOSED, READY, DONE, CLOSED, OPEN,... (See the following screenshot from tickets from the same epic)
When I switch the order of sorting fields (i.e. status first, parent second), the output is as expected. How come the initial sorting order doesn't work? Am I missing something or is this a bug in sorting?
Best,
Mohammad
1 answer
Mohammad Latifi
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.