The relational operators that you can use to define conditions in a query vary according to the type of field:
- Text fields
- Boolean, enumerated type, and numeric fields
- Date/time fields
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)
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
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.