Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
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

JQL to search subtask and parent task from a project

Hi Team ,


I m trying to find JQL which help to extract all subtask with parent task from a Project . Please help me on this.

2 answers

0 votes
Daniel Ebers Community Leader Apr 24, 2021

Hi @sanjay_sapra

I had success why choosing the column "parent" prior to doing the CSV export:



Have to tried this already?


PS: I was testing in a company-managed software project but I don't see why it should be different for a team-managed project. Please check and let us know.

0 votes
Alexis Robert Community Leader Apr 14, 2021

Hi @sanjay_sapra , 


the following JQL will return all subtasks from project BUG that have a parent issue : 

project = BUG and parent is not EMPTY


Let me know if this helps, 



Thanks @Alexis Robert  its working partially for me . Because in output not able to get the parent id (Key number) and parent ticket not coming.

Attached o/p snap shot.output.JPG

Anyone help on above concern .

Suggest an answer

Log in or Sign up to answer
Community showcase
Published in Apps & Integrations

Marketplace Partner Spotlight: Fine Software

Happy New Year, everybody! What better way to kick off 2022 than with a new Marketplace Partner Spotlight ✨ This month, we're getting to know Daniel Franz, co-founder of Fine Software. Fine Software ...

417 views 2 15
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