Database view Report Data shows empty records

[Sadhana1]

Hello,

I have created a Database view between Knowledge table and a m2m table associated with knowledge(u_m2m_countries_knowledge). I have given Where clause for custom table and made Left Join. Then i get all empty records in the report. Can someone help me figure out what is wrong and how it could be corrected.

Actually we are creating a report on Knowledge such that all the countries associated with it should also display in report. We have created a m2m Related list on Knowledge where they can add countries that article can associate with.

[Sudhanshu Talw1]

Hi, Make left join in the below clause to false & check it once. Thanks Sudhanshu

[Sadhana1]

Hi, if Left Join is made false, then it doesnt show any details at all. Displays no records. 

[Sudhanshu Talw1]

Hi, Make it false on both the clause Then try. Thanks Sudhanshu

[Sadhana1 · Accepted solution]

It worked when the where clause is changed to T2_u_knowledge = T1_sys_id