Sorting on the Client or the Server

[Jay Jarman]

In SQL, if I add an Order By clause, the SQL server sorts the data before returning the result set.  In Jira, if I click on a filed heading, it adds an Order By clause to the JQL.  This isn't really sending the request back to the server just for sorting, is it?   Most data tools have functionality for sorting a result set on the Client separately from sorting on the server.  Does Jira have this capability?

[Alexey Matveev · Accepted solution]

Hello,

I just checked. Jira does send a request if you sort a jql result by clicking on a field heading.

[Jay Jarman]

First, how did you check?  I'd like to be able to see what and when it sends a request.

Second, is there a way to sort on the client?  Seems wasteful to send a bunch of requests if your user just wants to sort a few different ways.

[Alexey Matveev]

I opened the developer tools in my browser and had a look at the request, which is sent when I am clicking on a column header.

You can not sort it on the client. It is sent to the server.

[Ignacio Pulgar]

I think you may potentially order the results on a properly configured client, and not on all clients at once.

This would be kind-of a not very recommendable workaround that would work just for Chrome, but as it seems to be theoretically possible, I'll roughly describe the solution below:

1. Install User JavaScript and CSS extension on Chrome. It allows to inject your own JavaScript or CSS rules to any page.
2. Develop a solution which probably requires a good understanding of JavaScript, HTML and navigating & modifying the DOM.

Really cool things can be achieved by modifying the web page as it's being loaded, including but not limited to:

• Add new HTML elements or remove existing ones
• Create new client-side functionalities
• Modify the attributes of an HTML element as well as CSS being applied to it

Regards.

[Ignacio Pulgar]

ie: You may override the functionality of header's onClick() events so that they behave in a different manner, or add a button that ordered the displayed issues in a given manner.