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?
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.