Skip to Content
avatar image
Former Member

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

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???

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    avatar image
    Former Member
    Apr 07, 2015 at 02:06 PM

    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...

    Add comment
    10|10000 characters needed characters exceeded