Search Range for Numbers

Windchill Fundamentals > Windchill Search > Search Reference > Search Range for Numbers

When you perform a Criteria search that includes Real Number and Real Number with Unit values, Windchill allows a certain range when returning search results.

For example, you create the following parts:

Part	Weight
Bearing-987	8.0377
Bearing-x55	8.0383
Bearing-n7v2	8.0388

You perform an advanced search for parts based on their weight. You supply a criteria value of 8.038:

Windchill applies a rounding range to searches. As a result, the search would return weights with a range of 8.0375 to 8.0385:

Part	Weight	Returned?
Bearing-987	8.0377	Yes
Bearing-x55	8.0383	Yes
Bearing-n7v2	8.0388	No

The basic rules for rounding ranges is that the range includes numbers that, when rounded, equal the search value input. In the example above, 8.0388 rounds to 8.039, therefore disqualifying it from the search results.

If your display unit is set to a different unit than the base unit (for example, if you have length displayed as inches but Windchill stores the length in centimeters), ranges are applied using the base unit. This can affect which results you see. For more information, see Search Range and Base Unit Conversion.

Rounding

As another example, you perform a search for objects that have a certain attribute value. When performing the search, you enter 1.74 as your attribute value search criteria:

Object attribute value	Included in results?	Explanation
1.7408	Yes	1.740 rounds to 1.74.
1.73611	Yes	1.736 rounds to 1.74.
1.7308	No	1.730 rounds to 1.73.
1.74611	No	1.746 rounds to 1.75.
1.73	No	Numbers that are eligible must be within a roundable range from your initial search value. This extends roughly 0.5 greater than or less than the least significant digit (the last number in your search value). • For example, if you input 1.74, your results will include all values that, when rounded, fall into the range of 1.735 to 1.745. • If you input 1.740, your results will include all values that, when rounded, fall into the range of 1.7395 to 1.7405. To return 1.73 and 1.74 within the same search, you would need to enter 1.7 as your search criteria. This search would include results that, when rounded, fall into the range of 1.65 to 1.75.

The rounding range only applies to one more digit beyond the least significant digit in the search input. Therefore, if you search for 1.4, an object with a value of 1.3489 is not returned even though it ultimately rounds to 1.4.

Given a search input of 1.4, Windchill only evaluates up to E-2. In this case, 1.3489 is treated as 1.34, which rounds to 1.3 (which is not a match). However, if you search for 1.35, then 1.3489 is rounded from E-3 (1.348), which rounds to 1.35 is a match.

The way that rounding ranges are applied means that you can search for very precise numbers without using many digits in your search term. For example, 1.28378 rounds to:

• 1.2838

• 1.284

• 1.28

• 1.3

Therefore, if you wish to search for an object that has an attribute value of 1.28378, you can input any of the numbers listed above.

The exception is when your search term is an integer. If you are searching for an integer, an extremely limited range is applied. The range adds and subtracts 5E-14.

For example, a search for 16 would return results from 15.99999999999995 to 16.00000000000005.

Rounding from 5

The key to how Windchill calculates number ranges is how the number 5 is processed. In typical usage, numbers round up from 5. Therefore, 85 rounds to 90, and 11.5 rounds to 12, and so on.

However, Windchill applies the following rule when rounding from 5: When the least significant digit is 5, whether you round up or down depends on the preceding digit.

If the preceding digit is even, then you round down:

• 4.125 rounds to 4.12

• 4.145 rounds to 4.14

• 4.165 rounds to 4.16

If the preceding digit is odd, then you round up:

• 4.115 rounds to 4.12

• 4.135 rounds to 4.14

• 4.155 rounds to 4.16

As a result, when you are rounding from 5, you are always rounding to an even number.

Exclusive vs. Inclusive

Given the following rules:

• To be included in the search results, the number must be within a range that, when rounded, equals the search input value.

• When rounding from 5, if the preceding digit is even, the number is rounded down

The range of values returned is different depending on whether your search ends on an even or odd digit. The range is either inclusive or exclusive:

• When an inclusive range is applied, the range includes the upper and lower boundaries. If the least significant digit is even, the range is inclusive.

For example, given the search input 3.4, the range of values includes all numbers that, when rounded, are greater than or equal to 3.35 and are also less than or equal to 3.45.

• When an exclusive range is applied, the range excludes the upper and lower boundaries. If the least significant digit is odd, the range is exclusive.

For example, given the search input 3.3, the range of values includes all numbers that, when rounded, are greater than 3.25 and are also less than 3.35.

Therefore, the range of values returned is slightly larger when your search input ends on an even digit.

Criteria Operators

When you perform an advanced search for numbers, you can use different operators. Ranges are still applied when using the greater than and less than operators.

Whether the initial range is inclusive or exclusive affects your results.

Search Criteria	Result Range
0.48	Because your input value ends in an even number, this is an inclusive range: • Greater than or equal to 0.475 • Less than or equal to 0.485
0.48	Less than 0.475.
0.48	Less than or equal to 0.485.
0.48	Greater than 0.485.
0.48	Greater than or equal to 0.475.