Please explain a portion of this JQL search.

Fahad Akhtar

project in (GTSC-AAE-1) AND (Status in (New, "In Progress", Assigned) OR status = Closed AND resolved >= "2019/01/01" AND resolved <= "2019/03/31") ORDER BY status DESC, due DESC, cf[11400] ASC, cf[10404] ASC

 

Above is the JQL for searching for trouble tickets. I want to know what the last portion of the JQL means. The part that reads ORDER BY status DESC, due DESC, cf[11400] ASC, cf[10404] ASC. Please explain. Thank you.

Avinash Bhagawati _Appfire_

Hi @Fahad Akhtar ,

I'm splitting the query into pieces for better understanding.

ORDER BY status DESC - Gives issues in descending order of the statues. Done > In Progress > To- Done.

Let's assume this result in 30 Done issues , 10 In Progress and 20 To-Do issues.

ORDER BY status DESC, due DESC - This further sorts the issues with descending due dates.

Let's assume this sorts: First 30 Done issues in their due date descending order and same goes for other statues.

Out of 30 Done issues , 10 Done issue may have 15/11/2019 as due date and they appear on top , 10 issues may due date tomorrow ,they appear next and same goes on.

ORDER BY status DESC, due DESC, cf[11400] ASC: This again sorts out 10 Done issues with 15/11/2019 due date in ascending order of custom field values.

Let us assume - out of 10 Done issues with 15/11/2019 due date , 8 issues have custom field value A and they appear on top in this list.Same goes with other as well.

ORDER BY status DESC, due DESC, cf[11400] ASC, cf[10404] ASC: Again above 8 issues will be sorted with ascending order of custom field value and same goes for each status , due dates and custom field values.

Thanks,

Avinash