Why is "STATUS" overruled by "ORDER BY" in JQL Filters?

[Anne Franzke]

For a Dashboard I am preparing some filters.

I noticed the following: 

project = "XXX" and Type = Epic and status != "Fertig" and Sprint = EMPTY --> Works as defined.

All unfinshed epics which are not planned in a sprint are shown. "Fertig" is a state coming from a self defined workflow and means "done" in German.

Finished epics are not shown. Exactly what I wanted.

Now I want to get more specific and sort the itmes by priority: 

project = "XXXX" and Type = Epic and status != "Fertig" and Sprint = EMPTY ORDER BY priority DESC

I noticed, that the Order BY overrules the status. All Done Items are shown again. 

Any solution for that?

[Bill Sheboy]

Hi @Anne Franzke -- Welcome to the Atlassian Community!

The ORDER BY clause should not impact the filtering for a dashboard gadget.

Which specific dashboard gadget are you using?  Please post images of the gadget display and of the settings of the gadget configuration.

Kind regards,
Bill

[Anne Franzke]

Hi @Bill Sheboy 

Thanks for your quick reply!

The issue is not caused by the dashboard, its caused by the filter itself. It occurs already in filter results.

Due to IP, I am unable to share screenshots since we are working in delevopment phase of an new product. 

Best regards

Anne 

[Bill Sheboy]

The only other things I can think of to check are:

• If you are using a marketplace addon gadget, perhaps check with the vendor
• If you are on Jira Cloud and the site was migrated from a Server / Data Center one, I have heard of problems with historical information impacting JQL searches

If it is neither of those cases, and you are on a paid Jira license, perhaps work with your Site Admin to submit a ticket to Atlassian Support for them to take a look: https://support.atlassian.com/contact/#/

When you hear back from them, please post what you learn to benefit the community.  Thanks!

[Anne Franzke]

Thank you @Bill Sheboy