Script Runner Validator for JIRA Cloud to check Duplicate field values in other issues.

Question

Hi All,

In our Jira Software project in Cloud instance, we have a field called "Doc ID" which is a text field & is supposed to have a unique value for each issue. However, we are finding that users are using same "Doc ID" value in multiple issues.

To counter that, we are in search of a Validator when transitioning to DONE status which checks for "Doc ID" is all the issues in the project & if there is any issue exists with same value, the transition should fail with an error message.

We have Script Runner installed. Can anyone help with a Script Validator for our test case please.

Thanks & Reagrds,

Ganesh Kumar Vary

Kristian Walker _Adaptavist_ · Answer

Hi Ganesh,

Unfortunately, in Jira Cloud it is impossible with Validators due to the limitations with the Jira Expression Framework mentioned above.

Regards,

Kristian

Ganesh Kumar Vary · Answer

Hi Kristian,

Thanks for the update. I am just wondering if it is not possible even by using Script Validators?

Please let me know if there is any possibility.

Regards,

Ganesh Kumar

Kristian Walker _Adaptavist_ · Answer

Hi Ganesh,

Unfortantetlyin Jira Cloud it is not possible to use JQL in workflow conditions or validators provided by ScriptRunner for Jira Cloud.

This is because Workflow validators use the Jira Expression framework provided by Atlassian, and the Jira Expression Framework does not provide any way to use JQL in an expression.

This means that it will not be possible to write a validator in Jira cloud to validate if more than one issue uses the same doc ID and to block the creation of an issue when this is the case.

I hope this helps.

Regards,

Kristian