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: LessThan
Syntax
LessThan(<FieldName|Function>, <Value|Function>)
Description
The LessThan function 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 less than the second parameter.
Examples
Average duration of scripts with less than 20 steps:
Faceted LessThan(ScriptStepCount,20) { Average(EstimatedDuration) } WHERE EntityType = Script
EstimatedDuration is less than 5 minutes:
Faceted LessThan(EstimatedDuration, '5 minutes') { COUNT } WHERE EntityType = Script
Script assignments where the last run has an actual duration that is less than the estimated duration for the associated script:
Faceted LessThan(ActualDuration, Field(EstimatedDuration)) { COUNT } WHERE EntityType = ScriptAssignment