Hello all,

Sorry, new user alert!

Could someone tell me how to do this using the best possible performance, I'm simply reusing the same view with different filters to count the number of records returned for reporting purposes, this is just one of the filters

                  predcancel.Add(FeMortgagelistjoinFields.Status == 778) ;

mortgagelistcount.Fill(0, null, true, predcancel); Int32 cancel = mortgagelistcount.GetDbCount();

For a start, I really do not need all the rows returning, just the count and this seems to be returning all records anyway despite the benefit filter

Thank you for your help,

Matthew

Check the docs for the GetDBCount function. You need to use one of the overloads.

OrderCollection orders = new OrderCollection();
IPredicateExpression filter = new PredicateExpression();
filter.Add(CustomerFields.Country == "France");
IRelationCollection relations = new RelationCollection();
relations.Add(OrderEntity.Relations.CustomerEntityUsingCustomerId);
int amount = orders.GetDbCount(filter, relations);

Thank you for your help, sorted know :-)