Before You Begin

This 20-minute OBE shows you how to create a badge type Widget, similar to a Watchlist, that displays a count of records based on an application Query.

In this example, you will use the JD Edwards EnterpriseOne Orchestrator Studio to create a Widget that will display the number of past due orders in EnterpriseOne.

Background

Similar to Watchlists, badge type Widgets can display a count of records in EnterpriseOne. Just like Watchlists, badge type Widgets will display in the Watchlist dropdown (flag), in a composed page Watchlist pane, as composed page tile and as an associated Watchlist on a tile or connector.

Unlike Watchlists though, Widget data comes from an orchestration. In this OBE, the orchestration obtains data from an EnterpriseOne form using a query, which demonstrates that a Widget can get the same data as a Watchlist does.

What Do You Need?

• Access to a JD Edwards EnterpriseOne Release 25 environment with Tools Release 9.2.9.3 or later and the associated Tools roll-up ESU applied. JD Edwards EnterpriseOne Trial Edition running on Oracle Cloud Infrastructure is suitable, but you can use any environment with the proper Tools release.
• An existing “Past Due Orders” Query defined in P43261 – One View Purchase Order Inquiry. If you do not already have it, you can create it.



• Access to Orchestrator Studio.
• Feature security and UDO action security for Widgets (WIDGET).
• Feature security and UDO action security for composite pages (COMPOSITE).

Creating an Orchestration to Get a Count of Past Due Orders

In this task, you will use the Orchestrator Studio to create an orchestration with a form request to count the past due orders.

1. Access the Orchestrator Studio.
2. Click the Form Requests icon and then click the New button.
3. On the Form Request design page, complete these fields:
• Name = Past Due Orders P43261
• Description = Count of Past Due Orders
4. Click the Product Code drop-down list and select a customer product code between 55 – 59.
5. Click the Add Form: First button and enter the following values:
• Application = P43261
• Form = W43261A - One View Purchase Order Inquiry
• Query Name= Past Due Orders
• Bypass Form Processing in Studio= ON
• Turbo Mode= High



6. Click Save and Load.
7. In the Available Actions section on the right, expand Buttons and Exits.
8. Click the Add Action (blue plus) icon in the Find row to add it to the Order of Execution section.
9. On the right, scroll down and:
• Expand One View Purchase Order Inquiry – Grid.
• Enable the Return option in the 2nd Item Number row.
• Enable the Return option in the Include Count row.



10. In the Order of Execution section on the left:
• Click the Edit Returns (blue arrow) icon in the Return Form Data row.
• Enter Grid in the Variable column for One View Purchase Order Inquiry.
• Click Close.



11. Save the Form Request.



12. Click the Manage menu and click Create Orchestration.
    The system creates an orchestration with the name Past Due Orders P43261.
13. Click the Start node and click Inputs and Values. Click the X icon to delete the Version row.
14. Click anywhere outside the Inputs and Values window to close it. Ignore the error on the Form Request.
15. Click the End node and click Outputs and Assertions.
16. Disable all the rows except the Past Due Orders P43261_1 Count row.



17. Save the Orchestration.
18. Double-click the start node to open the Run Orchestrations page.
19. Click Run.
20. Verify that the output includes the count of past due orders.

Creating a Widget to Display the Past Due Order Count

In this task, you will create a Widget to display the result of the orchestration.

1. Close the Run Orchestration page to return to the Orchestration.
2. Click the Manage menu and select Create Widget.
3. On the Widget page, keep the default name and description and enter values in these fields:
   • Title = Past Due Orders
   • Badge Type = Numeric
4. Click the Data Source tab.
   
5. In the Outputs section, in the Value row, from the Orchestration Output drop-down list, select Past Due Orders P43261_1 Count.
6. Enter values for the Warning and Critical thresholds (if desired).



7. Click Save.
8. Click the Preview tab.
9. The Widget will process automatically. Verify that the Rendered Widget section displays the same result when you ran the orchestration. The color depends on the threshold values that you have set (if any).

Displaying the Widget in EnterpriseOne

In this task, you will view the badge Widget in EnterpriseOne and configure a composed page to display that widget.

1. From the Tools drop-down list (top right), select JD Edwards EnterpriseOne.
2. Click the Watchlists (flag) icon at the top of the page to expand the Watchlists drop-down list. Verify that the Widget you created is displayed in the Watchlists drop-down list.



Note: If you don’t see the Widget in the list, sign out of EnterpriseOne and sign back in.
3. Next, you will add the Widget to a composed page. In the menu under your user name, select Manage Content and click Composed Pages.
4. Click the Create New Content button at the top left of the window.
5. Click Watchlist Pane.



6. In the Name field, enter Widgets.
7. Select the Empty Watchlist option.
8. Click OK.



9. Click the Add Item (plus) icon in the single Watchlist box in the designer pane.
10. Select Past Due Orders. This is the Widget you just created. In this list, the Titles (UDO Name) of the Widgets are displayed.



11. Click the Create New Content button again.
12. Select Designer Pane and drag the new pane to the right side of the composed page.





13. Enter the value in the Name field as Widgets.
14. Move the Initial Total Columns and Initial Total Rows sliders to a 2 x 1 grid.
15. Click OK.



16. Hover over the first cell in the new designer pane and click the Add a tile (plus) icon.
17. Enter the following values to create a Widget tile:
• Tile Type = Widget
• Widget = #Past Due Orders (Past Due Orders P43261) - Badge – Numeric
18. Click OK.



19. Hover over the second grid cell in the new designer pane and click the Add a tile (plus) icon.
20. Enter the following values to create an Application Tile:
• Tile Type = Application
• Application ID = P43261
• Associate Watchlists = ON
21. Click OK.
22. Click one of the Associate Watchlists plus icons (top-right for example).



23. In the Associate Watchlist window, select #Past Due Orders (Past Due Orders P43261) - Badge – Numeric from the drop-down list.
    



24. Click OK.
25. Click the Pencil icon next to “Default Page Title” and delete the title.
26. Click the Save button at the top of the composed page designer.
27. Enter a Name for the composed page as Widgets.



28. Click OK.
29. Click the X icon at the top right to close the designer.
    The new composed page now displays the Widget in a Watchlist Pane on the left as a Widget Tile and as an associated Watchlist on an Application tile on the right.



Now you know how to create a badge type Widget to display a count of records just like a Watchlist displays a count of records and you can see that the Widget can be displayed in all the same places a Watchlist is displayed in EnterpriseOne.

Want to Learn More?

• Quick Tour - EnterpriseOne Widgets
• Guide - EnterpriseOne Widgets
  
• OBE - Creating and Displaying Badge Widgets for Most Ordered Item
• OBE - Creating and Displaying a Pie Chart Widget
• OBE - Creating and Displaying a Bar Chart Widget
• OBE- JD Edwards EnterpriseOne Widgets with External Data