Error in "...issueFunction in linkedIssuesOf..."

[Deleted user]

Hello,

i have an issue, which is completlely not understandable for me.

I have a working Filter:

issuetype = Test AND issueFunction in linkedIssuesOf("project in (a,b) and issuetype = Story and labels in (nextSprint) AND Sprint is EMPTY")

This is working completely fine and shows me all the Test Cases within the User Storys i want so see.

Now i need a similiar filter, but for all Test Cases within the Defects i want to see. Therefore i copied the filter above and cahnged it into this:

issuetype = Test AND issueFunction in linkedIssuesOf("project in (a,b) and issuetype = Defect AND status in (New, Open, "In Progress", "In Test")")

But this time i get the Error: "Error in the JQL Query: Expecting ')' or ',' but got 'In'. (line 1, character 137)"

I do net get it, because its 1:1 the similar Filter as above, only based on Defects with other criterias.

If i only execute the inner Part from the linkedIssueOf, then it works:

project in (a,b) and issuetype = Defect AND status in (New, Open, "In Progress", "In Test")

Is there anybody who can help me out :)

Thanks in advance and regards

[Jeroen Poismans · Accepted solution]

Hi there,

When using " in the inner part of the linkedIssuesOf  then they must be escaped I think.

Try this:

issuetype = Test AND issueFunction in linkedIssuesOf("project in (a,b) and issuetype = Defect AND status in (New, Open, \"In Progress\", \"In Test\")")

"Escaping" means that when using " inside " ", you prefix it with an \ to let the inner " be interpreted as part of the expression.

Hope this helps!

Regards,

Jeroen

[Deleted user]

This worked, thank you a lot :)

[Yagmur Gümüs]

Hello again,

i have a similiar Problem again, which is not understandable again :D

Again, i copied this Filter, which is working perfectly:

issuetype = Test AND issueFunction in linkedIssuesOf("project in (a,b) and issuetype = Defect AND status in (New, Open, "In Progress", "In Test")")

and changed only the first Part from "issuetype = Test" to "issueType = Sub Test Execution"

Some Defects have Sub Test Executions and i want to see all of them on my Dashboard. Why does this not work?

The result is just empty, there is no Error Message.

Thanks in advance

regards

[Kelly Arrey]

Hi @[deleted] 

issuetype = \"Sub Test Execution\" AND issueFunction in linkedIssuesOf("project in (a,b) and
issuetype = Defect AND status in (New, Open, "In Progress", "In Test")")

[Kelly Arrey]

You can't have double quotes inside a double quoted string. I usually use single quotes if I need to quote something inside a quoted string, e.g.: 

issuetype = Test AND issueFunction in linkedIssuesOf("project in (a,b) and issuetype = Defect AND status in (New, Open, 'In Progress', 'In Test')")

[Jeroen Poismans]

Hi @Kelly Arrey ,

Actually you can use the double quotes, you just have to escape them like in my answer and it should work just fine. Singe quoting is also an option ofcourse.

Thanks for the add-on!

Regards,

Jeroen

[Kelly Arrey]

Hi @Jeroen Poismans

Yup, just wanted to show another option. Thanks!

Kel