Subby
Subby

Reputation: 5480

RavenDB Query does not return all records

I am trying to get back all of the objects which I have saved in the database but not all of them come back:

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

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

Can anyone see why?

Upvotes: 4

Views: 375

Answers (1)

Diego Mijelshon
Diego Mijelshon

Reputation: 52725

By default, queries return up to 128 records.

Use an explicit Take(n) to get more records.

Upvotes: 8

Related Questions