Database View Reporting

[AllenJaikkA]

Hello Everyone, 
I have this requirement to merge Task and Interaction Table. I had successfully created a database view using task, interactions and interaction related record table. My problem is to combine the task.number and interaction.number field into one unified field. One of the goal is a single report that will show task and interactions that is worked on by a specific team. Thank you so much. 

[Ankur Bawiskar]

@AllenJaikkA 

not possible as both tables have number field

they will be shown as separate ones in reporting.

💡 If my response helped, please mark it as correct ✅ and close the thread 🔒— this helps future readers find the solution faster! 🙏

[AllenJaikkA]

Can you explain why would this be a problem?

[Sarthak Kashyap]

Hi @AllenJaikkA ,

In ServiceNow, if you want to combine any two tables or fields in a database view, the sys_id is the most important element for establishing a relationship. Since both task.number and interaction.number are string-type fields, creating a relationship between them is not possible. If you want to create a relationship between the Task and Interaction tables, you need to use reference fields such as opened_for or assigned_to, as these can be used to establish valid links between the two tables.

Please mark my answer correct and helpful if this works for you

Thanks and Regards,

Sarthak

[AllenJaikkA]

Hi @Sarthak Kashyap , but is it possible? for example used both assigned_to field of task and interactions. is it possible to link them and combine the fields? like the "Number" field in a report will contain tasks and interactions? thank you