Compare Custom Field to Text Field

[Anthony Delgado]

It appears that I can do direct searches to the Text field with a literal string such as 

TextField ~ "findThisString"

But I can't compare it directly to the value in another custom field:

TextField ~ "CustomFieldName"

Is there a way to do this?  If it matters, the field I want to compare to the text field is an Insight Object field.

Thanks in advance for any ideas!

[Alexey Matveev]

Hello,

You can not do it out of the box. 

You would need an add-on for it.

[Anthony Delgado]

Which add-ons allow this?

[Alexey Matveev]

You could use the Power Scripts add-on:

https://marketplace.atlassian.com/apps/43318/power-scripts-jira-script-automation?hosting=cloud&tab=overview

Your JQL query would look like this:

key in silJQLExpression('#{your custom field name} == #{your custom field name}', 'project = TEST')