unable to add status "In progress" to the status list (status in)

[Victoria Luskin]

Hi,

I am trying to create the following query (to get the list of all epics), which are not closed, but their children are closed/fixed/accepted.

project = XXX AND status not in (Closed,Accepted) and issueFunction in linkedIssuesOf("status in( fixed,accepted,closed)", "has epic") and not issueFunction in linkedIssuesOf("status in (open, acknowledged, "In Progress")", "has epic")

it works fine without "In progress" status, but when I add it, I get error: 

Error in the JQL Query: Expecting ')' or ',' but got 'In'. (line 3, character 70)

1. How can it be resolved?

2. Is there another way to exclude all epics with children status: open, acknowledged, In progress?

3. What is the query to get all epics without children at all?

Thanks,

[Manoj Kumar Gangwar · Accepted solution]

Hi @Victoria Luskin 

The status "In Progress" is enclosed in single quotes because it has a space.

project = XXX AND status not in (Closed,Accepted) 

AND issueFunction in linkedIssuesOf("status in (fixed,accepted,closed)", "has epic") 

AND not issueFunction in linkedIssuesOf("status in (open, acknowledged, 'In Progress')", "has epic")

To find all epics that don’t have any linked issues (children), you can use this query:

project = XXX AND issuetype = Epic AND not issueFunction in hasLinks("is Epic of")

[Victoria Luskin]

@Manoj Kumar Gangwar thank you very much!