Dear Community Members,
This is post to share how to apply a specific list view, when clicking on the link "View all" in a Simple List data visualization widget. It may be not a frequent scenario, but for those who need a solution, here it comes.
Note: there could be an alternative approach by configuring an event through UI Builder, however the following solution is simpler and based purely on the data visualization widget.
Use case: you want to add some reports in your workspace within a dashboard page, and you use Platform Analytics; you want to create a Simple List data visualization, to show to the user a list of records, and let the user click "View all" to drill down into the table's full list, where you want to apply a specific list view for the columns to show (not the default view for the table).
Example of the "View all":
Solution: in the Data Visualization editor, as per Yokohama patch5 there is no option to set which list view to apply after clicking "view all", hence to configure it you may want to:
1. open the widget record
(to do that, you can either enter the "Edit" mode in the dashboard > click the 3 dots appearing on the widget > click "Open record"; alternatively, you can search for the widget in the "par_dashboard_widget" table)
2. in the widget record, make sure that the field "Widget Properties" is visible (usually it is, ootb), otherwise add it to the layout, and fill it with this property:
{"drilldownListView": "technical_name_of_list_view_to_use"}
Since the dashboards are cached, the final step you is to clear the dashboard cache by:
1. navigate to table PAR Dashboard Metadata Caches (par_dashboard_cache)
2. in the list, search for your dashboard
3. delete the record: it will be re-created at the next dashboard visualization, inserting the new version in the cache
Hope this will be useful.
Feel free to thumb this post up, if it helped you.
Thanks.
