JQL Query not functioning as intended?

Question

My teammate and I are bashing our heads against the wall trying to write this query to compare a custom field value in one issue, against the same in a target issue, and then link the issues based on that. We keep getting an error that acts like we are stating that the custom field name = the custom field value, or is acting like we don't have access to that field's data (even though it's returning it.)

Here's our query:

summary ~ "Month End Review" AND status = "Provisional" AND "{{issue.Client.value}}" ~ "{{triggerIssue.Client.value}}"

Here's the error, with sensitive info replaced where necessary:

Unable to find any related issues:PROJ-7218: "((summary ~ "Month End Review" AND status = "Provisional" AND "Client Name Value Replaced" = "Client Name Value Replaced") AND (key != PROJ-7218)) AND (project in (99999))" - Field 'Client Name Value Replaced' does not exist or you do not have permission to view it.

For added info, I am a global Jira admin for our org, and teammate is admin for the project, we both receive the same error with our automations.

Trudy Claspill · Accepted Answer

Hello @Matt Miller

When asking for help with an Automation Rule it will help us help you if you provide the following:

* Screen images that show the entire rule
* Screen images that show the details of the step where you are trying to use smart values.
* The Rule Scope - is it a single project, multiple projects, or global?

The error is indicating that this part of your JQL is not valid:

"{{issue.Client.value}}" ~ "{{triggerIssue.Client.value}}"

When constructing a JQL the item on the left side of an operator has to be a field, not the value in the field. By using the .value attribute you are telling the rule to insert the value of the issue.Client field on the left side of the operator.

What type of field is "Client"? That will help us provide guidance on how to correct the JQL. Without having that information my first suggestion is that you change the left side of that comparison to remove .value

John Funk · Accepted Answer

Hi Matt,

What type of field is Client? And why are you tacking .value on to the end of it and not just using {{issue.Client}} and {{triggerIssue.Client}}?