We are experiencing a problematic situation when it comes to report using "state" field from "task" table. I want to know if someone has experienced similar use case and knows how to deal with it?
Use case:
We have a list report in the task_sla table, to track information from SLAs assigned to HR Cases (sn_hr_core_case). As you know task_sla table is general and have SLA information from all "task" child tables in the system. In this use case we are interested in the HR Cases (sn_hr_core_case), so we have built a report in the task_sla that contains a filter to only show HR Cases task type records in the report. In this report we need to group by the state of the HR Case linked with SLA, and for that purpose we are using the "group by" option in the report and selecting "task.state".
Problem:
Problem comes when we noticed that the label that is being used by servicenow in the report group by result, does not match with the values that the "state" field can have in the HR Case table. Some screenshots following to show the problem.
- Result of the group by in the report. We see that the label used by servicenow is "Deferred" while the real state of the HR Cases record is "Ready":
- Choices available for state field for HR Cases child type in task parent table, shows that the is no "Deferred" option for HR Cases:
- Looking for all state choices in task table with value "10" (the value that has "Ready" state for HR Cases) we see that "Deferred" state is for other child table (Demand):
Reason:
The reason for this misleading label display is that both choices "Ready" from HR Case table and "Deferred" from Demand table (both child tables of parent Task table) is that both choices has 10 as value, and ServiceNow seems to be choosing one of them to show the label in the group by option in the report.
Question to community:
I don't know the reason why ServiceNow is "by default" choosing "Deferred" choice, when using group by in the report, even if we have filter the data to only show HR Case records.
Is there a way to avoid this to happen, so that in the group by result it is shown "Ready" instead of "Deferred"??
