Sorting in JIRA for google sheets

[Dariusz Dwornikowski]

Hi

I am using JIRA sheets plugin but I am experiencing some limitations to the sheets itself - like no ability to sort. With every sort - jira plugin somehow refreshes the order of isses to the initial one.  

This is the query I am usigng. 

=JIRA("project = KI AND issuetype = 'Feature idea' AND status = 'CAPTURED'", "issuekey, summary", 0, 250)

[Jack Brickey]

Hi @Dariusz Dwornikowski , I’m a bit confused by your JQL. If you paste that JQL into the advanced search is it valid? Here is what I find odd:

• The placement of “ before project and after captured
• everything after CAPTURED

Regarding sorting do you want to include Order By at the end of your JQL to attain the desired sorting? 

[Dariusz Dwornikowski]

The issues are downloaded so the query in Sheets plugin is ok. I just can't sort. 

[Jack Brickey]

Will the use of order by retain initial desired sorting? When you say you cannot sort do you mean you cannot use Sheets column sorting feature? I wonder what excel would yield?

[Dariusz Dwornikowski]

Order by and no order yields sam problem. I did not check excel becasue I need sheets (company policy ...). 

[Dariusz Dwornikowski]

How this works is this. When you sort - all columns besides the ones that JIRA() filled get sorted - the JIRA() imported fields "blink" and g back to the same order as they were before. Effect is that you end up in mess

[Jack Brickey]

Very strange. I think it would be good to report to Atlassian - https://support.atlassian.com/contact/#/