In report outage data is showing as empty

[abbasshaik4]

Hi Everyone,

In the report outage data is showing as empty, in database view where clause condition did i miss anything , can you someone please suggest me how to fix this issue? Screenshot attached below:

@Dr Atul - LNG 

Thanks & Regards,

Abbas Shaik

[Dr Atul - LNG]

If you just want to use it for basic change and outage scenarios, you can use it out of the box — no database view is required.

[Dr Atul - LNG]

Hi @abbasshaik4 

Try this way

[Dr Atul - LNG]

My friend, what WHERE clause are you using to link Project, Task, and Change?

To make it easier:

1. Create a database view of Project, Task, and Change.

2. If you get the desired result, then add the other tables. like outage

https://www.servicenow.com/docs/r/yokohama/it-business-management/project-management/t_LinkChangesTo...

@abbasshaik4 

[abbasshaik4]

In the report i want these 3 tables project tasks, changes and ouatges data, please refer to the below screenshot:

[Ankur Bawiskar]

@abbasshaik4 

then no need to bring m2m if you already have some common field in CHG or Project task to link these 2 tables

Did you check how linkage is happening between CHG and Project task?