Filter if checkbox content is closed

Tobias
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
August 11, 2020

I want to filter the tasks which have a checklist that is not completely closed. 

Is there a possibility to check if there is a field without a hook?

 

Thank you guys 

2 answers

1 accepted

1 vote
Answer accepted
Philipp Sendek
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
August 11, 2020

Hi Tobias,

unfortunately, JQL doesn't offer this functionality for the default check box fields.
You could also write a JQL that checks for all values and negate that clause.

However, if you're working heavily with checkboxes, you might want to consider using the Checklist for Jira App which offers additional functionality with the checkbox customfields.

And they also offer JQL functions to filter for completed or not completed lists:
https://okapya.atlassian.net/wiki/spaces/CHKDOC/pages/270565415/Searching+for+Checklists

Regards,
Philipp

(I'm not in any way related to the creators of the app, just use it on multiple instances and think it's a useful tool for this job)

Tobias
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
August 11, 2020

We use this add-on thank you for your answer. I think the function allItemsChecked() is the right one for my conditions

0 votes
Alina Kachan_Railsware_
Contributor
August 11, 2020

Hi @Tobias!

I wanted to mention that our app Smart Checklist for Jira can also give you the possibility to

- add interactive checklists to your Jira issues

- filter out issues that have incomplete checklists using JQL search 

Here's an article where you can check how it looks.

Cheers! 

Suggest an answer

Log in or Sign up to answer