JQL

[Aswathi D]

Hi ,
I need to know the JQL for whether a story ticket has subtask or not ..if yes ,check whether it has xyz ( field) = A and status = done

[Trudy Claspill · Accepted solution]

Hello @Aswathi D 

There is not a native JQL function for Jira Server/DC that lets you select parent issues based on whether or not they have subtasks.

Do you have any third party apps that extend JQL functionality? If not would it be possible for you to acquire one?

[Najm Polaris · Accepted solution]

Hi @Aswathi D

You cannot search if sub-tasks are present or not as mentioned by Trudy above, but you can do rest of the JQL and the sub-task you can have the sub-tasks column to view which issues have the sub-tasks. 

[Hannes Obweger - JXL for Jira]

Hi @Aswathi D

if you're open to solutions from the Atlassian Marketplace, this would be easy to do with 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 so-called "smart columns" that aren’t natively available, including the number of sub-tasks.

This is how it looks in action:

As you can see above, you can easily sort and filter by the number of sub-tasks. Once you've narrowed down your list of issues, you can work on your issues directly in JXL, trigger various operations in Jira, or export your issues with just one click. You can also use the column across JXL's advanced features, such as support for issue hierarchies, issue grouping, sum ups, and conditional-formatting.

Since you've tagged your question for Jira Server: As you may have heard, app sales have ended for Jira Server. Are you planning to migrate to Data Center or Cloud? I'd strongly recommend that. If you need some more time, JXL is perfectly compatible with Jira Server; it's just that we need to generate a license for you. If the above looks interesting, just let me know, and I'll happily start a free trial for you.

Best,

Hannes

[habib rahman]

Hi @Aswathi D My name is Habib, I will do my best to assist with the JQL:

---

The official Atlassian Jira documentation on JQL Functions: https://confluence.atlassian.com/jirasoftwarecloud/advanced-searching-functions-reference-764478339.html 

---

[Trudy Claspill]

@habib rahman 

The link you provided is for the Jira Cloud Advanced Searching Functions. The post is tagged as Jira Server.