Sorting in JIRA for google sheets

Question

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 · Answer

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

Dariusz Dwornikowski · Answer

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

Dariusz Dwornikowski · Answer

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