Jira Automation - how to add a rule that will check wether a value is equal to another one?

[Sharon Freij]

Hi all,

I'm setting up a Jira environment for engineering change management. In our current Access database some preferences are build by ourselves.
Let me explain shortly the process. When an engineer wants to change a material, he has to enter the material number and the reason for changing.
In our current access database, the database is searching through all open change requests, if there's any other open request with the same material number.

Is there any possibility that I can build the same within Jira? That it will search through ''not-closed'' tickets, based on a certain value in a certain field and when it finds a corresponding issue, it will notify the 'issue creator'?

Thanks in advance.

[Michael Kuhl _Appfire_ · Accepted solution]

Hi @Sharon Freij - You can do this by adding a workflow validator to the create transition on the issue workflow.  You would need an additional workflow app such as Jira Workflow Toolbox (for Jira Server or Data Center) to use a JQL validator.  That validator will search for issues and return an error message if other matching issues are found.