RavenDB. How to load document with only 5 items from inner collection?

Question

Here is a document in the store:

{
    "Name": "Hibernating Rhinos", 
    "Employees": [
        { "Name": "Ayende" },
        { "Name": "John" },
        { "Name": "Bob" },
        { "Name": "Tom" },
        { "Name": "Lane" },
        { "Name": "Bill" },
        { "Name": "Tad" }
     ]
}

It is easy to load this document with or without Employees collection, but how to load only part of inner collection? For instance, first 5 items:

{
    "Name": "Hibernating Rhinos", 
    "Employees": [
        { "Name": "Ayende" },
        { "Name": "John" },
        { "Name": "Bob" },
        { "Name": "Tom" },
        { "Name": "Lane" }
     ]
}

Answer 1

Not directly, not.

What you can do is define the following index:

from company in docs.Companies
from emp in company.Employees
select new { Compnany = company.Name, Employee = emp }

You can then query the index for the first five employees