Less Than (<)

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'