How to create complex Jira Search Query with given order of issues?

[alexxkey]

Hello guys,

I need to create complex Search query that should display issues with the following order, for example:

1. Only High and Highest priority bugs from project X

2. Then all issues from project Y with label "AA" and priority in (High, Highest)

3. Then all issues from project Z with label "AA" and priority in (High, Highest)

So I need to see in the search results the list of issues that order by rules described above.
Is it possible?

[edwin vasquez · Accepted solution]

Hello Alex,

See if this query does what you need. Let me know if it does or doesn't. Glad to help 

(priority in (High,Highest) and project = X) or (project = Y and labels = 'AA' and priority in (High,Highest)) or (project = Z and labels = 'AA' and priority in (High,Highest))

[edwin vasquez]

If the search results don't display as expected, I would also recommend creating a board and having each search be its own swimlane. This will display each of the queries you search for and may be easier to look at.

[edwin vasquez]

Did this answer your question? Please mark as answered if it did. 

[alexxkey]

Hi Edwin!

[alexxkey]

I can't sent long text (I don't know why), so I'm trying to attach the screenshot

[alexxkey]

So it would be good to have some kind of "THEN" operator (not only AND, OR) to create the strict order of issues for displaying in the search results, but there is no such an operator in JQL