Using lookupissues to find related issues based on fixVersion

Question

My overall effort is to find sub-tasks of issues whose fixVersion equals the fixVersion of a special "Release" issue as it transitioned into to a particular status.

I am trying to use lookupissues to find the related issues and using the JQL:  fixVersion = {{triggerIssue.fixVersion.name}}.

Every time I transition the status of the "Release" issue, the automation fails with:  Custom Smart Value JQL Search: "(fixVersion =)  AND (project in (10010))" - Error in JQL Query: Expecting either a value, list or function but got ')'. You must surround ')' in quotation marks to use it as a value. (line 1, character 14).  I expected the fixVersion value from the triggering issue to be substituted for the {{triggerIssue.fixVersion.name}} but that is not occurring.

Am I doing something wrong (most likely) or is this a bug?

Bill Williams · Accepted Answer

I found the problem.  The helper that displays the smart values when typing the query shows triggerIssue.fixVersion.name; however, I found elsewhere the proper value is triggerIssue.fixVersions.name (note the 's').