Where @out.XxxID IS NULL

[kas...@oldby.com]

I have an entity with an view. In the interface I have a method for the view. In this method I would like to provide return all where an ID IS NULL, hence a where like:

@out.XxxID IS NULL

However, nothing is returned - question - how to write in the where to achieve IS NULL?

[Ola Hellgren]

Hi, this should work and it looks to me as if you're doing it the
right way.

Perhaps, your view isn't returning rows where XxxID is null, i.e.
doing an inner join rather than a left outer one. If this is the case,
open the view editor in RISE and uncheck the Mandatory checkbox for
the joined entity Xxx.

Best regards,
Ola