Unique text field with the JQL validator

[Burçin Çelik]

Hello Fidel,

I want to use "Validation based on JQL query " validator for check the same value used in another issue. I can try many ways but i can not solve the problem. I use the text field (single line) and want the value is unique (get warning when the same value is entered) and may be field is empty. ( not required)

Can you help me please?

Thanks, Have a good day

[Fidel Castro Armario]

Hi @burcincelik,

You can use "Boolean validator with math, date-time or text-string terms" in one or more transitions of your workflow with a configuration similar to this one:

In my example the text field is called Short Text and its field code is %{11100}.

JQL Query is: issuekey != %{00015} AND "Short Text" ~ "%{11100}",

and boolean expression is {00058} = 0, where %{00015} is field code for Issue key, and {00058} is field code for Ephemeral number 1.

You should replace %{11100} in the JQL query with the field code of your text field, and Short Text with its name.

[Burçin Çelik]

Hello again,

Thanks for your help. It is not working that way but i tried the earlier method with adding quotes the field code. it works.

It accepts the empty value.

It accepts the unique value.

It does not accept the same value with other issues.

JQL Query: "Short Text" ~ "%{11100}" AND "Short Text" is not empty

And the other sections are the same.

We appreciate your support as always. Thanks.

[Fidel Castro Armario]

Thanks for take the details about your final solution.