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