Operator: Greater Than (>)
Description
Greater than is used to compare two numeric values, it used for fields which represent:
- Numbers
- Dates & Times
- Timespans
It will return all records where the field's value is greater then 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 > 10
|
All requirements created during or after 2011:
| Code Block |
|---|
|
EntityType = Requirement AND CreatedAt > '2010-12-31'
|
All requirements created less then 2 weeks ago
| Code Block |
|---|
|
EntityType = Requirement AND CreatedAt > '-2w'
|
All script assignments where the total time spent executing (across all runs of the script in this assignment) is greater then 4 hours (Note: you can write time values as either '4h' or '4 hours' or '00:04:00')
| Code Block |
|---|
|
EntityType = ScriptAssignment AND AccumulatedActualDuration > '4 hours'
|