Hello.. I am a new user. I don't know how to sort order using order by option of JQL in JIRA.

[Sadia Seraj]

All I know is ascending the issues with the word 'key'. But If i want to select a specific category such as bug, story or task. How to do that one?

[Craig Nodwell · Accepted solution]

Hi @Sadia Seraj welcome to the community.  To do that you would ORDER BY issueType ASC
You can also order by more than one column.
ORDER BY issueType,status ASC

[Sadia Seraj]

Thank you So much.

[Sadia Seraj]

Hello!! needed help.. I tried to import a space downloading all formats given such as XML, CSV, HTML etc. But nothing has worked for me. It keeps coming up with an error. How to resolve this issue? Please an expert suggestion required.

   

[Sadia Seraj]

@Trudy Claspill  please help me in this regard that I mentioned above.

[Trudy Claspill]

@Sadia Seraj 

That is an entirely different question than you original post and for a different product.

Please open a new question in the Confluence Questions community.

https://community.atlassian.com/t5/Confluence-questions/qa-p/confluence-questions

Include information about how you generated the export that you are trying to import. For example, did you export a space from a Confluence Cloud instance or a Confluence Server/Data Center instance?

[Couponzguru Ph]

In Jira, you can use the "order by" option in Jira Query Language (JQL) to sort the results of your query.

If you want to sort your issues by their priority in descending order, you can use the following JQL query:

project = "Your Project Name" ORDER BY priority DESC

This will retrieve all the issues from "Your Project Name" and sort them by priority in descending order. You can also use ASC for ascending order.

You can also sort by other fields such as issue key, summary, created date, etc. by using the "order by" option followed by the field name.

[Sadia Seraj]

[Trudy Claspill]

Hello @Sadia Seraj 

Welcome to the Atlassian community!

Bug, Story and Task are issue types. issueType is the field that hold this information for each issue so to sort based on that you would use

ORDER BY issueType ASC

Essentially you specify the field name that contains the data by which you want to sort, such as Type, Status, Key, Created, Resolved, etc.

You said you want to "select a specific category". Do you mean you want to limit the results of the filter, as opposed to getting all the issues and putting them in order based on that category? If you want to limit the results, then you need to add the field as a criteria of the filter like

issueType=Bug

You can learn more about how to use the filtering features in both Basic and Advanced modes from the documentation here:

https://support.atlassian.com/jira-software-cloud/docs/search-for-issues-in-jira/

You might also want to explore free training courses at https://university.atlassian.com

[Sadia Seraj]

Thank you so much . Can you answer this please?

[Sadia Seraj]

My question was do I have the option to choose specific category by opting any options from "order by"? or I can only sort the issue type? Specific category as in story, task or bug etc.

[Trudy Claspill]

Hello @Sadia Seraj 

That option is only for sorting the results.

If you want to limit the issues in the results to one or more issue types, you have to change the filter above that. To select multiple issue types you would change the filter like this

project=Project-C and issueType in (Bug, Story) order by issueType asc

[Sadia Seraj]

IT shows no matches. Am doing it the wrong way?

[Sadia Seraj]

And what this error is about? Why can't I create multiple issues?

[Trudy Claspill]

If you want to limit the issues in your results based on the issue type you need to change the filter, where the blue arrow is pointing.

Where you red arrow is pointing you can only select Field Names to use for sorting the results.

Your last post with the Create Multiple Issues screen is a completely different topic than your original question. Please start a new Question post for that and provide the details of what steps you are executing.

[Sadia Seraj]

Thank You. Can you please write me the prompt of the filter? How to write If I want to limit the issues to bug?

[Trudy Claspill]

I already provided two examples of that in previous responses.

 If you want to limit the results, then you need to add the field as a criteria of the filter like

and issueType=Bug

If you want to limit the issues in the results to one or more issue types, you have to change the filter above that. To select multiple issue types you would change the filter like this

project=Project-C and issueType in (Bug, Story) order by issueType asc

[Sadia Seraj]

I am sorry to bother you again. Do you mean to write the category of issue type in the search bar by "add the field as criteria"? If so I tried using various ways but it's responding as an error in the JQL query. I am attaching the screenshot again. I am slipping up would you mind sending an attachment or image in your reply? Thanks in advance.

[Trudy Claspill]

I provided a full example in my last response. It is the last thing in the response. The selection criteria all come before the ORDER BY clause and are joined together by logical operators such as AND and OR.

It appears that you are unfamiliar with how to create a filter with JQL syntax. I recommend that you try clicking on the "Switch to Basic" option on the right next to the JQL field. That will provide a different interface for constructing the filter that doesn't require you to type in JQL syntax.

I also strongly recommend that you take time to review the documentation in the link I provided in my first response. You need to spend some time educating yourself on the basics of creating filters to search for issues.