Hi,

Did do some searching but could not find it anywhere, is there an option to get the total count of rows based on a projection (used with FetchProjection)?

Best, Dick

Are these projections built from EntityFields, or how exactly did you get them?

Hi Walaa,

Yes, the projection is based on EntityFields and ultimately pushed into

void FetchProjection(List<IDataValueProjector> valueProjectors, IGeneralDataProjector projector, IEntityFields2 fields, IRelationPredicateBucket filter, int maxNumberOfItemsToReturn, ISortExpression sortClauses, IGroupByCollection groupByClause, bool allowDuplicates, int pageNumber, int pageSize);

Would it be possible to do a DbCount-like call using the same values except paging to have the database count the total number of rows instead of us fetching all rows before knowing the total count?

Best, Dick

There is an overload of the GetDBCount() method that accepts EntityFields. So all you need to do is to call it and pass the EntityFields, before doing your fetch.

Hi,

Awesome, found it! And got it running... thanks!

Best, Dick