Get started

Use case library

JWT expression editor

JWT expression parser functions

JWT workflow functions

JWT remote actions

JWT automation rules

JWT calculated fields

JWT calendars

JWT properties

JWT JQL functions

Cloud migration hub

Additional product info

Versions Compared

Old Version 8

changes.mady.by.user Iheb Kharab

Saved on

compared with

New Version 9

changes.mady.by.user Jona Ittermann

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.


Panel

On this page

Table of Contents
maxLevel2
exclude(On this page|Use case).*
stylecircle
typeflat
separatorpipe



UI Text Box
sizemedium
typeinfo

Use case

Prevent issue creation when there is already another issue in the same project with the same value in a certain field.

In this use case let's suppose that we have a text custom field called Invoice, and we want to avoid this field's value to be repeated among issues of the same issue type in the same project.


Configuration

UI Steps


UI Step

Add the Validation based on JQL query to the "Create issue" transition of the desired workflow.


UI Step

JQL

Add the following JQL query:

Code Block
languagebash
linenumberstrue
project = "%{00018}" AND issuetype = "%{00014}" AND Invoice = "%{10200}"



UI Step

Validation

Select Number of issues returned by the JQL query satisfies a logical expression.


UI Step

Expression

Add the following expression:

Code Block
languagebash
linenumberstrue
{00058issue.temporaryNumber1} = 0




UI Text Box
typetip
An alternative implementation of this use case can be done using a Logical validator, see the following use case to see how it can be used.



Screenshots



Related use cases

Page properties report
firstcolumnUse case
headingsJWT feature, Workflow function, Parser functions, Label
sortByTitle
cqllabel = "use-case-workflow" and ancestor in ("32215802","32213779","27066629")

Excerpt Include
DECADIS:Contact support
DECADIS:Contact support
nopaneltrue


Page properties
hiddentrue


JWT feature

Workflow function

Validation based on JQL query

Logical validator

Use case descriptionPrevent issue creation when there is already another issue in the same project with the same value in a certain field.
Parser functions
Label



Page properties
hiddentrue



Status
Tech review

Status
titletodo

Style guide

Status
colourGreen
titledone

Status
titletodo
Status
colourYellow
titleReady for review
Status
colourGreen
titledone
Status
colourRed
titleflagged