1. Using Product Master Data Management
  2. Use Quick Search to Find Items in the Work Area

Use Quick Search to Find Items in the Work Area

When you use the quick search in the panel drawer of the Product Information Management work area to search for items, you can refine your search with these techniques.

Searching for Items

The following are some of the ways the application searches for items:

Autosuggest Search

As you enter at least three characters into the Search field, up to 15 suggested values are automatically displayed in a list. Select a value from the list.

You can adjust the search delay (in seconds) through the Item Search Type Delay (ORA_EGP_ITEM_SEARCH_TYPE_DELAY) profile option. The valid profile values are 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, where the value 1 is the standard time to start searching and is the default profile value. To increase the search delay, increase the value.

Keyword Search

In the Manage Items page, you can use a subset of search operators in the Keyword search field. The Manage Item Keyword Search Attributes task in the Setup and Maintenance work area allows item attributes and additional attributes for some child objects of items including item relationships, trading partner items, item supplier attributes, and item category assignments. Keyword search will search across all content that’s indexed. For example, if you search using the term AC123, it may be found as an item number, item relationship attribute, category name, or trading partner item.

Within Operator

The within operator allows the narrowing of a query into document sections. Document sections can be one of the following:

  • Zone Sections

  • Field Sections

  • Attribute Sections

  • Special Sections (sentence or paragraph)

When searching for an item by keyword, it’s possible to restrict the search to a specific section of the item keyword index. For example, if you want to search for a term within the Description for an item, the field name of the index section must be used in the search. The attributes you want to search for must be added to the keyword index using the Manage Item Keyword Search Attributes task in the Setup and Maintenance work area.

To search keywords within Description, use:

<keyword> within shortdesc (Capacitor within shortdesc)

To search keywords within Long Description, use:

<keyword> within longdesc (AC11 within longdesc)

To search keywords within Formatted Description, use:

<keyword> within htmlLongDesc (AC12 within htmlLongDesc)

To search keywords within Item Number use:

<keyword> within item (AC1_AUTO_SEARCH within item)

To search keywords within Item Class use:

<keyword> within itemclass (Capacitor within itemclass)

To search keyword within a specific extensible flexfield attribute, use:

<keyword> within <internal code of the extensible flexfield attribute> (Capacitor Type with itemEff)

To search keyword within any Trading Partner Items, use:

<keyword > within tradingPartnerItems (Samsung within tradingPartnerItems)

To search keyword within any Item Relationships, use:

<keyword > within itemRelationships (ASN123 within itemRelationships)

OR Operator

The OR operator allows searching where at least one occurrence of any query terms exists. For example, search keyword is:

Capacitor OR Resistor

Note: Arithmetic Operator "|" isn’t supported (Capacitor|Resistor). The search returns all items that have the term Capacitor or the Resistor.

AND Operator

The AND operator allows searching where at least one occurrence of each query term exists. For example, search keyword is:

Capacitor AND Resistor

Note: Arithmetic Operator "&" isn’t supported (Capacitor&Resistor). The search returns all items that have both the Capacitor and Resistor terms.

NOT Operator

The NOT operator allows searching where at least one occurrence of the query terms exists excluding one term. For example, search keyword is:

AC123% NOT AC1234

If item numbers AC123, AC1234, AC12345 exist, the search returns AC123 and AC12345.

Note: Arithmetic Operator "~" isn’t supported (AC123%~AC1234).

Wildcards Operator %

You can use percent sign (%) to enhance your search. It matches 0 or more characters. For example, search keyword is IN1234%.

You can only use "%" as the last character in the search term. The search returns all items that have the starting term before the percent sign. If AC123, AC1234, and AC12345 item numbers exist and the search string is "AC123%", then AC123, AC1234, and AC12345 are returned.

Word Stemming

Word stemming lets word stems such as run to match other parts of speech such as ran, running, and runs. Word stemming requires that a dictionary be installed by the administrator and word stemming enabled for search. The operator stem ($), where $ is the word you want to search using stemming, is used for stemming in search criterion.

Escaped Characters

Some characters are used for additional search types and are escaped or not used in search. For example, "$" is used in word stemming and can’t be used in search terms (AS1$1234), the "$" won’t be searchable.

Here’s the list of escaped characters.

Operator Operator Operator Operator
# " [ ]
( ) } {
; = $ \\
* > _ ~
, @ + :
I . &

Related Topics