Versions Compared

Key

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


UI Text Box
sizemedium
typeinfo

This condition evaluates the comparison of two (field) values


Configuration

UI Expand
titleField

Define the first of the two values that should be compared by selecting it from the list of available fields.

UI Text Box
typetip

Depending on the type of the field you have selected only certain operators and fields in the comparison value field selector are available.



UI Expand
titleOperator

Select how to compare the two given values. Choose from one of the following options:

OptionDescription

=

The first value must be equal to the second value.

!=

The first value must not be equal to the second value.

<

The first value must be less than the second value. This is typically used for comparing numeric or date-time values.

>

The first value must be greater than the second value. This is typically used for comparing numeric or date-time values.

<=

The first value must be less than or equal to the second value. This is typically used for comparing numeric or date-time values.

>=

The first value must be greater than or equal to the second value. This is typically used for comparing numeric or date-time values.
~The first value must contain the second value. This is typically used for lists as field value to compare. The comparison value is a text or number.
!~ The first value must not contain the second value. This is typically used for lists as field value to compare. The comparison value is a text or number.


UI Text Box
typetip

In case you have selected a field of the type

Status
subtletrue
titlelist
 or
Status
subtletrue
titletext
, only the equalnot equal, contains and not contains operators are available. Lists may contain duplicate values.
For fields of type 
Status
subtletrue
titleboolean
, only the equal and not equal operators are available.



UI Expand
titleComparison value

Define the second of the two values that should be compared either by selecting it from the list of available fields or by entering a literal value. You can switch between the two option by using the radio button which offers the options

  • "Select the field to compare the value with.This is the preselected default value.
  • "Enter the custom comparison value." In this case a text editor opens where you can enter the comparison value manually.
    Depending on the data type of the first comparison value, the following inputs are valid as custom value

    OptionDescription

    Date

    A date in the format YYYY-MM-DD, e.g. 2008-09-15
    Date time A date time value in the format YYYY-MM-DDTHH:mm:ss, e.g. 2008-09-15T15:53:00+05:00

    Text

    Any text, e.g. This is a text

    Number

    Any number, e.g. 42 or 7.75
    List List are entered as their comma separated values: This, is, a, list or 2,3,5,7
    BooleanOne of the boolean values true or false
    Select list (cascading)The parent and child values are noted as text, separated by a comma, e.g. Parent, child. If the child is omitted (e.g. Parent) then the child value of the first operator has to be null as well.


UI Text Box
typetip

The most common use case is to compare a field values provided by field codes.



UI Text Box
typetip

If one of the selected fields is hidden or deleted when the condition is executed, the field value is interpreted as null.


UI Text Box
typetip

If you need to compare multiple values or construct more complex comparisons make sure to have a look at the Jira expression condition.



Use cases and examples

Page properties report
firstcolumnUse case
headingsTypeJWT feature, FunctionWorkflow function, Use case description, Complexity
cqllabel = "use-case" and label = "compare-two-values" and space = currentSpace()


Excerpt Include
DECADIS:Contact support
DECADIS:Contact support
nopaneltrue


Page properties
hiddentrue



Status
Tech review

Status
colourGreen
titledone

Style guide

Status
colourYellowGreen
titleReady for reviewdone

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


Page properties
hiddentrue


Short descriptionEvaluate the comparison of two (field) values
Label

Status
colourRed
titlestaff pick