Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

JQL Filter- howto

Deleted user September 24, 2021

Hello,

Im trying to create a JQL Filter but need help with a column.

As you can see in the screenshot, we´ve got the field "Ist abgerechnet". This field has two options. Either you select "Yes" or "No".

So in my JQL Filter I want that only "No" is selected and it shouldn´t show the issues with "Yes".


Current Filter with "ist abgerechnet":

resolution = Unresolved AND status != Geschlossen ORDER BY project ASC, rank ASC, issuetype ASC, key ASC, created DESC


The field:

Screenshot 2021-09-24 161048.png


The JQL filter with that field (but without selection of Yes or No)

Screenshot 2021-09-24 161134.png

1 answer

0 votes
Jack Brickey
Community Champion
September 24, 2021

Hi @[deleted] , I’m not quite following you here. It sounds like you have a custom field that has a yes or no value and you want to exclude all issues that have yes in that field. Is that correct? Maybe the following is what you’re asking for?

resolution = Unresolved AND status != Geschlossen and "ist abgerechnet" = “no” ORDER BY project ASC, rank ASC, issuetype ASC, key ASC, created DESC

Deleted user September 27, 2021

No it did not work. It shows an error with the filter

Jack Brickey
Community Champion
September 27, 2021

please share the error you are receiving

Deleted user October 20, 2021

I have a custom field which I created in the Tempo Application for Jira. Now I want to retrieve the value of this field inside of a JQL filter. Is that possible?

Jack Brickey
Community Champion
October 20, 2021

I am unsure to be honest as I do not use Tempo. If you can reference within JQL then you can.

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
SERVER
TAGS
AUG Leaders

Atlassian Community Events