Hello,

I have a grid with paging on it.

i use this ...

daa.FetchEntityCollection(logging, vBucket, 0, vSort, vPath2, page, resultspage);

(this works great.)

I use multiple filters an add it to my vBucket.

IRelationPredicateBucket vBucket = new RelationPredicateBucket();

 IPredicateExpression filter = new PredicateExpression();

 IPredicateExpression exclfilter = new PredicateExpression();
 exclfilter.Negate = true;

 vBucket.PredicateExpression.Add(filter);
vBucket.PredicateExpression.Add(exclfilter);

But my grid needs to show how many results there are.

there i use get scalar.

object o = daa.GetScalar(LogFields.Id, null, AggregateFunction.CountRow, filter);

Now how as you can see i have only 1 filter added. But i have an other filter that is negate.

My question is:

How do you get the count with multiple filters ?

thanks

You should use another PredicateExpression instead of the bucket:

IPredicateExpression finalFilter = new PredicateExpression();
IPredicateExpression filter = new PredicateExpression();
IPredicateExpression exclfilter = new PredicateExpression();
exclfilter.Negate = true;

// ...

finalFilter.Add(filter);
finalFilter.Add(exclfilter);

object o = daa.GetScalar(LogFields.Id, null, AggregateFunction.CountRow, finalFilter);

Thanks it works