Column shown blank in list view in spite of having values

[Shivani_singh]

List view for "task_sla" table is showing "Assignment Group" column blank in spite of having value for assignment group.
Attached the screenshot.
How i can bring the assignment group value in the task_sla table.

[Dr Atul G- LNG]

How are you adding value to this? I understand that you're retrieving the assignment group value via the RITM in this field, but the dot-walk connection isn't working in the list view.

[Shivani_singh]

If this is not the right way, then how should get the assignment group value in the task_sla table.

[Dr Atul G- LNG]

you need to get the Database view of task sla and RITM and then you can show the assignment group on RITM on task sla.

[Shivani_singh]

Could you please me with that.
Not having much idea about Database view.

[Dr Atul G- LNG]

Hi @Shivani_singh 

A database view is where we can join two or more tables to retrieve results from both tables.

In PDI, you can view the out-of-the-box (OOTB) database views, and then, in a similar manner, you can create your own.

https://youtu.be/Q5dhh1bJQf0

https://www.servicenow.com/community/developer-blog/what-is-servicenow-database-view-create-servicen...