Add a Custom Saved Search to the Sales Dashboard
Here's how to display a custom saved search on the Sales Dashboard for sales managers either as a table or a list.
Prerequisites
-
Create the custom saved search and share it with the job roles who view the dashboard. Create Saved Searches for the Sales Organization.
-
Display the saved search and copy its UUID. The UUID is displayed in the saved search page's URL.
You will use the UUID when adding the table to the Sales Dashboard in Visual Builder Studio.
Display the Custom Saved Search as a Table in the Sales Dashboard
-
Let's configure a dashboard layout for a manager.
On the Properties pane for the Manager (Copy) layout, review the layout's condition to ensure that the correct role is specified for this layout.
-
Click the + Add Section icon > + New Section.
-
In the Create Section dialog, enter a title,
My Open Leads < 10K
, and click OK.Note: The title is the name of the template, not how the template will appear at runtime on the dashboard. The runtime title comes from the saved search.The newly added section is added to the bottom of the layout. Use the Move Up arrow to move the new section to the desired location.
-
Click the My Open Leads < 10K link.
The template editor opens.
-
Click the Code button.
Your new My Open Leads < 10K section displays with empty placeholder
template
tags. -
For a table, enter this code between the existing placeholder
template
tags.<oj-cx-saleshub-tile> <oj-cx-iss-mini-workspace> </oj-cx-iss-mini-workspace> </oj-cx-saleshub-tile>
Here's a screenshot of the new code for a table:
-
Click the Design button.
-
On the Structure pane, click Sales Hub Tile Container.
-
On the Properties pane, on the All tab, select 6x2 as the size.
If data in the table is too wide for the size you select, then scroll bars automatically display.
-
Still on the Structure pane, click Sales Hub Mini-List Component.
-
On the Properties pane, on the All tab, click the Show sub-properties icon next to the Display Options field.
-
In the Display Option field, select TABLE.
-
In the Maximum rows to display field, enter 3.
The table displays a maximum of 3 rows. If more data exists, then a View All link displays.
Note: To add a list instead of a table, change the value of the Display Option field to LIST. Lists and tables use the same underlying component, Sales Hub Mini-List Component, and are both populated by saved searches.For example, here's a screenshot of creating a template for a list instead of a table:
In addition to adding lists, you can also add a My List component to the Sales Dashboard. For more information about My List, see "My List" in the Oracle Fusion Cloud Sales Automation Using Digital Sales (Next Gen Sales) guide. To add a My List component, set the Display Option field to LIST, click < Display Options, and set the Show My List field to true.
-
Let's continue with the table example. Click < Display Options.
-
In the Type of objects field, select Lead.
Note: A set of attributes is already predefined, per object, to display in the table. You can further modify which attributes display, if required. See "Modify the Columns in a Table Template" in the next section of this topic. -
In the Identifier for Saved Search field, enter the UUID of the saved search.
The UUID refers to the unique identifier of the saved search. The UUID is displayed in the saved search page's URL.
-
Click the Preview button to see your changes in your runtime test environment.
For example:
Modify the Columns in a Table Template
When you add a table to a dashboard, you specify the object that the table pulls its data from. For each object that you can select, Visual Builder Studio knows which attributes to display in the table since default attributes are already predefined. However, you can further modify which attributes display in the table, if desired. You can control three things: which fields to display as columns in the table, the width of those columns, and the column titles. Let's do that now.
-
In the Manager (Copy) layout, click the My Open Leads < 10K template.
-
On the Structure pane, click Sales Hub Mini-List Component.
-
On the Properties pane, on the All tab, copy and paste the attributes you prefer to display in the Name of dynamic form layout field.
Specify your preferred set of attributes using the field names from the object's elastic search payload, arranged in the below format. To override an attribute's display label, enter a headerText value. For example:
[[ [ {mappedField: 'Name', width: 200, template: 'objectDetailLinkCellTemplate'}, {headerText: 'Customer', mappedField: 'CustomerAccount.PartyName', width: 200}, {mappedField: 'DealAmount', width: 100}, {mappedField: 'Owner.PartyName', width: 100} ] ]]
Here's a screenshot of the Name of dynamic form layout field:
-
Click the Preview button to see your changes in your runtime test environment.
Notice the change in the table display: