/
Workflow Validators and Conditions

Workflow Validators and Conditions

Since the 7.9.0 version, it is possible to write custom validators and conditions for workflows.

The SQL+JQL query must return a boolean value (or any other convertible type) in the first column of the first row.

It supports variable substitution for the current issue id:

%issueid%

Example

This is an example for a custom validator (conditions are very similar).

We are going to write a validator to avoid to perform the Done transition between the OPEN and CLOSED statuses if the issue has no comments.

Edit the target transition and click on the Add validator button:


Select the SQL+JQL Workflow Validator option and click on the Add button:


Type the:

  • Description: This is the error text message that the end users will read and the tip for the administrators to identify the validator.
  • Query: select count(*) from ISSUECOMMENTS ic where ic.issueid = %issueid%. The %issueid% variable will be replaced at run time with the current issue id. Notice that the query returns a numeric value. 0 (FALSE) for no comments and >0 (TRUE) otherwise.


Click on the Add (or Update if you are editing it) button to save the changes and publish the workflow version once it be ready for production.

Test the validator: Open an issue with no comments and in the TODO status:


Then click on the Done transition button:



The users will see the validator's Description value: "Must have comments" to understand what is failing.

Now, write some comment and click on the Done button. The issue will be transitioned to the DONE status:

Related content

Shareable Tables
Shareable Tables
Read with this
Custom Fields
Read with this
Web Datasource (CSV and REST for MS Excel, PowerBI,...)
Web Datasource (CSV and REST for MS Excel, PowerBI,...)
Read with this
JQL and SQL (working together in the same query)
JQL and SQL (working together in the same query)
Read with this
Custom JQLs (built on the fly)
Custom JQLs (built on the fly)
Read with this
Getting started (Must read)
Getting started (Must read)
Read with this