Create
cancel
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

Structure - how can I display parent value in a sub-task?

Hi,

Thanks in advance for any tips.

Use Case:

Parent EpicA

  --> Sub-Task1

  --> Sub-Task2

In Structure, I only want to show a list of my Sub-Tasks (I query all Epics, but I filter out so that I only see a list of sub-tasks).  
I want to have a column that displays a value pulled from the parent, ex: "Theme" Field. 

ex: Sub-task1  |  "Theme"

I tried using PARENT{value} and PARENT#level but it doesn't pull the value, unless I have the parent Epic in the hierarchy view.


Any tips that can solve this?  preferably without having to use custom scripts :) 

 

3 answers

1 accepted

0 votes
Answer accepted
Fabian Lim Community Leader Jun 03, 2021

Hi Lenny,

You will need to the following:

1. Insert Issues: Insert -> JQL Query and enter the query to get the epics

2. Then Extend -> Sub-tasks and select subtasks type you want to display

Thanks @Fabian Lim  - i am trying 'not' to show the Epics, but only the flat-list of sub-tasks. I can achieve this by filtering out the Epics, but then i lose the ability to pull the PARENT{} value.  That's what i was trying to solve :) 

Like Stan D_lonce likes this

Hi Lenny,

unfortunately this is not possible in Structure currently.  If you want to use the PARENT{} function you will need the item to be present in the board, as a parent of the issue.

However, this will be possible with the release of EXPR 2.0, which should be available by the end of the month.

Cheers,
Nick
[ALM Workds]

Like # people like this

@Nicholas Alexander Ellis - that's great to hear!  looking forward to its release! 

Hi, @Lenny. FYI, Structure 7.0, which includes Expr 2.0, was released earlier this week. 

Reach out to us via structure@almworks.com if you have any questions or need any assistance with the new capabilities. 

-dave [ALM Works]      

Like # people like this

@Dave Rosenlund _ALM Works_  - that's great news! thanks for letting us know. can't wait to try it out :) 

Like # people like this

@Lenny and @Stan D_lonce: Related to this thread... In case you haven't already heard, you may be interested in the Structure 7 / Expr 2 Bootcamp.

Best,

-dave 

Thank you! I already signed up, thanks

Hi, @Lenny.  First, let's confirm your platform?  Your post is tagged "cloud" but you appear to be trying to use an Expr aggregate function.

Expr is the scripting language (you said you didn't want to use scripts) of Structure Formulas. Structure Formulas are not available in the cloud edition of Structure at this time.

Is there any chance you are using the Data Center version of Jira (and Structure)?

-dave [ALM Works]

@Dave Rosenlund _ALM Works_ - apologies, I'm using Data Center. and yes Expr is Ok.  I'm ok to use formulas with scripts if that's an option. i was more referring to 3rd party scripting via api, etc. 

Okay. Cool :) 

Now that we have that confirmed, I'll ask someone who knows Expr a heck of a lot better than I do to pitch in.  Stay tuned.

(Or, for a faster response, you can reach out to our support team via support@almworks.com)

-dave 

Like Lenny likes this

Hi, @Dave Rosenlund _ALM Works_  any link you can provide us on how to get to the parent summary for the issue in expr language?

Hello Stan,

You can do it using the access function in the originally described use-case: access(epic, "summary") if you want to show Summary of Epics of issues. And if issues are linked with any standard Jira link, then you try using this formula: issueLinks.FILTER($.type = "the name of the link direction betwwn issues" AND $.destination = item).MAP($.source).summary

Please feel free to reach out to us directly via support.almworks.com if you need further assistance with the Formula.

Best regards,
Stepan Kholodov
ALM Works

Like # people like this

Thank you, Stepan. We want to totalize story points as a percentage in the structure, and for getting it, we need to know at every level the issue is contributing value and the parent level (total); we need to access from level 2 to the total (level1) to have this percentage:

 

Summary -------+----- Σ SP--------+------ % SP---------+

level 1 epic                  13 points                100%

    level 2 story 1          8  points                  62% <--- need this calculation              

    level 2 story 2          5  points                  38% <--- need this calculation

 

I also want to know if you have an ETA for Expr language calculated columns on the cloud version.

You can try to use this formula: if(type="story", storypoints/parent{spsum})
where spsum variable is mapped to Σ Story Points value. The column's Format should be set as Percentage.

Regarding the Formula column in Structure Cloud: there is no ETA at the moment, this is a large feature, and all I can share at this time is that we're currently working on it. Once it is released, we'll make sure to let you know in this post.

Best regards,
Stepan Kholodov
ALM Works

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
PREMIUM
TAGS
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 ...

400 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