Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Next challenges

Recent achievements

  • Global
  • Personal

Recognition

  • Give kudos
  • Received
  • Given

Leaderboard

  • Global

Trophy case

Kudos (beta program)

Kudos logo

You've been invited into the Kudos (beta program) private group. Chat with others in the program, or give feedback to Atlassian.

View group

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

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

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?

2 answers

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

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

Like # people like this

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

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

@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!

Like # people like this

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 Fieldimgpsh_fullsize_anim (10).png

Hope it helps.

Regards

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

Hi @Earl McCutcheon 

Ok, thank you! I will edit my comment.

Like Earl McCutcheon likes this

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
STANDARD
PERMISSIONS LEVEL
Site Admin
TAGS
Community showcase
Published in Marketplace Apps & Integrations

New Cloud Apps Roundup - Spring 2021

Atlassian's marketplace partners have had a very productive start to 2021! Since our last roundup, our developer community has added over 160 new cloud apps to the Atlassian Marketplace to help you...

118 views 3 14
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you