Fundamentals > Windchill Search > Search Reference > Related Object Search Operators
Related Object Search Operators
The following operators appear under the Related Object Search field.
When selecting an operator, note the following:
The operators that appear depend on the attribute type.
The only operators that accept a wildcard are like and not like. These operators are only available for strings.
The behavior of searches might be different depending on customizations done at your site.
All Attribute Types
null
not null
The null operators search for the presence or absence of a value, but does not evaluate the value itself. Null values are attributes that are left blank.
For example, you perform a search against the following values:
Material: Steel
Material: Iron
Material:
Material: Aluminum
not null — Return all objects that have any value entered in the Material field:
Material: Steel
Material: Iron
Material: Aluminum
null — Return all objects that have no value entered in the Material field:
Material:
* 
The null operator is the only search that returns null values. All other searches are compared against values that are not null.
equals
not
Returns values that are a precise match.
For example, you perform a search against the following values:
Material: Steel
Material: Iron
Material: Aluminum
equals Steel — Return all objects with steel:
Material: Steel
not Steel — Return all objects with any material other than steel:
Material: Iron
Material: Aluminum
* 
You must provide an exact value. Characters are case-sensitive and spaces between strings are evaluated literally.
If the attribute is a value list, you can select one or more values from the drop-down menu.
For information on using type-specific operators, see the following sections:
Strings
String fields are manually entered by the user and can include numbers, letters, and symbols.
* 
Strings are processed differently depending on your locale, character encoding, and database collation.
The following table uses the default settings for the English locale.
Strings
in
not in
Provide a list of possible values separated by the pipe character (‘|’) or a comma.
For example, you perform a search against the following values:
Title: Specifications for Release
Title: Project Timeline
Title: Contact Matrix
Title: contact matrix
in contact matrix, Project Timeline — Return all objects with titles in the list:
Title: Project Timeline
Title: contact matrix
not in contact matrix, Project Timeline — Return all objects with titles not in the list:
Title: Specifications for Release
Title: Contact Matrix
* 
You must provide an exact value. Characters are case-sensitive and spaces between strings are processed literally.
like
not like
Search for string values, beginning at the start of the string and moving towards the end.
For example, you perform a search against the following values:
Title: Specifications for Release
Title: Appendix 9
Title: approval for release
Title: Review09-17
like app — Return all objects that have titles starting with “app”:
Title: approval for release
not like app — Return all objects which have titles that do not start with “app”:
Title: Specifications for Release
Title: Appendix 9
Title: Review09-17
like *9 — Return all objects with titles that include the number 9:
Title: Appendix 9
Title: Review09-17
not like *9 — Return all objects with titles that do not include the number 9:
Title: Specifications for Release
Title: approval for release
* 
All strings are processed with an inherent trailing wildcard. For example, there is no functional difference between app* and app.
Similarly, *9* and *9 also return identical results.
* 
Text searches are case-sensitive. Spaces between strings are processed literally.
This is the only search that accepts wildcards. The asterisk wildcard character (*) is accepted. The asterisk represents zero or more characters.
>
>=
<
<=
Return string values greater than or less than the string.
Strings are sorted by character value, starting with the first character in the string. Character value is assessed using printable ASCII code. For more information, see http://www.ascii-code.com/.
With some exceptions, the sort order is as follows: spaces < symbols < 0-9 < A-Z < a-z
For example, the following strings are sorted by value from smallest to largest:
1
1 2 a
ABC
Efg ABC
m45
x
For example, you and another user are responsible for evaluating budget requests submitted by individual employees. You have divided the work based on employee names. You are responsible for evaluating requests from employees whose name starts with A through L, and your coworker evaluates M through Z.
To complicate this, a random 5 character identifier is appended to the front of each submission. As a result, you have the following files:
Name: 469hh Anderson
Name: 02bf5 Jones
Name: t7811 Morris
Name: 981zr Smith
> zzzzz M — Return strings with a larger character value:
Name: 981zr Smith
>= zzzzz M — Return strings with a larger or equal character value:
Name: t7811 Morris
Name: 981zr Smith
< zzzzz M — Return strings with a smaller character value:
Name: 469hh Anderson
Name: 02bf5 Jones
<= zzzzz M — Return strings with a smaller or equal character value:
Name: 469hh Anderson
Name: 02bf5 Jones
Name: t7811 Morris
* 
zzzzz—Lowercase ‘z’ has a greater value than numbers and other text characters.
M—Uppercase M has a greater value than A-L.
Numbers
Some fields only accept number values.
An error message appears if you enter restricted characters, including spaces.
Numbers
in
not in
Provide a list of possible values separated by the pipe character (‘|’).
For example, you perform a search against the following values:
Cost: 16.25
Cost: 462
Cost: 585.50
Cost: 1100

in 10|16.25|585 — Return all objects with a listed cost:
Cost: 16.25
not in 10|16.25|585 — Return all objects with a cost that is not in the list:
Cost: 462
Cost: 585.50
Cost: 1100
>
>=
<
<=
Search for numbers greater than or less than the supplied value.
For example, you perform a search against the following values:
Cost: 16.25
Cost: 462
Cost: 585.50
Cost: 1100

