Operator: Greater Than Or Equal To (>=)
Description
Greater than or equal to (>=) 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 greater than or equal to the supplied value.
Values are normally either unquoted numbers, or quoted datetime or time span values.
Examples
All scripts with 10 or more steps:
| Code Block |
|---|
|
EntityType = Script AND ScriptStepCount >= 9
|
All requirements created during or after 2011:
| Code Block |
|---|
|
EntityType = Requirement AND CreatedAt >= '2011-1-1'
|
All requirements created at most 1 week ago
| Code Block |
|---|
|
EntityType = Requirement AND CreatedAt >= '-1w'
|
All script assignments where the total time spent executing (across all runs of the script in this assignment) is greater then or equal to 3 hours (Note: you can write time values as either '3h' or '3 hours' or '00:03:00')
| Code Block |
|---|
|
EntityType = ScriptAssignment AND AccumulatedActualDuration >= '3 hours'
|