JIRA Structure Find Features with stories with no Sprint assigned

[Kev]

Hi there

I have created a JIRA Structure and i am visualizing some checks to improve the quality in our teams. On this Structure i have all Features of our Project. Now i would like to create a check which: 

- Checks for Stories which are below this feature. 
--> We have: Feature --> Child issues: EPIC --> Issues in epic: Stories

now i would like to have a query which checks if there is a Story, which has no value for the fiel "Sprint". If there is no value then i would return "NOK" otherwise "OK".

From my reasearch in the internet i got: 

IF(issueType = "Feature", IF(COUNT#all{issueType = "Story" AND Sprint = ""} > 0, "NOK", "OK" ), "" )

But this is not really working. 

Anybody any simple idea how to set up this fomula? And any good hint to train my knowledge about how to write complex formulas would be apprechiated. 

Thank you & regards
Kevin

[Stepan Kholodov _Tempo_]

Hello @Kev 

If you want to see the OK/NOK indicator for Features, based on the Sprints assignment in Stories under them, you can do it with a formula like this:

if issuetype = "feature":
if sum{if issuetype = "story" and sprint: "1"}>0: "OK" else "NOK"

As for learning more about the Formula - you can find more information about it in our documentation and on our YouTube channel here.

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

Best regards,
Stepan
Tempo (the Structure app vendor)

[Kev]

@Stepan Kholodov _Tempo_ i first thougt it is working.. but as i have checked now a bit deeper i saw that when there are features --> epic --> stories and there is no value for the field Sprint in one of the stories, it still return as "OK". If there is a feature which contains no epic and no stories it returns as NOK. i somehow should change something on the formula, but no idea what :-) if you have some idea, thx for sharing.  

[Stepan Kholodov _Tempo_]

If you only want to show OK for features that:
- have Epics and Stories and
- every Story have a Sprint assigned, 

then you can reverse the logic of the formula and tweak it a bit like this:

if issuetype = "feature" and sum{if issuetype = "story": 1}>0:

if sum{if issuetype = "story" and !sprint: "1"}>0: "NOK" else

if sum{if issuetype = "story" and sprint: "1"} = sum{if issuetype = "story": 1}: "OK"

If you need further edits of the formula - please sunmit a support reauest at our portal.

Best regards,
Stepan