IT:AD:EF:HowTo:Build up queries progressively using AND and OR statements
Summary
Building up Query filters in parts, using AND/OR, is actually a lot trickier than it looks due to the expression being evaluated in Code rather than EF.
See: statements
The answer that works (used in NAB project) is expressed here: