Searching Within Tables
The Search in table field appears on most tables throughout Windchill:
This search field does not perform a typical Windchill search. Instead, it filters the table rows using the information that is visible in the table columns.
The following rules apply when searching within tables:
You are only filtering the data that is currently visible in the table. If you hide a table column, the table search is not applied to the values contained in the hidden column.
The question mark character (?) is processed as a literal character instead of a wildcard.
If you include spaces within your search terms, the spaces are considered literally.
The order of the strings within a value is considered. For example, searching for part design does not return an object with the value “design part.”
You can use an asterisk wildcard (*) to substitute for characters within a string and for spaces between strings. For example, a search for 123*78 would return results for “12345678” and “1234 5 678.”
The asterisk wildcard (*) used at the beginning or ending of a single search string is unnecessary and does not change the filtering behavior.
If you include multiple strings separated by spaces, then the placement of the asterisk wildcard (*) is considered. For more information, see the examples below.
* 
For simplicity, the following examples use only the object name. However, table searches filter all visible column data. For example, if the table includes a State column and you search for w, then all objects that are in the In Work state are returned.
For example, consider a table with the following objects:
Engine.asm
Spotlight 023
material weight specs
Design Guide
Part 890
You perform the following table searches. Highlighted rows indicate the objects that would appear in your search results:
Search in table: g (or g* or *g)
Engine.asm
Spotlight 023
material weight specs
Design Guide
Part 890
All objects with the letter ‘g’ in their names are returned, regardless of whether the ‘g’ appears at the beginning, middle, or end of a string.
Search in table: ig (or ig* or *ig)
Engine.asm
Spotlight 023
material weight specs
Design Guide
Part 890
Even though “Engine.asm” has both a ‘g’ and an ‘i,’ the characters you enter in the search field are not processed on an individual basis unless you include a space between them.
Search in table: i g (or i g* or *i g)
Engine.asm
Spotlight 023
material weight specs
Design Guide
Part 890
No objects are returned. The search includes a space between ‘g’ and ‘i,’ and therefore Windchill considers each a standalone string:
i gWindchill filters for two one-character strings (for example, “Part I G 890”).
i g*Windchill filters for a one-character string (‘i’) followed by another string that begins with ‘g’ (for example, “Part I G890”).
*i gWindchill filters for a string that ends with an ‘i’ followed by another string with one character (for example,“Part 890I G”).
Search in table: ight (or ight* or *ight)
Engine.asm
Spotlight 023
material weight specs
Design Guide
Part 890
Search in table: light (or light* or *light)
Engine.asm
Spotlight 023
material weight specs
Design Guide
Part 890
Search in table: lght (or lght* or *lght)
Engine.asm
Spotlight 023
material weight specs
Design Guide
Part 890
Search in table: l*ght
Engine.asm
Spotlight 023
material weight specs
Design Guide
Part 890
When used in the middle of a search string, the asterisk wildcard character (*) can substitute for one or more characters, including spaces between strings.
Was this helpful?