Windchill Fundamentals > Windchill Search > Search Reference > Search Range for Numbers
  
Search Range for Numbers
When you perform a search that includes Real Number and Real Number with Unit values, Windchill allows a certain range when returning search results.
* 
When searching for Real Number with Unit values, the range is calculated using the base unit. This unit might be different than your display unit.
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.
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.