I have a need to find all open epics that where all linked issues are closed or canceled
How about this...
"Epic Link" is not EMPTY and resolution is EMPTY
I was really trying to pull up the Epics where all linked items were completed or done but the Epic was still open.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
So you can't use JQL do that. You can consider using and addon e.g. Scriptrunner. There is also, the possibility of using automation to locate and flag Epix where all of the children are closed. Rather than regurgitate what has already been answered elsewhere I would refer you to this post where Stephen does a good job of explaining the possibility. Note, you don't have to use a custom field here you could use a label or even a comment.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.