Relational Operators Used in Queries

This topic describes the relational operators that you can use to define conditions in a query. The relational operators vary according to the type of field.

Relational Operators Used on Text Fields

The relational operators that can be used on text fields are:

  • Equals
  • Is Not
  • Contains (ignore case)
  • Contains (match case)
  • Starts with (ignore case)
  • Starts with (match case)
  • Ends with (ignore case)
  • Ends with (match case)

Back to top

Relational Operators Used on Boolean, Enumerated Type, and Numeric fields

The relational operators that can be used on Boolean, enumerated type, and numeric fields are:

  • Less Than
  • Same or Less
  • Equals
  • Same or Greater
  • Greater Than
  • Is Not

Back to top

Relational Operators Used on Date/Time Fields

The relational operators that can be used on date/time fields are listed below.

Comparing both date and time parts of date/time fields
  • Before
  • On or Before
  • On
  • On or After
  • After
  • Not On
Comparing only the date part of date/time fields
  • Before Date
  • On or Before Date
  • On Date
  • On or After Date
  • After Date
Matching all dates starting with the date that was the specified a number of days or weeks ago
  • Last (n) Days
  • Last (n) Weeks
Matching all the dates prior to and including the date that was the specified number of days or weeks ago
  • Older Than (n) Days
  • Older Than (n) Weeks

Note: In date fields, StarTeam treats blanks as zeroes. That means that “no date” is less than any specific date. For example, if you write a query that searches for change requests that were closed prior to some specific date, all the change requests with no date in the Closed On field are included in the results, even though they have not been closed yet. It is easy to eliminate the change requests that contain blanks in the Closed On field from such a query. You simply AND the condition that searches for change requests closed on or before a specific date with another condition that searches for change requests closed after the date zero.

Back to top