initiative is the upper level of epic, i want to filter initiative status, but don't know the SQL

[oda mao]

in my jira, initiative is the upper level of epic, i want to filter initiative status, but don't know the SQL, please help on it

[Suvarna Gaikwad]

@oda mao Please try this issuetype=Initiative AND status = Open

P.S. replace Open with your desired status

[oda mao]

thanks for replying and please allow me clarify my question:

initiative is the upper level of epic, i want to filter the epic that their initiative status is not "define" and if their initiative status is completed, filter the initiative status changed  to "completed“ in current week.

[oda mao]

what i want to display is epic, and the screening conditions of epic is base on there initiative(initiative is the upper level of epic):

1.initiative status is not "define" 

2.if their initiative status is completed, filter the initiative status changed  to "completed“ in current week.

please help on it

[Suvarna Gaikwad]

@oda mao can you please provide one screenshot of Initiative type issue showing how they are linked with Epic type? It will help

[oda mao]