Can you sort so issues assigned to the current user appear first?

Question

I want to show users everything matching a certain criteria, but with their assigned issues first.

i.e. if JQL was SQL it would be something like:

... order by (when assignee = currentUser() then 1 else 0 end)

I looked at using a scripted JQL function with ScriptRunner, but they can't be used for ordering.

A custom field doesn't work for external dependencies like current user.

cloud-operations · Answer

JQL functions can't be used in sorting

Tarun Sapra · Answer

Hello @cloud-operations

As @Alexey Matveev has already shared that it's not supported out of the box.  Since, you have Script Runner plugin installed then you can explore option like writing a custom JQL function for your requirement.

Alexey Matveev · Answer

I do not think it is possible.