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; } } }

Two dimensional filter statistics gadget: drill down on Sprint doesn't work

Dave Edwards_tfok8s

I have a two dimensional filter statistics gadget with Priority on the X axis and Sprint on the Y axis. It works fine until I try to drill down on any of the numbers displayed. I get:

The operator '=' is not supported by the 'Sprint' field.

It seems the gadget isn't constructing the correct JQL for the drill down. Is this a bug or am I doing something wrong?

Accepted answers

All comments

Trudy P Claspill

Hello @Dave Edwards

Welcome to the community.

What is the JQL you have configured the gadget to use?

What is the JQL that displays when you try to drill down?

Are you applying this to a Company Managed project or a Team Managed project?

Dave Edwards_tfok8s

Thanks for the response. This is a Company Managed project. The JQL in the filter used by the gadget is:

project = GOLD AND issuetype in (Bug, Story) AND status in ("Status 1", "Status 2", "Status 3") AND labels = Prod_impact order by created DESC

The JQL generated by the drill down in the gadget is:

project = GOLD AND issuetype in (Bug, Story) AND status in ("Status 1", "Status 2", "Status 3") AND labels = Prod_impact AND Sprint = 784 AND priority = High

(The latter is what was generated by clicking on the number in the cell corresponding to a certain sprint and the "High" priority.)

Trudy P Claspill

Hm, that is very odd since the 'equals' operator is most definitely supported for the built-in Sprint field.

Do you happen to have more than one custom field named Sprint? Jira does allow for the creation of multiple custom fields with identical names. I'm wondering if the click-through filter might be picking up an alternate custom field also named Sprint.

Dave Edwards_tfok8s

I think you're onto something. When I enter raw JQL, autocomplete for Sprint shows two options: "cf[10003]" and "Sprint[short text]". The '=' operator works for cf[10003] but not for Sprint[short text].

That said, in project settings under issues->fields it only lists one Sprint field.

Any suggestions on how I can clean this up?

Welcome!

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

Quick Links

Find more posts tagged with

cloud

jira-software

jira-software-cloud