Retrieve the JIRA tickets where the Resolution Notes[Paragraph] field has fewer than 100 characte

[janakiraman P]

Hi All,

Using JQL, is there any possibility to retrieve the JIRA tickets where the Resolution Notes[Paragraph] field has fewer than 100 characters?

Am looking for a query like below.

`project = "P1" AND status in (Closed, Resolved, Cancelled) AND count("Resolution Notes[Paragraph]") <100`

Thanks,
JP

[Hannes Obweger - JXL for Jira · Accepted solution]

Hi @janakiraman P,

welcome to the community!

As already suggested, I'm afraid you'll need extra tooling for this. If you're open to solutions from the Atlassian Marketplace, this would be easy to do using the app that my team and I are working on, JXL for Jira.

JXL is a full-fledged spreadsheet/table view for your issues that allows viewing, inline-editing, sorting, and filtering by all your issue fields, much like you’d do in e.g. Excel or Google Sheets. It also comes with a number of advanced features, including support for (configurable) issue hierarchies, issue grouping by any issue field(s), sum-ups, or conditional formatting - as well as the ability to filter issues via regular expressions. 

With regular-expression-based filtering, you can apply pretty much any logic, including the one that you are after:

(I'm using the summary here but it works the same with any other field.)

The regex that I'm using is ^.{0,<character-count-upper-limit>}$, so for you this would be

^.{0,100}$

Once you've identified your issues, you can work on them directly in JXL (e.g., bulk edit them via copy/paste), or trigger various operations in Jira.

Any questions just let me know,

Best,

Hannes

[janakiraman P]

Hi Hannes,

Thanks for your quick response.

Best,
JP

[Dan Breyen]

Hi @janakiraman P welcome to the community.  I found this community article. query-to-check-if-the-length-of-the-text 

I haven't found a way to do this natively with JQL, but it looks like there are third party tools that may allow it.

[janakiraman P]

Hi Breyen,

Thanks for your update on this.

Best,
JP