Getting versioned objects between a date range

[Peter Morris]

Sorry if this is documented somewhere, but I can't find it.

If I version a collection, how do I know which version numbers to use in order to retrieve a list of versions between two dates?  I effectively want to loop through a date range (usually one calendar month) and calculate an accumulative value based on what the properties were of the object in question for that specific date.

[Chris Marisic]

What do you mean by version a collection?

Are you referring to a collection inside RavenDB such as you insert a bunch of public class MyEvent?

That you have public class MyEventBag { List<Event> Events }?

Both of those can be solved with a simple index.

The RavenDB versioning bundle is likely not what you want. If you use the versioning bundle you can get back a list of versions for the object and then you need to inspect the metadata for the create times to pick the versions that are between X & Y dates

[Peter Morris]

Thanks Chris

I think I will create a secondary collection for the histories then. Thanks :)