nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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

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?

Accepted answers

All comments

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

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

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!

Thank you @Bill Sheboy

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

unknown-hosting-type

jira-unknown-hosting-type