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

[준]

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!

[Hannes Obweger - JXL for Jira]

Hi @김준희

welcome to the community!

It looks like you might be using an app from the Atlassian Marketplace to manage your checklists, is this correct?

Mind sharing which app you are using?

Best,

Hannes

[준]

Hi, @Hannes Obweger - JXL for Jira 

I have to ask someone who has admin authority because I don't have.

I will let you know when I get this info..

Thank you for your answer!

[Cristian0791]

Hi 김준희,

Hope you are doing well.

Try: 

project = "PASSUP2024"

AND assignee IN (currentUser())

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

and activeChecklistItems > 0 and checklistItems ~ "plan"

[준]

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!

[준]

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)

[Cristian0791]

Hi 김준희,

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