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:

EntityType = Script AND ScriptStepCount > 10

All requirements created during or after 2011:

EntityType = Requirement AND CreatedAt > '2010-12-31'

All requirements created less then 2 weeks ago

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')

EntityType = ScriptAssignment AND AccumulatedActualDuration > '4 hours'
  • No labels