Understanding the Search Framework Search Engine

This section discusses the ways available to use the Search Framework search engine capability and the predefined Order Management data object sets, search queries and search query data.

Customer Service Representatives (CSRs) often need to locate products or customers. The Search Framework offers CSRs a flexible search mechanism. The Search Framework searches records and fields to locate the requested information. For instance, if a CSR wanted to find all items with a specific description, he would identify the description on the search page and the search engine would locate the information from data contained in the specified records and fields.

PeopleSoft Order Management is delivered with Search Framework search engine capability. The Search Framework collection is predefined but can be expanded if necessary.

Three ways are available to use the Search Framework capability that is provided with PeopleSoft Order Management.

  • Use the predefined search collection and do not add fields to the search or the search results page.

  • Add additional fields as searchable criteria but do not add these fields to the search results page.

  • Add additional fields to the search and result pages.

PeopleSoft Order Management is shipped with a predefined Search Framework collection, which is a grouping of fields that are used by the Search Framework search engine to index and assist users in their search for products. To use the base Search Framework collection, you need to enable the Search Framework option on the Order Management Installation Options page.

You can add fields to the Search Framework collection if you want to expand the list of fields that you can use to perform such search.

When you add fields to the collection, you can use either batch updates and rebuild or incremental updates to build Search Framework index collections. You then perform searches against this collection.

Use the PeopleSoft Application Engine process (SAC_IDX_DATA) to build the Search Framework collection, which is accessible from the Build Search Framework page. This process extracts data from the database and writes a few intermediate text files: the BIF files and the DAT files. These files are indexed into the Search Framework collection, which comprises multiple file folders.

Adding a field to the results page of the Search Framework search engine is slightly more complicated. You need to add the field to the Search Framework and rebuild the index but you also need to use the Application Designer to add the new search fields to the Order Entry Search Framework page (ORDENT_VERITY_SEC).

Several predefined data object sets are shipped with PeopleSoft Order Management. The tables will include all system data:

Record Name

Description

Sample Where Clause

SAC_IDX_DOS_HDR

Data Object Set Header

DOSET_NAME = 'OM_CUST_SOLDTO'

SAC_IDX_DOS_LN

Data Object Set Line

DOSET_NAME = 'OM_CUST_SOLDTO'

SAC_IDX_TBL

Search Index Table

INDEXNAME = 'OM_CUST_SOLDTO'

SAC_IDX_FIELDS

Search Index Fields

INDEXNAME = 'OM_CUST_SOLDTO'

SAC_IDX_DOS_XRF

Search Index and DO Set Cross Reference

INDEXNAME = 'OM_CUST_SOLDTO'

Several predefined search queries are shipped with PeopleSoft Order Management. The tables will include all system data:

Record Name

Description

Sample Where Clause

SAC_SRCH_QRY

Search Query

SRCH_QRY_ID = 'OM_CUST_SOLDTO'

SAC_SRCH_QRYFLDS

Search Query Fields

SRCH_QRY_ID = 'OM_CUST_SOLDTO'

Several predefined search query data sets shipped with PeopleSoft Order Management. The tables will include all system data:

Record Name

Description

Sample Where Clause

SAC_SRCH_RSLT

Search Result

SRCH_RSLT_ID = 'OM_CUST_SOLDTO'

SAC_SRCH_RSLTFDS

Search Result Fields

SRCH_RSLT_ID = 'OM_CUST_SOLDTO'

SAC_SRCH_RLTQRY

Search Result Query Association

SRCH_RSLT_ID = 'OM_CUST_SOLDTO'