nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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?

Accepted answers

Tobias Rettensteiner

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

All comments

Tobias Rettensteiner

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

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

imgpsh_fullsize_anim (9).png

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

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"