JQL: How do I order by 1st value in a cascading select field?

Question

Dear All

Two questions:

1. How do I order by 1st value in a cascading select field? What is the correct syntax?

order by "Cascading list field" asc, issuekey asc, status DESC ?

2.  Why in this statement , ordering by issuekey and status is ignored ?

order by "Cascading list field" asc, issuekey asc, status DESC

Thank you

Zoryana Bohutska _SaaSJet_ · Answer

Hi @Rafal Sojka

Also, you can try Dynamic Filter add-on (created by my team). It lets you create filters without JQL. And you can order any field easily, just click on any column header and data will sort by it.

If you have any questions, let me know.

Regards.

Jack Brickey · Answer

You should be able to provide multiple orderby as conveyed. Can you provide your exact filter here? I just verified on case on my instance...

Project = car ORDER BY cf[12300] ASC, status desc

what are you experiencing exactly?