Create a data base view

[VirendraKuD]

Hi Everyone,

I want to create a Database View on three out of box tables - Incident , Problem and Change Request. The relation in them will be that all three are assigned to assignment group - Analytics System Manager.

I want to create a single pie chart for three tables - Incident, Problem and Change Request. Is there any other way I can create this pie chart  without using database view.

Please help me with above two scenarios.

Thanks in advance

[GopikaP]

Hi @VirendraKuD ,Since three of the tables are extended from Task, so you can select 'Task' as the table.

• Choose 'Pie' as the Type.

• In the 'Configure' section, set 'Group by' to 'Task Type'.

• In the conditions, select Incident, Problem, and Change Request.

[VirendraKuD]

Hi @GopikaP @Dr Atul G- LNG 

I have just given example of Incident, Change and Problem. But in practicality we will be using Incident , RITM and one custom table. That's why wanted to know about database view Clauses.

Thanks

[Dr Atul G- LNG]

Hi @VirendraKuD 

Thanks for the update. I believe this is a wrong practice—you need to clearly mention the question. Missing information in the question can make other answers irrelevant immediately. No worries, we all are learning.

In this case, how are Incident, Problem, and the custom table linked to each other?

For example, if an Incident is linked to a Problem record, you need to check the sys_id of both.

• Replace the Task table with Incident and the other with Problem.

• First, join these two tables and verify if you are getting results.

• If yes, then proceed to add the third table.

OOTB DB:

https://INSTANCNAME.service-now.com/now/nav/ui/classic/params/target/sys_db_view.do%3Fsys_id%3D6529424f0a0a0b4b00d66243f6fdf859%26sysparm_record_target%3Dsys_db_view%26sysparm_record_row%3D8%26sysparm_record_rows%3D192%26sysparm_record_list%3DORDERBYname

[GopikaP]

@VirendraKuD . do these tables have any linking fields? If not, you can try using multiple datasets but consider choosing a 'Bar' chart instead of 'Pie,' if that works for you. I can share the report here, let me know if you need the details.