Operator: Less Than (>=)
Description
Less Than is used to compare two numeric values, it is used for fields which represent:
- Numbers
- Dates & Times
- Timespans
It will return all records where the fields value is less than the supplied value.
Values are normally either unquoted numbers, or quoted date time or time span values.
Examples
All scripts with less than 50 steps:
EntityType = Script AND ScriptStepCount < 50
All requirements created before 2011
EntityType = Requirement AND CreatedAt < '2011-1-1'
All requirements created more then a week ago
EntityType = Requirement AND CreatedAt < '-1w'
All script assignments where the estimated duration is less than 5 minutes (Note: you can write time values as either '5m' or '5 minutes' or '00:00:05')
EntityType = ScriptAssignment AND EstimatedDuration < '5m'