Hi All,
I would like to left join kb_knowledge table with m2m_kb_task so that I can get articles that do not attached to task as well as articles that were attached to task.
Currently, m2m_kb_task provides articles info. that only attached to tasks, But I would want something like above.
So I tried creating a view with left join as below,
View result Showing only inner join:
But keeping Left join True or False doesn't change my result as it is only giving inner join(above pic) that means only records that match the condition specified in where clause.
Can anybody suggest how to achieve this.
Move the where clause to the second table (m2m_kb_task), like below. You should only need left join true on the second one.
Move the where clause to the second table (m2m_kb_task), like below. You should only need left join true on the second one.
yes it should give you articles not attached to tasks. did you try to set up your DB view like this image below? It will pull all kb_knowledge articles first, and then will left join the m2m_kb_task table to that and the where clause needs to go on that second one. If you set it up like below it should give you what you want, as I did this in my personal instance and it worked fine.
