Structure formula not working with 2 JQLs

[Purpjesus28]

Hi,

I cannot get the below formula to work.  When I remove 1 of the JQLs it works.  This is what I am trying to accomplish and I am probably going about it the wrong way. 

• If the epic is open and all stories under it are in done - should be close
  • we have the ready to release status under the statuscategory of Done
• If epic doesn't hit criteria of above, then I want the following to happen... if there is an open story/defect (excluding all other sub issues of the epic) that wasn't cancelled (some defects are closed but resolution shows no work was done) and does not have a fix version- tell me that story/defect w/o FV since I do not know the final release date of epic
  • Using JQL
• If criteria doesn't hit above, copy fix version from non epics into field (stories/defects ect)
• Then roll up the last fix version to epic if there are no defects/stories that aren't cancelled so I know when the epic will be resolved

IF JQL {statusCategory != Done AND NOT issueFunction in epicsOf("statuscategory != Done or status != 'Ready for release'") AND issuefunction in hasLinkType("Epic-Story Link")} : "Epic should be closed"

Else: JQL{issueFunction in epicsOf("fixVersion is EMPTY and issuetype in (defect) and status != Abandoned and project in (CCTSUSTAIN) and resolution not in ('Accepted as Unresolved','Working as Designed', Duplicate, 'Cannot Reproduce', 'Out of scope')") OR issueFunction in epicsOf("fixVersion is EMPTY and issuetype in (story) and status != Abandoned and project in (CCTSUSTAIN)")} : "Story/defect w/o FV"

Else: if issuetype != "epic":fixVersions.releaseDate

Else: Max(epicStories.fixversions.releasedate)

Let me know if this isn't clear and can give more info.

[Purpjesus28 · Accepted solution]

didnt have if in 2nd argument