SQL+JQL workflow validator

Dmitri Kozlov May 30, 2022

Hi,

I have a workflow transition with a form. When I activate the transition the form pops up where I can fill in the issue fields and finalise the transition.
 
I added a SQL validator to a workflow transition with a condition on a custom field:

SELECT
  count(*)>0
FROM
  JQL
WHERE
  jql.query='ID = %issueid% AND "Release Note Description" IS EMPTY'

The query checks the "Release Note Description" value from the DB, but not the one I set in the transition form (if I clean the "Release Note Description" field and then open the form to do the transition then the transition proceeds successfully otherwise the validation fails).

How can I access the form field values instead of the DB?

 

0 answers

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
SERVER
VERSION
8.22
TAGS
AUG Leaders

Atlassian Community Events