How to bring particular project results first others next in jql search results

Jira Development Jira Cloud
1

If I have 3 projects(project a, project b, project c), when I do search using jql, is there any way to get project b results first other results next?

2

While you can sort by project (based on project name):

order by project asc

I don’t think you can use custom sort order as in SQL:

SELECT * FROM Customers
ORDER BY case when country = 'P' then 1
              when country = 'A' then 2
              when country = 'L' then 3
              when country = 'H' then 4
              else 5
         end asc

But you can sort using custom field, so if you don’t mind adding a read-only and hidden custom field, setting its value according to project, then this will be your workaround.