Hello,
Can anyone help us how to find subtasks from a base query like "Approved" field without ScriptRunner?
JQL function 'subtaskissuesfromquery'
(Approved = user picker custom field ) in jira cloud.
Thanks,
Rahul
Hi @Rahul M
unfortunately, this is trickier than one might think; as a hierarchical query, it would really require some kind of join or subquery, which isn't available in plain Jira/JQL.
A few directions forward:
If you want to run your search dynamically, without manually stitching two queries together, you'll need extra tooling:
Hope this helps,
Best,
Hannes
Just to expand on the last point, this is how this would look in the app that my team and I are working on, JXL for Jira. Put simply, you'd create a sheet with all issues that are potentially relevant to you, enable the default issue hierarchy (that's just one click), and then use JXL filtering capabilities to narrow down to the issues that you care about:
(I'm using labels here, but it would work the same way with any other field.)
Once you have your list of issues, you can work on these directly in JXL (much like you'd do in e.g. Excel or Google Sheets), trigger various operations in Jira, or export them for further processing.
Any questions just let me know!
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.