How can I write JQL to select all subtasks whose parents in specific version, with also parents?

[Cheong sanghun]

Hi, What I want to do is write a jql query that,

selects every tasks in version 4.0(which is my project's specific fix version),

and also selects subtasks within it.

I need this query to select sub-tasks that isn't assigned for that version.

For example, task A's version is 4.0, and it's sub-tasks' version are not assigned, but I want to select these together.

How Can I write these JQL query?

[Tobias Rettensteiner · Accepted solution]

Hi @Cheong sanghun

try following JQL query:
fixVersion = 4.0 OR issueFunction in subtasksOf("\"fixVersion\" = 4.0")

Please let me know if this worked for you.

Kind regards,
Tobias

[Bill Sheboy]

Hi @Cheong sanghun and @Tobias Rettensteiner 

I believe the subtasksOf() function is only available in the purchased add-on ScriptRunner from the marketplace.

If you do not have a scripting add-on, I do not believe there is a way to perform that query with out-of-the-box Jira Cloud.

Best regards,

Bill

[Cheong sanghun]

Thanks for your comment, and @Bill Sheboy was right. I couldn't do it without additional plugin.

[Tobias Rettensteiner]

HI @Cheong sanghun  and @Bill Sheboy

sorry my fault, I didn´t know that this needs any plugin.

Why you don´t just add the fix version to the sub-tasks too, or isn´t this an option for you?

Regards,
Tobias

[Cheong sanghun]

@Tobias Rettensteiner Yep just changed from setting to inherit fix version from it's parent and it works! So problem solved, and again, thanks for the comments!

[Zoryana Bohutska _SaaSJet_]

Hi @Cheong sanghun 

As an alternative solution, you can try Dynamic Filter (developed by my SaaSJet team). It allows you to create requests without JQL. So you can filters issues by visual composer. 

1. Create Smart Field: field - fixVersion, operator - not equal, value - version 4.0

2. Create Dynamic filter using issue fields (select issue type, project, etc.) and created before Smart Field

Hope it helps.

Regards

[Earl McCutcheon]

Hello @Zoryana Bohutska _SaaSJet_ ,

Thanks for adding the information but also please take a moment to review the partner guidelines here.  Specifically noting the section "Identify yourself as a partner" :

Identify yourself as a partner: Make sure the user is aware you are affiliated with a partner company; for example, byplacing the name of your companyin your user name in {curly brackets} or -dashes- (note that regular brackets no longer work and have been automatically converted to dashes). If you are mentioning your own products or services, make sure you include wording to make it clear that you are affiliated with the company providing those products or services.

I see that you do appropriately indicate the affiliation to SaaSJet via your screen name and this is serving as a reminder that when offering products or services that you also "make sure you include wording to make it clear that you are affiliated with the company providing those products or services"

as an example rewording your comment as follows would be a perfect fix: 

.... As an alternative solution, The company I work for SaasJet makes the app  Dynamic Filter which you can try out ......

Regards,
Earl

[Zoryana Bohutska _SaaSJet_]

Hi @Earl McCutcheon 

Ok, thank you! I will edit my comment.