The Atlassian Community can help you and your team get more value out of Atlassian products and practices.
Hi all,
I'm using the Jira Cloud for Excel add-in to create a sheet of subtasks with worklogs attached to them. My current search looks like this, and returns almost everything I'm looking for:
JQL - issuetype in subtaskIssueTypes() AND worklogdate >= startOfYear()
Fields - Key, summary, logwork (seconds, name, started), Fusion Project, Issue Type, Parent, Project
What I'm now trying to achieve is to go "x" amount of levels upwards (linked issue > linked epic > linked project) and return any fields from those parents which aren't included on the subtask search...hope that makes sense! 😅
*Edit - What I've also resorted to doing is a duplicate sheet that has issuetype in standardIssueTypes() instead of subtaskissuetypes, and then doing some finicky xlookup returns between sheets, but I'm really hoping I can get rid of this step somehow
Hi @Ripley-Duggan, Christopher
welcome to the community!
This has come up a few times IIRC, and unfortunately, I don't think that "native" JQL can do that. You may have to copy the data from the parent issues to the respective sub-tasks, e.g. using Automation or Scriptrunner, or do the exact lookup trick that you mentioned.
Just as an alternative route: There's a number of more "hierarchy-focused" apps that can generate hierarchical views for you - not so much through "native" JQL, but through custom logic to resolve parent/child relationships. I know that Structure is very popular, and I myself work on an app named JXL for Jira.
I can, of course, only speak for JXL, but it feels like your use case could be quite elegantly solved using JXL. Here's how this would work:
This is how it looks in action (you can configure the fields to be shown):
As you can see, the parent data are "above" the child issue data, not in the same row. I understand from your post that you might want that. This is something we want to add in the future (but may be available in other apps; I'm not sure).
Hope this helps,
Hannes
@Hannes Obweger - Fine Software - JXL , just an FYI. You should not add a link to your website in accordance to the Community guidelines. It is ok to link to the Marketplace listing,
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Connect with like-minded Atlassian users at free events near you!
Find an eventConnect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.
Host an eventYou're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.