JQ; Search Extended issue

[Siobhan Wallace]

Hi all,

I have recently just got the JQL search extender add on.

What I am trying to achieve it to search for particular issues (stories and investigations) where the parent EPIC is not currently on hold.

If anyone has any advice as to why my query isn't working I would be grateful

[Alex Koxaras _Relational_ · Accepted solution]

Hi @Siobhan Wallace 

First of all which app do you use? Can't find any app with the name "JQL search extender".

Second of all, on your JQL query you have two contradictory statements:

• One about stories and investigations and
• One about epic (which probably yields only Epic issue types)

Combining the above two, you are trying to get issue types which are both Stories/Investigations AND Epics. Of course, this is not possible.

[Siobhan Wallace]

@Alex Koxaras _Relational_ Thanks for your reply

The app is called JQL extended search thanks.

I am trying to pull Stories, Investigations etc from open Epics 

Thanks

[Alex Koxaras _Relational_]

@Siobhan Wallace kindly provide a link of the app on the marketplace. The one I find is only for jira server, but you are on cloud. 

[Alex Koxaras _Relational_]

@Siobhan Wallace I managed to find the application. So I would write something along these lines:

issuetype in (story, investigation) and status in (analysis, open, "to do", "ready for dev estimate") and issue in childrenOfEpicsInQuery("resolution = unresolved")

The JQL inside the childrenOfEpicsInQuery is your "filters = "open epics" JQL.

Let me know if that's what you wanted!

[Alex Koxaras _Relational_]

@Siobhan Wallace hi,

Did you get this this working?

[Iryna Komarnitska_SaaSJet_]

My team recently released Text to JQL gadget.

If you're having trouble getting your head around JQL queries, you can try this gadget on this link .

By the way, it's free. I hope this will be useful for you.