Search Region

Autocomplete and Suggestions

Autocomplete provides type-ahead suggestions similar to autosuggest. Autocomplete reduces the number of clicks. The suggestions are presented as you type within the Search text box. By default, a set of attributes for each object is configured for autocomplete and keyword search. For example, in item search, the item number and item description attributes are configured for autocomplete and keyword search to support cases where you search for an item number or search for an item using terms within the item description.

Filter Chips

You can refine the search by selecting filters and values based on the data in the search results. The first five to seven filter chips are displayed beneath the Search text box. The other filter chips are available by clicking on the Filters action. These are displayed based on the display order in the view. Filter chips can be enabled only for date and text attributes.

Note: You can’t enable filter chips for long text attributes.

To apply a filter chip, click it to edit the filter chip. Click the chip the second time to display a set of values for filter. It shows a list of values that you can select. Search and select a value and click anywhere on the page. The filter chip is applied on the search results and the table refreshes to display the result based on the applied chip.

Note: The counts show how often a specific value occurs. The values are provided through aggregation of the data in the database for the attribute.

The filter chip might allow you to select another value, or in some cases you can select one or more values. For example, if you want to search for items for manufacturers Aero Tech and Tech Space, you can select both and the search results are filtered.

The last chip beneath the Search text box is the Filters action. Clicking this displays the Filters drawer, where you can select values for the filter chip. You can apply the search criteria to multiple filters in the drawer and click See Results to run the search.

To remove the applied filters, click Clear.

Note: Applying multiple filter chips with specific values selected will be ANDed together as part of the search.

Keyword Search

When the index is created, each attribute is assigned an analyzer, which is used to create searchable content for the attributes. Part of this process is tokenizing the characters in the attributes. Tokens are searchable terms that are part of the index record for the object. The tokenizer will create a set of tokens by reviewing the characters and applying rules to separate the characters into tokens. For example, if the description contains: ‘CAP, CERAMIC, SMD, 0402, 0.22UF, Y5V, 10V, +80/-20%’, the resulting tokens would be ‘CAP’, ‘CERAMIC’, ‘SMD’, ‘O402’, ‘0.22UF’, ‘Y5V’, ‘10V’, ‘+80’ and ‘-20’. Each token is searchable using keyword search.

By default, keyword search is enabled for primary attributes of the objects. For example, for items, keyword search is enabled for item number and item description.

Administrators can turn on the Keyword enable switch for the Item Description attribute for cases where they don’t want a match on the Description field. If the Description attribute value is generated using extensible flexfields, the Administrator can turn off the keyword search and use filter chips to search for content within the Description.

All keyword searches use starts with in the searches.

Use Operators to Perform Keyword Search

You can use the following operators within the search criteria to perform a keyword search.

Operator	Description
+	AND operator.
\| or space	OR operator. Space character is considered OR operator.
*	When used at the end of a term, signifies a prefix query.
"	Search for a group of terms as a phrase. For example, “220 Micro Farads”.
(, )	Wrap a clause for precedence (for example, wind + (capacitor\| cap)).
~n	When used after a term (for example, wnid~3), sets fuzziness. When used after a phrase, sets slop.
-	Negates the term.

Search Content Within Item Descriptions Using Phrase Search

You can use double quotes surrounding a group of search terms to find a match closest to the term and to find one or more terms in a specific order. Use phrase search on item numbers to increase the matches when the item number includes special characters such as hyphen.

For example, if the item description is:

Item Number: CAP-0041 Description: CAP .22 Micro Farads 10mmdx17mml 105s mp LOW Axial y5v 0.05 Ohms 10 Year 100 Celsius -35 Celsius .0017 Amperes 8 % 5 Volt

You can search for "330 Micro Farads", or any other combinations of the terms in the order they appear. When you enter "330 Micro Farads" as the search criteria, the result returns all items that have this phrase. The following screenshot shows multiple items are found that has the phrase 330 Micro Farads and Capacitors_DQ_MM_1 is one of the items in the search results.

Search Using Query

When you don’t know the part number, you can use a combination of operators, phrase search, and filter chips to form a query. For example, the Design Engineer needs a capacitor in the micro farads range and can use 15 volts. The Design Engineer knows that there are one or more item classes for capacitor and uses the Item Class filter chip to select one of the item classes. Next the Design Engineer enters the following query in the search box:

Cap + "Micro Farads" + "15 Volt"

where:

Cap is the keyword to do a keyword search for all part numbers starting with Cap
+ is the AND operator
"Micro Farads" is in phrase search format
+ is the AND operator
"15 Volt" is in phrase search format

The result of the query returns three parts. Next, the Design Engineer can add additional attributes using the View Selector to refine the part to use.

You can use the operators to construct complex queries by combining them with terms in the Search box. The formulated query can also be used with filter chips. As example, you can select a filter value for an item class such as 'Capacitors' and combine it with terms such as 'Axial', the AND operator '+', and the term 'Micro' to search for all items within the Capacitor item class that use the Axial mounting and are in the Micro Farads capacitor value range.

Use multiple search terms with operators and filter chips together to form a query.

Expert users can use additional operators to form complex queries.

Note: To use the search using query feature, contact Oracle support.

Special Characters in Search Query

You can extend the search using the following special characters in the Search box:

List of Items: You can search for multiple numbers for an object by entering them with spaces. For example, if you’re searching for three items AS1, AS16903, or AS16901, enter the complete item number separated by spaces. Each of these items are displayed in the search results. You will also find additional items that start with these strings.
Item Numbers with Hyphen or Underscore: To search item numbers that contain hyphens such as 06-CMM-SL, enter “06-CMM” with double quotes in the Search box. You can also find ITEM_GSE_123 by entering “ITEM_GSE”. Additional items are displayed in the search results that start with these strings in the item number separated by hyphen and/or underscore.
Separators: Special characters such as comma, colon, space, slash, back slash, hyphen, pipe, number sign, underscore, or dash are used in attribute values that have multiple terms. For example, a description such as ‘DUCT,COVER,2.0"X 6FT,PANDUIT,WHITE’ contains multiple separators. The ingest process uses the separators to break the value into searchable tokens.