Jira JQL error I cannot fix....

Brian Jackson_fyn1p1

 

 

project IN (RITACP, RITDSM, RITAMC, RITAME, RITDFS, RISCO, RITAFBM, RITAMP, RITDFDO, RITAMPI, RITCRCL, RITAFLE, RITDLM, RITDDC, RITAIO, RITAIVN) AND (
    (issuetype = Initiative AND "XYZ" = "ABC")
    OR issueFunction IN linkedIssuesOf('project IN (RITACP, RITDSM, RITAMC, RITAME, RITDFS, RISCO, RITAFBM, RITAMP, RITDFDO, RITAMPI, RITCRCL, RITAFLE, RITDLM, RITDDC, RITAIO, RITAIVN) AND issuetype = Initiative AND "XYZ" = "ABC"')
    OR issueFunction IN linkedIssuesOf('issuetype = Epic AND issueFunction IN linkedIssuesOf("project IN (RITACP, RITDSM, RITAMC, RITAME, RITDFS, RISCO, RITAFBM, RITAMP, RITDFDO, RITAMPI, RITCRCL, RITAFLE, RITDLM, RITDDC, RITAIO, RITAIVN) AND issuetype = Initiative AND \"XYZ\" = \"ABC\"")')
)

 

Error in the JQL Query: Expecting ')' or ',' but got 'Key'. (line 1, character 232)

 

This query works when I am not trying to get issues linked to epics but just pull Initiatives and Epics.  When I try to add all linked issues, I get the error above.  Any help would be appreciated.

Trudy P Claspill

Hello @Brian Jackson 

Welcome to the Atlassian community.

Your post tags say you are using Jira Cloud. I'm going to assume that is correct.

The "issueFunction IN linkedIssuesOf()" portion is not natively available in Jira JQL. Do you have a third party app such as ScriptRunner Enhanced Search or JQL Extensions installed? If so, it is that third party app that makes that syntax available.

In general that syntax can't be used directly in the native Jira issue search screens. For ScriptRunner there is actually a separate Enhanced Search screen where you have to create the JQL statement with that syntax:

 

You create the JQL statement there and save it, then in the native Jira issue search screens you can reference it with the syntax:

filter="put the name of the saved filter here"