Hi guys, I need get data accordingly this simple query:

select * from table where a = 1 and (b = 1 or b = null) and d =2

I use this code:

HelpPageCollection pages = new HelpPageCollection();
IPredicateExpression filter = new PredicateExpression();
filter.Add(PredicateFactory.CompareValue(HelpPageFieldIndex.PageNameSource,
                ComparisonOperator.Equal, pageName));       
filter.Add(PredicateFactory.CompareValue(HelpPageFieldIndex.PageDir,
ComparisonOperator.Equal, dirName)).AddWithOr(PredicateFactory.CompareNull(HelpPageFieldIndex.PageDir));


filter.AddWithAnd(PredicateFactory.CompareValue(HelpPageFieldIndex.SiteId,
                ComparisonOperator.Equal, siteId));
pages.GetMulti(filter);

But I have as result such query:

select * from table where a = 1 and b = 1 or (b = null and d =2)

Please, help me to construct the right code. Thanks!

Hi,

this is because (a or b) should be put in an inner predicate expression.

But have you tried using the operators overloads? That should make it easier than with the predicate factory, especially for nesting your expressions, since it does not need more than the appropriate parenthesis. Have a look in the manual.

Cheers

Jessynoo wrote:

Hi,

this is because (a or b) should be put in an inner predicate expression.

But have you tried using the operators overloads? That should make it easier than with the predicate factory, especially for nesting your expressions, since it does not need more than the appropriate parenthesis. Have a look in the manual.

Cheers

Can you give me a little sample? I have not found any topics as "operators overloads"...

Please refer to the LLBLgen Pro manual: "Using the generated code -> Adapter/SelfServicing -> Filtering and sorting -> Getting started with filtering"