Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

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

janakiraman P January 31, 2024

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

2 answers

1 accepted

1 vote
Answer accepted
Hannes Obweger - JXL for Jira
Atlassian Partner
January 31, 2024

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 hierarchiesissue 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:

regex-character-limit.gif

(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 February 1, 2024

Hi Hannes,

Thanks for your quick response.

Best,
JP

2 votes
Dan Breyen
Community Champion
January 31, 2024

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 February 1, 2024

Hi Breyen,

Thanks for your update on this.

Best,
JP

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
PREMIUM
TAGS
AUG Leaders

Atlassian Community Events