CIO Dashboard - Sorting Metrics
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-24-2023 06:27 AM
When adding indicators in the sn_ciodashboard_cio_dashboard_metrics_config, I've encountered that the metrics cannot be sorted (the way of order it should be displayed) even if Order values are being supplied.
The way to fix this is to add a Sort code in getMetricsOfCIODashboard in the Data Broker Server Script
find this line of code and insert the line as mentioned
while (ciodVerticalGr.next()) {
var cioGr = new GlideRecord('sn_ciodashboard_cio_dashboard_metrics_config');
cioGr.addQuery('tab', tabID);
cioGr.addQuery('vertical', ciodVerticalGr.getValue('vertical'));
cioGr.orderBy('order'); //<--- add this code
cioGr.query();
var headlineMetrics = [];
var supportingMetrics = [];
This should fix the Order of indicators being displayed based on what you set on the Order field
- 434 Views
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-22-2024 12:21 PM
@Chio , could you share where this data broker server script is located? Thanks!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
3 weeks ago
Hi, I found the table :"sys_ux_data_broker_transform".