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

[cloud-operations]

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.

[Alexey Matveev]

I do not think it is possible.

[Tarun Sapra]

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. 

[cloud-operations]

JQL functions can't be used in sorting