Page tree



Post Action NameSQL post action
Post Action Description

Connects to your JIRA's database.

Given SQL query is executed, then the value from a single cell from provided row and column from the result is compared with expected value.

You can insert in query two fields from commit request:

  • %user% - username of commiter
  • %message% - commit message

There are six types of comparison.

One of seven types of the cell from SQL result must be chosen.

Parameters
typenamerequired
SQL
query
true
BOOL
alwaysPass
true
INT
row
true
INT
column
true
PREDEF_VALUES_SINGLE
operator
true
PREDEF_VALUES_SINGLE
valueType
true
STRING
value
true
Release1.1.1
Git

SUPPORTED

Subversion

SUPPORTED

Bitbucket
PARTIALLY


Mercurial

UNSUPPORTED

Perforce

UNSUPPORTED