Help Contents
-
System Administration
-
User Guide & Application Administration Guide
-
Using Enterprise Tester
-
Application Administration
-
Searching & TQL
-
Simple Search
-
Advanced Search
-
Testing Query Language (TQL)
-
Aggregation
-
Avg (Average)
-
Count
-
Entities
-
Faceted
-
Facet Functions
-
And (AndArgs)
-
Date Add (DateAdd)
-
Date Subtract (DateSubtract)
-
Equal (Equal)
-
Field (FieldName)
-
Greater Than (GreaterThan)
-
Greater Than Or Equal (GreaterThanOrEqual)
-
Is Not (IsNot)
-
Less Than (LessThan)
-
Less Than Or Equal(LessThanOrEqual)
-
Not Equal (NotEqual)
-
Now (Now)
-
Or (OrArgs)
-
Range (Range)
-
Today (Today)
-
Unmatched
-
Yesterday (Yesterday)
-
And (AndArgs)
-
Facet Functions
-
Group By
-
Max (Maximum)
-
Min (Minimum)
-
Sum
-
Avg (Average)
-
Fields
-
Functions
-
Indexes
-
Operators
-
Order By
-
SET
-
TQL For JQL Users
-
Types
-
Values
-
Aggregation
-
Simple Search
-
API
-
Using Enterprise Tester
-
Platform Plugins
-
Troubleshooting
-
Earlier Versions of this Documentation
-
Support & Bug Fixes
-
NextGen
-
Enterprise Tester 6.7.1
Function: Equal
Syntax
Equal(<FieldName|Function>, <Value|Function>)
Description
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 equal to the second parameter.
Examples
Priority high:
Faceted Equal(Priority,High) { COUNT } WHERE EntityType = Requirement
EstimatedDuration is equal to 5 minutes:
Faceted Equal(EstimatedDuration, '5 minutes') { COUNT } WHERE EntityType = Script
CreatedAt date/time is equal to the LastUpdatedAt date/time:
Faceted Equal(CreatedAt, Field(LastUpdatedAt)) { COUNT } WHERE EntityType = Requirement