RavenDB request does not return all records

Question

I try to return all the objects stored in the database, but not all of them are returned:

var everything = session.Query<MyObject>() .Where(x => !x.IsDeleted && x.WorkflowStatus == WorkflowStatus.Published); 

I have 206 objects in total, a good 80% of them meet the above criteria, but only 127 are returned.

Can anyone understand why?

Answer 1

By default, queries return up to 128 records .

Use explicit Take(n) to get more entries.