create filter for uncompleted checklist items

Question

Hi, I tried since a couple of weeks to get a report of all uncompleted checklist items of my team from all tasks on our Board, but it shows me also the completed items. How can I hide them or show only the unchecked?

The JQL query I used is:
project = "project" AND component = "component" AND summary ~ Batch AND Checklist < checklistCompletion("100", "uncompleted users") ORDER BY summary ASC

I tried also with itemsaerch and completion, but this also not work

I hope you can help me here.

Maxime Lefebvre _Okapya_ · Answer

Hi Thorsten,

The configuration I described for the Checklist Proxy would show a checklist with unchecked items.

Like I said, JQL will not filter items in your checklist column, it only filters which issues is shown in the result. Filtering with itemSearch("completion = false") you still see all items in the checklist, but you will only see the issues which their checklist is not fully checked.

The only way to achieve what you want (to only see unchecked items) is by configuring a Proxy. I suggest you to contact the Jira administrator in your team to help you setup your desired use case.

Regards,
Maxime

Thorsten Lai · Answer

Hi Maxime,

thanks for your reply, but I do not have access to the administration here. Also, I´m not interested in the percentage, it was only an option to get the items. What I need is to have an overview of all unchecked checklist items of all task which name contains "Batch". For checklist, I have the following options:

but no one fits for me and itemSearch("completion = false") also shows all items.

regards

Thorsten

Maxime Lefebvre _Okapya_ · Answer

Hi @Thorsten Lai

When you search issues using JQL, it only filters jira issues from the result. Your Checklist column will always show all items no matter what JQL query you supplied.

Think of it this way: "Show me all issues where the Checklist header X is not 100% completed". The result will show those issues and their respective checklists.

However, there is a possible solution to your use-case! If you create a checklist proxy field, and configure it to be of Proxy Type Checklist and Only Show Unchecked. You can then use that proxy as a column in your JQL result and it should only show unchecked items.

Regards,
Maxime