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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Online forums and learning are now in one easy-to-use experience.
By continuing, you accept the updated Community Terms of Use and acknowledge the Privacy Policy. Your public name, photo, and achievements may be publicly visible and available in search engines.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.