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

[Ankur Bawiskar]

@VirendraKuD 

database view is used to join 2 or more tables and then use that in reporting.

You can report on task table with Task Type IS INC OR PROB OR CHG and then add that group in filter condition

something like this, I hope you can enhance it further

If my response helped please mark it correct and close the thread so that it benefits future readers.

[VirendraKuD]

Hi @Ankur Bawiskar ,

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

[Ankur Bawiskar]

@VirendraKuD 

then you can join those 3 tables based on common field?

how is RITM linked with INC and then how is INC linked with that custom table or how is RITM linked with that custom table?

without that linkage you cannot create database view.

If my response helped please mark it correct and close the thread so that it benefits future readers.

[Dr Atul G- LNG]

Hi @VirendraKuD 

Agree with @GopikaP , 

Use the Task table instead of creating a database view unless you specifically need to link records, such as an Incident linked to a Change. A DB view is required only in such cases.

If your goal is simply to display data in a pie chart, you can achieve that without a DB view. You can also use the Dataset feature in reporting, where you create a report on three tables and display them together.

[AndersBGS]

Hi @VirendraKuD ,

Just create your report based on the task table, as all mentioned tables are based on task table.