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

JQL query incorrect

Yvonne van der Mooren

Hi all,

I'm trying to add The Two-Dimensional Filter Statistics gadget onto my dashboard. Therefore I need to create a JQL on my board. When entering the JQL code from the article into my quick filters:

sprint in (openSprints(), futureSprints()) AND project in (TIS)

i'm getting a The value 'TIS' does not exist for the field 'project' error.

I'm able to add my board name instead of TIS but it's not working.

What am I doing wrong?

Thanks!

Accepted answers

Dirk Ronsmans

Hi @Yvonne van der Mooren and welcome to the community!

The example you posted is based on the Demo environment. TIS is here the key of the "Teams In Space" project.

So you'll have to adapt that JQL using your Project name/key

All comments

Dirk Ronsmans

Hi @Yvonne van der Mooren and welcome to the community!

The example you posted is based on the Demo environment. TIS is here the key of the "Teams In Space" project.

So you'll have to adapt that JQL using your Project name/key

Yvonne van der Mooren

Thanks for your quick responds @Dirk Ronsmans When adding my project name it does work! But I'm also getting Assignee's in the list which are no longer active in Jira anymore or deleted from my board. How can I fix that?

Dirk Ronsmans

I'm not aware of a JQL that can get the state of a user.

If you also have the Scriptrunner app installed you that enriches your JQL and you could use

AND assignee not in inactiveUsers()

You might need to get a bit more creative with your JQL based perhaps on a Status of the issue? (especially regarding issues not on your board (anymore))

Yvonne van der Mooren

Thank you @Dirk Ronsmans

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

jql

filter

dashboard