[structure] navigate in parent history

agnes BOURLON
Contributor
March 18, 2024

Hi

I would like to sum the story points of my US/tasks (child) only if the status of the EPIC (parent) was on a specific status, let's say "IN PROGRESS", on a D DAY , let's say date("2023-10-24")

First, I tried to get the EPIC status from the US/tasks today by writing :

  • parent{status}

=> I got a correct result

 

Then I added the historical_value function to get the same information but in the past, 

I tried :

  • historical_value(this, "parent.status", date("2023-10-24"))
  • historical_value(this, "parent{status}", date("2023-10-24"))
  • historical_value(this.parent, "status", date("2023-10-24"))
  • historical_value(parent, "status", date("2023-10-24"))

Nothing worked correctly, I got no result :-(

I hope this is possible to do this and it is just a matter of bad syntax

Many thanks in advance for your precious help,

Agnes

 

1 answer

1 accepted

1 vote
Answer accepted
Stepan Kholodov _Tempo_
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
March 18, 2024

Hello @agnes BOURLON 

When used directly, the historical_value() function can only access the values of issue's own fields, not their parents. If your goal is to extract the Status of the parent from a certain day and show it for the parent's sub-issues, you can do it with a formula like this:

parent{historical_value(this, "status", date("2023-10-24"))}

I hope this helps. If you need further assistance or have other questions about Structure, please reach out to us directly at our support portal.

Best regards,
Stepan
Tempo (the Structure app vendor)

agnes BOURLON
Contributor
March 19, 2024

Hi @Stepan Kholodov _Tempo_ 

Many thanks for your precious help. It is working correctly.

Best regards

Agnes

Like Stepan Kholodov _Tempo_ likes this

Suggest an answer

Log in or Sign up to answer