Creating a Search Category for JD Edwards EnterpriseOne Search


Options



Before You Begin

Purpose

This Oracle by Example (OBE) provides instructions for creating Search Categories for JD Edwards EnterpriseOne Search.

Time to Complete

15 min

Background

JD Edwards EnterpriseOne Search is implemented as a standalone EnterpriseOne Page that provides a search-engine type of experience within JD Edwards EnterpriseOne. The EnterpriseOne Page uses configurable Search Categories (SC) and the Application Interface Services (AIS) Data Service to easily search over all business data. SC’s are hand-coded JSON files that define the types of entities the JD Edwards EnterpriseOne Search will be able to locate. SC’s are placed in the subdirectory “search_categories” with each category as its own .jsfile. The .js file defines a single object that is the category and then pass that object as an argument to a method called “registerSearchCategory”.

The SC defines:

  • What table or view is being queried?
  • What column(s) within that table/view are you considering for finding a match?
  • How are search results to be rendered?
  • What is the on-click action for a search result?
  • Related actions or pieces of related information to display?

Scenario

You need a Search Category to locate work order information from the Work Order Master File table (F4801). You want to be able to search on Description (DL01) and Order Number (DOCO) while returning the Description (DL01), Order Number (DOCO), and Work Order Status (SRST).

What Do You Need?

To perform the steps in this tutorial, you must have:

  • Installed tools release 9.2.0.2 with applications 9.2 and higher.
  • Downloaded and applied UDO_9.2_10024 (bug number: 24311077) Electronic Software Update (ESU) from the Oracle JD Edwards EnterpriseOne Update Center.
  • A text editor suitable for editing JSON files.


Creating a New Search Category

  1. From the Role dropdown, click Classic Pages under Manage Content to access the E1Page Manager:

    Role Dropdown Menu
    Role Dropdown Menu

  2. Select EnterpriseOne Search (H98) in the Name field and click Download:

    E1Page Manager
    E1Page Manager

  3. Save the EnterpriseOne_Search.zip to your local drive and unzip the file.

  4. Open the search_categories directory and copy the tasks.js.
  5. Name the file workorders.js.
  6. Right-click the file and click Edit.
  7. Edit the file with the following values:
    Element
    		 Value
    var
    		 sc_workorders
    id:
    		 workorders
    name:
    		 Work Orders
    target:
    		 F4801
    targetType:
    		 Table
    searchColumns
    		 DL01
    DOCO
    isNumeric:
    		 DOCO: true
    returnColumns
    		 DL01
    DOCO
    SRST
    caseInsensitive: True
    numResults:
    		 12
    rendering:
          topLineText:
          bottomLineText:
    DL01
    Work Order: DOCO - Status SRST
    preRender:
    		 Remove this element.
    onclick:
    		 function(resultObj, event,htmlElem
    console.log
    		 Remove this element.
    Top.doFastPath
    		 //rem the statement out
    registerSearchCategory
    		 sc_workorders

    The workorders.js file should look like the screenshot below.
    E1Page Manager
    workorders.js
  8. Save and close the workorders.js file.
  9. Navigate t the directory where you unzipped the EnterpriseOne_Search.zip file.
  10. Open the home.html file for editing.
  11. Add the following line to the bottom of the <head> section:

    <script type="text/javascript" language="javascript" src="search_categories/workorders.js" ></script>
  12. Save and close the home.html file.
  13. Zip all contents in the directory.
  14. Return to the E1Page Manager and import the new EnterpriseOne Search page.
    Work Orders Search Results
    Work Orders Search Results

Want to Learn More?