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 G- LNG 

Thanks & Regards,

Abbas Shaik

[Ankur Bawiskar]

@abbasshaik4 

you added where clause in only 1 table

you will have to add it for other 2 so that your join works properly

you can add this where clause in Outage table here like this

Similarly you will have to join and add where clause for CHG, I added but not sure

Please enhance that

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

[abbasshaik4]

After making changes in where clause and in the report data is showing as empty

Regards,

Abbas

[Dr Atul G- LNG]

Hi @abbasshaik4 

I think you need to change the sequence.
First go through Project and Change, and then from Change move to Outage — that’s where you’ll see the results.

In other words, I want the flow where Change is linked first, and from there you navigate to the Outage where you’re doing the operations.

[Ankur Bawiskar]

@abbasshaik4 

how are you linking CHG and Project task?

I suggested to enhance the where clause as I am not aware about the linkage between the 2 tables.