I want to filter out the issue that the "plan" item in my "develop" checklist is not checked.

Question

Hello, my name is Junhee Kim in South Korea.

I made my checklist named "develop" which has items like "plan", "develop", "test".

(I simplified items)

Then I want to filter out the issues that is unchecked to "plan" item.

So I used JQL like below. (Bold)

project = "PASSUP2024"

AND assignee IN (currentUser())

AND statusCategory IN ("To Do", "In Progress")

AND checklistItems ~ "plan"

ORDER BY created DESC

However, it only shows issues which has "plan" item in checklist.
Please let me know.. how to fix (or add) condition properly.

If I add condition like below, it is not working neither. (It shows the same issues like above)

AND "Checklist Progress" NOT IN ("DONE")

Please let me know.. how to fix (or add) condition properly.

Thank you so much!

Cristian0791 · Answer

Hi 김준희,

Are you using https://marketplace.atlassian.com/apps/1220209/issue-checklist-for-jira-free?hosting=cloud&tab=overview for checklist?

김준희_q3iay0 · Answer

I'm not sure how to use them (below)..

checklistItemsCount = 3 (total items count = 3)

"Checklist Progress %" = 25 (I checked 1 item for 4 items)

activeChecklistItems > 0 (unchecked item is over 0 count)

hasActiveChecklistItems IS NOT EMPTY ("has unchecked item" is true)

AND hasChecklistItems IS NOT EMPTY ("has unchecked item" is true)

김준희_q3iay0 · Answer

Hi, @Cristian Ionescu

It is not working as well. (This result also shows all)
Hmm..

Do you know how to use "Checklist Completed[Short text]" function..?

I have no idea how to use it.

Thank you for replying!