![]() |
Wildcards, such as * or ?, and logical operators, such as AND (&) and
OR (|), are used extensively in Standard Search. These
operators or wildcards narrow the search, decreasing search time. When a
database contains a large amount of data, a global search with no
specific conditions can slow the system, resulting in a long search
time, and many unnecessary results. Therefore, wildcards and logical
operators can help you save time and improve your search results. In the Standard Search feature, you can enter a value or a portion of the value for a property using wildcards. These wild card characters are valid for Standard Search:
Searches can be refined using relational operators such as AND (&), OR (|), and NOT (!). These operators allow you to search for multiple values for the same property, or to specify what not to include in a search. These are some of the relational operators that are valid for Standard Search:
|
![]() |
WildcardsWhen searching for items using wildcards, consider the following examples:
Note: The asterisk "*" cannot be used alone to have Standard Search look for a single character. Using a single asterisk for an attribute value will result in a list of all items. Relational OperatorsThe following table lists the relational operators valid for Standard Search. You can combine wildcards and relational operators when searching.
Special CharactersSpecial characters, many of which serve as wildcards or relational operators, may be contained in attribute values. For example, Flint & Company may be a manufacturer name. In this case the & character does not represent a relational operator, but is actually part of the name. Likewise, you may have an item number that includes brackets, such as 505[000]. To search for these correctly, you either have to place a backslash (\) character before the special character, or enclose the search string containing the special character in double quotes, so that the character is interpreted correctly. The following table provides a couple of examples:
This table lists all the characters that require special handling in Standard Search:
Date SearchesYou can search on date properties using most of the same operators you use for numeric searches. When you enter a date, you must use the exact date format that is specified. For example, if you are using the date format DD-MON-YY, you must enter the full date to get the search results.You also need to specify a wildcard attribute at the end of the search string if the date format includes the time. Thus, if you want to search all items with a date field that matches March 4, 2001, you can enter 04-Mar-01* to get the search results. You can also use operators such as, greater than (>) and, less than (<) to specify a range of dates. In this instance, wildcards are not necessary because you are not looking for an exact match. For example, to search for all items that fall between February 1, 2001, and February 28, 2001, enter > 01-FEB-01 & < 28-FEB-01. The only operator you cannot use is the range (:). Dates are not case-sensitive. |
![]() |
This task explains how to obtain search results using wildcards and operators: | |||||||||||||||||||||||||||||||||||
![]() |
This example assumes that a database including manufacturer information exists and is accessed by CATIA Client. | |||||||||||||||||||||||||||||||||||
![]() |
|
|||||||||||||||||||||||||||||||||||
![]() |
Sourcing Search Window
This table describes the fields displayed in the Sourcing Search window and the Standard Search tab of the Sourcing Search window.
This table describes the buttons displayed in the Sourcing Search window and the Standard Search tab of the Sourcing Search window:
|