Filter on "---" in Left Outer Join Query

[Former Member]

Hi guys,

very basic question but I have not found an answer, yet. I built an left outer join MDO query and need to select all those dataset that did not find a "partner", that is fields are set to "---". However, I do not manage to filter on '---', NULL...

When using SQL, it appears to be a String "---" but in MDO???

[Former Member · Accepted solution]

Hey guys, found out that IS NULL needs to be used in query. Anyway, it appears to cause problems somewhere else.

I placed an IS NULL filter expression inside a join query but query did not return any results when called in by transaction. After removing this line, both NULL and NOT NULL data were returned. When used in test mode, IS NULL was working fine...