JQL

[Amar Bashir]

Is there a way to write JQL if i want to find out if my acceptance criteria is less than certain characters. I mean it not empty and have very little info. so i want all my AC to be at least 50 characters minimum and wan to write a query to display all stores with AC less than 50 characters 

[Jack Hunter _HeroCoders_]

Hi @Amar Bashir,

By using Issue Checklist Free app, you could ask Jira following JQL instead:

checklistItemsCount < 5

or 

activeChecklistItems > 0

 The first one returns all issues with less than 5 acceptance criteria items.

The second one returns all issue with non-completed acceptance criteria items. 

The JQL statements can include, of course, additional conditions like filtering by project, issue type, ordering, etc.

In case of any questions, we are happy to help. 

Cheers,
Jack

[Bill Sheboy]

Hi @Amar Bashir -- Welcome to the Atlassian Community!

Short answer: this is not possible with out-of-the-box Jira Cloud features of JQL

Longer answer:

First thing: the length of/number of characters in the acceptance criteria field may not reflect the quality of information.  Please consider how your team can meet your quality needs with improved team methods.

Regarding your measurement question: How often do you need to perform this check, and are you willing to spend money/time to solve it?

• Need this infrequently
  • Export the issues to a spreadsheet and perform the analysis there
• Need this often and willing to spend money to solve it
  • Investigate the marketplace to purchase JQL addons to support this need
• Need this often and not willing to spend money to solve it
  • Add a custom field for the length of the field, and create an automation rule to set the field.  You may then use built-in JQL features to perform the search...or better still add a quick filter to you board/backlog to see the issues during refinement.

Kind regards,
Bill