Help with smart values for lookup issues

[Jarosław Kaczmarek]

Hi

I would need help in determining what is wrong with my smart value/ JQL for lookup issues automation. 

The logic of the automation: 

1. If a client creates "Upgrade task"
2. Lookup for issuetype="os update" AND customfield_123 (random customfield name)
3. Then comment on issue with issue key and customfield_456 (random customfield name)

customfield_123 contains company name so ideally, the JQL should find only those "OS updates" which match the value of customfield_123 that is present in the trigger issue. (Deploy advanced compare perhaps?) 

Problem:

1. When the smart value for customfield_123 is inserted into JQL, the comment contains the issue key for the trigger issue (i.e. Upgrade task), not for OS update/-s
2. When the smart value is deleted from JQL, the search returns a list of "OS upgrades" (correct) but naturally, the output is not limited by the value of customfield_123

Automation:

[Jarosław Kaczmarek · Accepted solution]

I was able to achieve what I wanted. The JQL was not correct in terms of syntax. Here is what worked:

issuetype="os update" AND "company name" ~ {{customfield_11943}}