> 462 — Return all objects with a cost greater than 462:
Cost: 585.50
Cost: 1100
>= 462 — Return all objects with a cost greater than or equal to 462:
Cost: 462
Cost: 585.50
Cost: 1100
< 462 — Return all objects with a cost less than 462:
Cost: 16.25
<= 462 — Return all objects with a cost less than or equal to 462:
Cost: 16.25
Cost: 462
Dates
Click the calendar icon or enter a date using the format enforced at your site.
The following examples use the format YYYY-MM-DD.
Dates
between
Return dates within the given time period, including the selected dates.
For example, you perform a search against the following values:
Deadline: 2016-07-15
Deadline: 2016-07-20
Deadline: 2016-08-05
Deadline: 2016-11-29
between 2016-07-19 - 2016-08-05 — Return all tasks with deadlines between July 19 and August 5:
Deadline: 2016-07-20
Deadline: 2016-08-05
yesterday
last week
last month
last quarter
last year
Return dates within a past time period.
For example, the current date is 15 July 2016 and you perform a search against the following values:
Deadline: 2015-10-22
Deadline: 2016-04-17
Deadline: 2016-06-21
Deadline: 2016-07-04
Deadline: 2016-07-14
Deadline: 2016-08-11
yesterday — Return all tasks with a July 14 deadline:
Deadline: 2016-07-14
last week — Return all tasks with a deadline from July 3 through July 9:
Deadline: 2016-07-04
last month — Return all tasks with a deadline in June 2016:
Deadline: 2016-06-21
last quarter — Return all tasks with a deadline from April 2016 through June 2016:
Deadline: 2016-04-17
Deadline: 2016-06-21
last year — Return all tasks with a deadline in 2015:
Deadline: 2015-10-22
today
this week
this month
this quarter
this year
Return dates within the current time period.
For example, the current date is 15 July 2016 and you perform a search against the following values:
Deadline: 2015-10-22
Deadline: 2016-04-17
Deadline: 2016-07-04
Deadline: 2016-07-12
Deadline: 2016-07-15
Deadline: 2016-08-11
today — Return all tasks with a July 15 deadline:
Deadline: 2016-07-15
this week — Return all tasks with a deadline from July 10 through July 16:
Deadline: 2016-07-12
Deadline: 2016-07-15
this month — Return all tasks with a deadline in July 2016:
Deadline: 2016-07-04
Deadline: 2016-07-12
Deadline: 2016-07-15
this quarter — Return all tasks with a deadline from July 2016 through September 2016:
Deadline: 2016-07-04
Deadline: 2016-07-12
Deadline: 2016-07-15
Deadline: 2016-08-11
this year — Return all tasks with a deadline in 2016:
Deadline: 2016-04-17
Deadline: 2016-07-04
Deadline: 2016-07-12
Deadline: 2016-07-15
Deadline: 2016-08-11
tomorrow
next week
next month
next quarter
next year
Return dates within a future time period.
For example, the current date is 15 July 2016 and you perform a search against the following values:
Deadline: 2016-04-17
Deadline: 2016-07-16
Deadline: 2016-07-20
Deadline: 2016-08-11
Deadline: 2016-09-30
Deadline: 2016-11-14
Deadline: 2017-02-12
tomorrow — Return all tasks with a July 16 deadline:
Deadline: 2016-07-16
next week — Return all tasks with a deadline from July 17 through July 23:
Deadline: 2016-07-20
next month — Return all tasks with a deadline in August 2016:
Deadline: 2016-08-11
next quarter — Return all tasks with a deadline from October 2016 through December 2016:
Deadline: 2016-11-14
next year — Return all tasks with a deadline in 2017:
Deadline: 2017-02-12
>
>=
<
<=
Return dates before or after a specified date.
Deadline: 2015-11-22
Deadline: 2016-01-28
Deadline: 2016-04-17
Deadline: 2016-06-21
Deadline: 2016-07-04
Deadline: 2016-08-12
Deadline: 2016-11-30
Deadline: 2017-02-05
> 2016-06-21 — Return all tasks with a deadline after 21 June 2016:
Deadline: 2016-07-04
Deadline: 2016-08-12
Deadline: 2016-11-30
Deadline: 2017-02-05
>= 2016-06-21 — Return all tasks with a deadline on or after 21 June 2016:
Deadline: 2016-06-21
Deadline: 2016-07-04
Deadline: 2016-08-12
Deadline: 2016-11-30
Deadline: 2017-02-05
< 2016-06-21 — Return all tasks with a deadline before 21 June 2016:
Deadline: 2015-11-22
Deadline: 2016-01-28
Deadline: 2016-04-17
<= 2016-06-21 — Return all tasks with a deadline on or before 21 June 2016:
Deadline: 2015-11-22
Deadline: 2016-01-28
Deadline: 2016-04-17
Deadline: 2016-06-21




Was this helpful?