How to find issues with fully completed checklists via JQL?

Use case: as a Team Manager, I need to track the progress of compliance documentation within the company. Each issue in Jira represents a document that must go through a review process. The Checklist feature in STAGIL Tables is used to track different approval stages.

I want to find issues where all checklist items have been marked as completed, ensuring that a document has passed every required step before being considered finalised. How can I achieve that?

Solution

To find issues with tables where all checklist rows are checked, follow these steps:

Step 1: Create a Filter for Issues with Unchecked Items

1. Navigate to Jira > Filters > Create Filter.

2. Enter the following JQL query:

   "$Table Name_Columnname" = unchecked

   Replace $Table Name_Columnname with the actual name of your STAGIL Table along with a column name (Checklist).

3. Save the filter.

Step 2: Find Issues with Fully Completed Checklists

To filter for issues where all checklist items are checked, use the following JQL query:

Replace $Filter_Name with the name of the filter created in Step 1.