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]

can you try this format:

Refer below community article if you are getting same error:

https://community.servicenow.com/community?id=community_question&sys_id=2a900f25db98dbc01dcaf3231f96...

[Nikita35]

thanks for your reply

i changed the order and error is gone.

in my case what is expected is - if the interaction record is created with no related task, then also I would be able to see that in my work.

but here in this database view as we are mapping the task sys_id, interaction record with no related task is not visible for me which fails my requirement.

[Nikita35]

can I utilize left join here to join interaction and task tables

[Nikita35]

Any help on this one please