How to compare a field form all issues data to a field?

[Sahil Gulhane]

Current situation- In our jira we use a filed called "Voucher code" which is connected via api to an internal app. This field is a free text field.

Problem- We want jira to verify if the value entered by the user in this filed during a transition if the value is unique between issues based on a JQL querry. so for example user cannot enter a voucher code which is already used in jira in the same project.

Can you please tell me if and how i can do this?

[Fidel Castro Armario]

Hi Sahil,

You should insert "Validation based on JQL query" in your transition with the following configuration:

JQL Query is:

project = "%{00018}" AND "Voucher code" ~ "%{nnnnn}"

Boolean expression is:

{00058} = 0

Note that:

• %{nnnnn} should be replaced with field code for "Voucher code" custom field.
• %{00018} is field code for Project key.
• {00058} is code for numeric value of field Ephemeral number 1.

[Fidel Castro Armario]

I close the issue. Please, reopen it if the solution provided doesn't work for you.