Unique text field with the JQL validator
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
Comments (3)
-
repo owner -
reporter 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.
-
repo owner - changed status to resolved
Thanks for take the details about your final solution.
- Log in to comment
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, andShort Text
with its name.