Report on task table with more than 1 task shows labels of tasks instead of extended table

ArnieEMC
Mega Contributor

Hello,

I have a report with a multi-level pivot table which shows several tasks. The problem is that it shows the status levels on the task level instead of the status of the extended table. When I filter on only Incidents or Requested Items, it does show the correct status. It goes wrong when more than one tasktype is shown.

 

In the example below it shows status "Open" instead of "New" for Incidents, and status "New" instead of "Pending".

ArnieEMC_0-1741358101143.png

 

Report used:

ArnieEMC_1-1741358439414.png

 

How can I let it show the correct status labels?

 

Greetings,

 

Arnie

 

2 REPLIES 2

Medi C
Giga Sage

Hi @ArnieEMC ,

 

This is expected behavior from ServiceNow as the state field is set on the task level, and it is differing from one table to another which are extending the task table.

The values of the states you have on incident, could already exist on the task table with different DisplayValue. That is why you are getting different display values when using Task Table.


If you found this helpful, please hit the thumbs-up button and mark as correct. That helps others find their solutions.

ArnieEMC
Mega Contributor

Hi @Medi C is there a way to make it show what I want to see? So: open" instead of "New" for Incidents, and status "New" instead of "Pending"?