Capture lowest status from Epic all child issues to custom Epic “Lowest Child Status” field

Issue #703 resolved
ITSAM
created an issue

Capture lowest status from Epic all child issues to custom Epic “Lowest Child Status” field

Example: If all child stories are “Done” with the exception of 1 “In Progress”, then Lowest Child Status should be “In Progress”

Comments (2)

  1. Fidel Castro Armario repo owner

    Hi @ITSAM,

    Create a "Calculated Text Field" called "Lowest Child Status" with the following configuration:

    • Parsing mode: advanced
    • Text to be parsed:
    getMatchingValue(min(mathOnIssueList(linkedIssues("is Epic of"), getMatchingValue(^%{00016}, ["Open", "In Progress", "Closed"], [1, 2, 3]))), [1, 2, 3], ["Open", "In Progress", "Closed"])
    

    Note that %{00016} is field code for Issue status.

    In my example status are "Open", "In Progress" and "Closed" and associated numeric values are 1, 2 and 3. You should edit the expression in order to make it fit your particular workflow.

    Take care to write the names of the statuses respecting the case. Note that JIRA usually shows the issue statuses in uppercase. The actual status names can be checked up at Administration > Issues > Statuses.

  2. Log in to comment