Create a database view of task and Interaction table to show all records in my work at one place

[Nikita35]

hello

I want to create a database view of tables Interaction and Task.

Idea is to see all the assigned tasks and interactions at one place - My work

My work currently uses Task table, I will replace this with my database view.

I would appreciate some help on this.

Regards

[Gowrisankar Sat]

Check this simple database view on change and task_sla table on your instance.

https://<instance_name>.service-now.com/sys_db_view.do?sys_id=6529424f0a0a0b4b00d66243f6fdf859

Check this documentation link:

https://docs.servicenow.com/bundle/orlando-platform-administration/page/use/reporting/task/t_CreateA...

[Nikita35]

In My case Interaction doesn't have any link to task table.

How can i query these two tables?

[Gowrisankar Sat]

Hi Nikita,

interaction_related_record stores the relation between interaction record and task records.

Create a database view between these three tables.

[Nikita35]

Right I did the same

I I get the error like this after adding interaction table: