Not Equal (NotEqual)

Function: NotEqual

Syntax

NotEqual(<FieldName|Function>, <Value|Function>)

Description

Not Equal allows you to compare the value of a field or function to a fixed value, another field or a function.

It will return true if the first parameter is not equal to the second parameter.

Examples

Priority is not low:

Faceted NotEqual(Priority,Low) { COUNT } WHERE EntityType = Requirement

EstimatedDuration is not equal to 15 minutes:

Faceted NotEqual(EstimatedDuration,'15 minutes') { COUNT } WHERE EntityType = TestScript

CreatedAt date/time is not equal to the LastUpdatedAt date/time:

Faceted NotEqual(CreatedAt, Field(LastUpdatedAt)) { COUNT } WHERE EntityType = TestScript

See Also