How to use attribute "Outline Number" of Requirement Item in computed field expressions?

Question

Hi dear Community, I want to use the Item Attribute "Outline Number" of Requirement Item in computed field.  Example: I tried to write the computed filed expression like 'indexOf (<Outline Number>, ".") ' to know, whether Outline Number contains one "." (dot symbol). But I can't use the attribute name "Outline Number" per se, because it contains the blank symbol. Therefore I need the property name for Outline Number. But this attribute is hidden and I can't see it in attributes' list of Tracker configuration, even if I turn the ticks "show hidden attributes" and "show property names" on. Please help me to solve this problem. Thank you in advance!

EvaBertalan · Accepted Answer

Hello @vjub58 ,

The outline number of the work items in a tracker is not stored in any property.

That's why it is not possible to use it in computed field.

You need to use some other calculation to get the desired data.

E.g. in your example you can check if the work item has one and only one ancestor.

JosephM_SAI · Answer

Hey, I was able to achieve what you were looking within a single tracker by creating a computed field with this expression:

empty Parent ? 0 : Parent.customField[1] + 1

where customField[1] is the property of my Ancestors custom field.

As you can see above, I've created two items as parents, and this example item with a parent that has a parent has a value of 2 in the Ancestors field.

And now that it's parent has no more parents, the Ancestors field has a value of 1.

If you wanted this to work across trackers, or to be a bit cleaner of an expression, you could create an Shared Field for "Ancestors" and associate these individual tracker fields with this shared field like so:

Allowing us to use this new expression easily:

max(List(max(subjects.{subject | subject.Ancestors + 1}), empty Parent ? 0 : Parent.Ancestors + 1))

For this particular "Loram Ipsum 2" item, it has 4 ancestors - that being a User Story, with an upstream Feature, with an upstream System Requirements, with an upstream Customer Requirement.

This works within a single tracker as before by traversing the Parent, but also works across trackers by finding the max of all the Ancestors fields in the subjects tracker.

If you had other upstream trackers to include, it would only require an adjustment to the formula to include them in the max function.

max(List(max(subjects.{subject | subject.Ancestors + 1}), max(customChoice[3].{item | item.Ancestors + 1}), empty Parent ? 0 : Parent.Ancestors + 1))

where customChoice[3] is a custom dropdown of other upstream item references for this example.

Hopefully one of these solutions works for you, feel free to comment though if there are some additional needs related to this for whatever you are trying to accomplish!

Sign up

Please use your PTC eSupport account.

Welcome to the PTC Community

Please use your PTC eSupport account.

Scanning file for viruses.

This file cannot be downloaded