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:
| Code Block |
|---|
|
EntityType = Script AND ScriptStepCount < 50
|
All requirements created before 2011
| Code Block |
|---|
|
EntityType = Requirement AND CreatedAt < '2011-1-1'
|
All requirements created more then a week ago
| Code Block |
|---|
|
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')
| Code Block |
|---|
|
EntityType = ScriptAssignment AND EstimatedDuration < '5m'
|