Difference in Creating List from DB View vs Table

Bryan Coco
Tera Contributor

‎08-09-2023 11:53 AM

Can someone please explain to me why putting the task table into a database view displays different states for an Incident in a list view than when I create a list on the task table itself?  My goal is to create a database view with both Incidents and RITMs, but when I do, the state for Incidents shows up incorrectly (see attached screenshots).  But if I create a list straight from the task table, the states show up correctly.

 

BryanCoco_0-1691607159699.png

BryanCoco_1-1691607178499.png

 

Preview file
163 KB
Preview file
47 KB
0 Helpfuls
  • 449 Views
2 REPLIES 2

Maik Skoddow
Tera Patron
Tera Patron

‎08-09-2023 08:55 PM

Hi

if you open the task table ServiceNow takes the labels for the states which are defined for the task table. Each task-inherited table like incident can have its own labels for the states and these labels are pulled when opening the incident table.

Maik

0 Helpfuls

Bryan Coco
Tera Contributor
In response to Maik Skoddow

‎08-10-2023 05:44 AM

Hi Maik, 

Thank you for responding.  That still doesn't explain what I'm seeing.  When I create the lists in Service Operations Workspace, one list is being created from the task table and one is being created from a DB View that only has the task table in it.  One is showing the state of the Incident correctly and the other isn't.  I'm trying to understand how ServiceNow is making the decision on what label to show in each situation.

0 Helpfuls