I am trying to find all Epics that are complete, but the story is still in Progress

[Nichelle Wagner]

my query is issuettype = Epic AND status = Complete AND issutetype = Story AND status = "In Progress"

However, the query is not returning any data and I know there are records out there because I have come across them accidentally.

[Cassie the Jira Mechanic]

@Nichelle Wagner This is an issue with your JQL

When you use AND the issue must be both conditions. Here you are saying must be an EPIC AND STORY. No issue can be both issue types at the same time. So it should ready OR rather than AND.

 issuettype = Epic AND status = Complete AND   OR  issutetype = Story AND status = "In Progress"

This will return issues that are:
epics in the status complete 
storys in the status "In Progress"

Here is some free documentation:
Use advanced search with Jira Query Language (JQL) | Jira Work Management Cloud | Atlassian Support

Here is a skill building training course I recommend to better understand when to use AND vs OR . Intro to JQL in Jira Software : Atlassian

Hope this helps! Please give it a try and if this fixes it 'Accept' the answer so others know this works!

[Cassie the Jira Mechanic]

Re-reading this though I think you are searching for stories that are open but their parent epic is not.  I actually have a scheduled automation that runs to check this. But it is not something without listing out your epics via JQL that can be done without an addon. I am assuming a lot here but if you want this data so you can update these issues accordingly see this automation to point you in the right direction. You can follow this and tweak it per your needs. You can also adjust the trigger to be when an issue is transitioned.. etc.

[Nichelle Wagner]

The EPIC is marked Done, but in some instances the Story is still open.  I want to find all instances where the EPIC is marked Done and the associated Story is showing as "In Progress".

[Cassie the Jira Mechanic]

@Nichelle Wagner the automation will be similar with a few tweaks to above.. if you want reach out on linkedIn ill be happy to help and after we can update this with the final solution.

[Nichelle Wagner]

Somewhat new to Jira.  I understand the automation, but not sure how to incorporate into the tool.  I will reach out on Linkedin