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' |