Search Region

You can enter all search queries in the Search text box. This text box combines user entered search data as a query. When you start typing in the Search text box, the search provides suggestions based on the data entered. Clicking on a suggestion performs the search.

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.

Note: Autocomplete and suggestions are enabled by default for Item Number and Item Description attributes.

Suggested Filters

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

Note: You can’t enable suggested filters for long text attributes.

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

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 suggested filter might allow you to select another value, or sometimes you can select one or more values. For example, to search for items for manufacturers Aero Tech and Tech Space, you can select both and the search results are filtered based on your selection.

The following table provides the various suggested filters.

Filter Type	Filter Name	Description
Filters for Dates/Time	Rolling Period	This filter allows the user to select one or more periods when the view is configured. The periods include: Previous hour Previous 2 hours Previous 24 hours Previous 48 hours Previous week Previous 2 weeks Previous month Previous 2 months When the filter is applied in the search user interface, the user can select a period and the display value for the attribute is filtered based on the selection.
	Date Range Selector	This filter allows the user to define a range for date. The date range will be use to filter the display value for the attribute.
Filters for Numbers	Number Facet	This filter presents a set of operators that you can select to filter the display value for the attribute. Filter will display addition fields to support the operator. For example: if the user selects Between, the filter will display fields to enter the Minimum and Maximum values.
Filters for Attributes with List of Values	MultiSelectLOV	This filter displays the value choices bases on usage count and you can search for addition values.
	Checkbox	This filter display values and you can select one value using the checkbox.

The Filters action is available beneath the Search field at the end. Clicking this displays the Filters drawer, where you can select values for the suggested filter. 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 suggested filters 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 suggested filters 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. Operators are enabled by using the Simple Query String Search (ORA_EGP_SIMPLE_QUERY_STRING_SEARCH) profile option. You can set the value to Yes to enable operators.

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.

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 suggested filters 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 suggested filter 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 suggested filters. 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 suggested filters together to form a query.

Expert users can use additional operators to form complex queries.

Search Using Prefix Search

Attributes such as a part number might often use a prefix term as part of the value. The prefix term maybe followed by additional terms often separated by special characters. For example, part number SC-MAKE-IT1 is a base part and the part numbers SC-MAKE-IT1-Body represents the body of the part. You can use the prefix search to find all the part numbers with the prefix SC-MAKE_IT1 by adding a ‘*’ asterisk.

Assume you've a set of part numbers: SC-MAKE-IT1, SC-MAKE-IT1-Body, SC-MAKE-IT1-TOP, SC-MAKE-IT1-CAP, SC-MAKE-IT1-FRAME, and SC-MAKE-IT1-BASE

You can search using SC-MAKE-IT1* to find all part numbers with prefix SC-MAKE-IT1.