RavenDB's Scripted Index Results

scripted index results (i wish it would have a better name) is a really interesting new feature in ravendb 2.5. as the name implies, it allows you to attach scripts to indexes. those scripts can operate on the results of the indexing.

sounds boring, right? but the options that is opens are nothing but. using scripted index results you can get recursive map/reduce indexes, for example. but we won’t be doing that today. instead, i’ll show how you can enhance entities with additional information from other sources.

our sample database is northwind, and we have defined the following index to get some statistics about our customers:

and we can query it like this:

however, what we want to do is to be able to embed those values inside the company document, so we won’t have to query for it separately. here is how we can use the new scripted index results bundle to do this:

once we have defined that, whenever the index is done, it will run these scripts, and that, in turns, means that this is what our dear alfki looks like:

i’ll leave recursive map/reduce as tidbit for my dear readers .