Oracle® Fusion Applications Product Information Management Implementation Guide 11g Release 7 (11.1.7) Part Number E20387-07

Home

Contents

Book List

Contact Us

Previous

Next

PDF

17 Regional and Local Area Search

This chapter contains the following:

Regional Item Work Area Search

Local Item Search Parameters

Regional Item Work Area Search

A regional search in the Item work area provides modes for general-item searches, including, Autosuggest, Key Word Search, and SQL searching.

The autosuggest option is enabled for the input field of the regional area.

Regional Item Search Parameters

The following are some of the parameters for Regional Item Search.

Autosuggest is enabled for the item input text box in the Regional Area search. As you enter characters into the item input text box, suggested search topics are displayed in a drop-down list. Select a value from the drop-down list and click the Go icon to initiate your search.

SQL search is available only in the local area of the Item work area. To access it, click the Advanced link of the Item regional area search. For more details, see Local Area Item Search, below.

Oracle Text technology provides keyword searching capabilities that uses data extracted from values in the items table and set up in an indexed file. The indexed data is set up by the administrator and is set up to run periodically.Additional indexes can be added by the administrator as needed. By default, regional search uses the following item attributes in the index:

• Item Number

• Description

• Item Class

• Long Description

• Organization Code

• Manufacturer

The Oracle Text search engine can be configured by the administrator to support features including:

• Word Stemming

• Wildcards

• Synonym Matches

• Fuzzy Searching

• Dictionary Matching

• Soundex Searching

Oracle Text is case insensitive.

The operators in the following table can be used with search expressions:

You can use the following wildcards, which are features of Oracle Text search, to enhance your search:

• Percent sign (%) matches 0 or more characters

• Underscore (_) matches 0 or 1 character

• Backslash (\) escapes wildcard characters (%_, or \)

Word stemming allows 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 wish to search using stemming, is used for stemming in search criterion.

The fuzzy operator is used to expand a query to include words that are spelled similarly to the term entered in the search criterion. The fuzzy operator is helpful for finding accurate results when there is frequent misspelling.

The synonym operator SYN enables the query to be expanded to include terms that are defined in a thesaurus as synonyms for specified terms.

The soundex operator ! enables the query to be expanded to include words that have similar sounds. This function enables comparison of words that are spelled differently, but sound alike in English or a 7-bit character set. For examples search '!Smythe' might return 'Smith'.

Oracle Text allows users to join keywords such as AND or OR within a single search criterion. Additionally, quotes can be used to indicate that characters within the quotes are to be searched in exact order.

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

• Zone Sections

• Field Sections

• Attribute Sections

• Special Sections (sentence or paragraph)

The ABOUT operator allows the return of documents that are related to a query term or phrase. In English and French, ABOUT enables you to query on concepts, even if a concept is not actually part of a query. For example, an ABOUT query on heat might return documents related to temperature, even though the term temperature is not part of the query.

The AND operator allows searching where at least one occurrence of each of the query terms exists. The OR operator allows searching where at least one occurrence of any of the query terms exist.

Dictionary matching of the search terms can be enabled and requires a dictionary to be set up for the search. The spelling of terms in the input fields is checked against the dictionary to provide corrections to term misspellings.

Local Item Search Parameters

A local area search in the Item work area provides modes for general-item searches, including, Autosuggest, Key Word Search, and SQL searching.

Local Area Item Search Parameters

Item local area search is available in the Manage Items page and provides a search region in which users can enter values in one or more search fields, add search fields, and trigger the search.

The Manage Items search region has a default saved search, which defines the search fields that are displayed when the Manage Items page is initially opened. You can define your personal saved searches consisting of search fields to be used in the search. The seeded saved searches and personal saved searches are selected in the saved search drop list.

The Manage Item SQL follows the standards for search, but there are minor differences between the regional area or local area search and are listed below.

Multicharacter Wildcards: "%" and "*" must be interpreted as a wildcard that matches any character string, including spaces and special characters.

Single-Character Wildcards: "_" must be interpreted as a wildcard that matches any single character.

Literals: Literal "_", "%" and "*" characters must be preceded by the escape character "\"

As you select conditions for a search, drop-down lists will display only values that are appropriate to the scope of your search.

Some search fields are required. A blue asterisk indicates a require field. Two green asterisks indicate that at least one in a set of search fields is required.

The Keyword search field is added to the search region to allow the user to search both with SQL and with keyword search. The keyword search field uses the same features as the regional area search, except that the autosuggest feature is not available. When a user enters values for both the keyword search fields and other search fields, the keyword search and SQL search are performed separately. The results from both are displayed in the search result table.

Previous

Next

Copyright ©  2011-2013, Oracle and/or its affiliates. All rights reserved. Legal Notices

Home

Contents

Book List

Contact Us