Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
Community Members
Community Events
Community Groups

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? 


1 answer

1 accepted

1 vote
Answer accepted
Dirk Ronsmans Community Leader Aug 25, 2022

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

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? 

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))

Suggest an answer

Log in or Sign up to answer

Atlassian Community Events