Data visualization (chart) not updating the List view in Service Operations Workspace when clicked
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-17-2024 11:33 PM
Problem: Clicking a part of Unassigned tasks chart when grouped by "urgency" is not filtering the list view.
The Unassigned Tasks chart is working when the grouped by is any of the ff: priority, sys_class_name, state.
Background:
We made some changes to the data visualizations in SOW landing page. The landing page chart displays
Unassigned Tasks grouped by urgency
Task SLA grouped by time_left
Assigned Tasks group by sys_class_name
Here is the current script
SowIncidentLandingPageUtils
function include({imports}) {
let serviceDeskLandingPageUtilsSNC = imports['sn_sow_inc.SowIncidentLandingPageUtilsSNC']();
class ServiceDeskLandingPageUtils extends serviceDeskLandingPageUtilsSNC {
static async getVisualizationConfig(helpers, mode) {
const evamDef = this.getEvamDef();
const visualizationConfig = [
{
"id": "unassigned_tasks",
"tableName": "task",
"tableDisplayValue": "Task",
"myWorkQuery": "active=true^assigned_toISEMPTY^assignment_groupDYNAMICd6435e965f510100a9ad2572f2b47744",
"myTeamQuery": "active=true^assigned_toISEMPTY^assignment_groupDYNAMICd6435e965f510100a9ad2572f2b47744",
"listView": mode == "your_work" ? "sow_landing_page_assigned" : "sow_landing_page",
"header": await helpers.translate("Team Unassigned Tickets"),
"groupByField": "urgency",
"evamId": "615d205d94df0110f87765e94545da03",
"updated_on": "^ORDERBYDESCsys_updated_on",
},
{
"id": "incident_sla",
"tableName": "task_sla",
"tableDisplayValue": "Task SLA",
"myWorkQuery": "task.assigned_toDYNAMIC90d1921e5f510100a9ad2572f2b477fe^task.active=true^sla.type=SLA^ORsla.type=OLA^active=true^time_left<=1970-01-08 00:00:00",
"myTeamQuery": "task.assignment_groupDYNAMICd6435e965f510100a9ad2572f2b47744^task.active=true^sla.type=SLA^ORsla.type=OLA^active=true^time_left<=1970-01-08 00:00:00",
"listView": 'sow_landing_page',
"header": await helpers.translate("Tickets Breached or Close to Breaching"),
"groupByField": "time_left",
"evamId": evamDef['incidentSlaEvamDefinitionId'],
"updated_on": "^ORDERBYtime_left",
},
{
"id": "task_assigned",
"tableName": "task",
"tableDisplayValue": "Task",
"myWorkQuery": "active=true^assigned_toDYNAMIC90d1921e5f510100a9ad2572f2b477fe",
"myTeamQuery": "active=true^assigned_toISNOTEMPTY^assignment_groupDYNAMICd6435e965f510100a9ad2572f2b47744",
"listView": mode == "your_work" ? "sow_landing_page_assigned" : "sow_landing_page",
"header": mode == 'your_work' ? await helpers.translate("My Assigned Tickets") : await helpers.translate("Team Assigned Tickets"),
"groupByField": "sys_class_name",
"evamId": "615d205d94df0110f87765e94545da03",
"updated_on": "^ORDERBYDESCsys_updated_on",
}
];
return visualizationConfig;
}
static async fetchTitle(table, nameValueMap, groupByLabel, groupMode = false) {
const groupByField = this.getFieldMap()[groupByLabel];
return this.getLabelMaps(table, nameValueMap[groupByField], groupByField, groupMode);
}
static getLabelMaps(table, selectedField, groupByField, groupMode = false) {
const labelMap = {
'incident': {
'state': {
'1': 'New incidents',
'2': 'In Progress incidents',
'3': 'On Hold incidents',
'6': 'Resolved incidents'
},
'priority': {
'1': 'P1 unassigned incidents',
'2': 'P2 unassigned incidents',
'3': 'P3 unassigned incidents',
'4': 'P4 unassigned incidents',
'5': 'P5 unassigned incidents'
}
},
'sc_task': {
'state': {
'-5': 'Pending catalog tasks',
'1': 'Open catalog tasks',
'2': 'Work in progress catalog tasks'
}
},
'task': {
'sys_class_name': {
'sc_task': 'Catalog tasks',
'incident': 'Incidents',
'incident_task': 'Incident Tasks',
'change_request': 'Change Requests',
'idea': 'Ideas',
'rm_story': 'Stories',
'universal_request': 'Universal Requests',
'sprint': 'Sprints',
'kb_feedback_task': 'Knowledge Feedback Tasks',
'kb_feedback': 'Knowledge Feedback'
},
'state': {
'-5': 'Pending',
'1': 'Open',
'2': 'Work in progress'
},
'urgency': {
'1': '1 - High',
'2': '2 - Medium',
'3': '3 - Low'
}
}
};
if((table == 'task' && groupByField == 'urgency') || table == 'task')
return labelMap[table][groupByField][selectedField];
if (groupMode)
return labelMap[table][groupByField][selectedField] + ' assigned to your team';
return labelMap[table][groupByField][selectedField] + ' assigned to you';
}
}
return ServiceDeskLandingPageUtils;
}
0 REPLIES 0