http://ayende.comAyende @ RahienCopyright (C) Ayende Rahien 2004 - 2021 (c) 202660Brilliant, great feature and thanks for the quick response!http://ayende.com/160513/ravendb-feature-of-the-year-indexing-related-documents#comment15http://ayende.com/160513/ravendb-feature-of-the-year-indexing-related-documents#comment15Wed, 13 Mar 2013 21:39:54 GMTJim, You just do, here is how you would do this using Lucene Query: session.Advanced.LuceneQuery<Courses>("CoursesAndStudents").WhereEquals("Students", "oren eini").ToList();http://ayende.com/160513/ravendb-feature-of-the-year-indexing-related-documents#comment14http://ayende.com/160513/ravendb-feature-of-the-year-indexing-related-documents#comment14Wed, 13 Mar 2013 14:56:25 GMTCan you give example code for querying this using the .NET Client API?http://ayende.com/160513/ravendb-feature-of-the-year-indexing-related-documents#comment13http://ayende.com/160513/ravendb-feature-of-the-year-indexing-related-documents#comment13Wed, 13 Mar 2013 13:04:08 GMTShawn, In exactly the same manner. You have LoadDocument exposed to you in the AbstractIndexCreationTaskhttp://ayende.com/160513/ravendb-feature-of-the-year-indexing-related-documents#comment12http://ayende.com/160513/ravendb-feature-of-the-year-indexing-related-documents#comment12Sun, 10 Mar 2013 14:54:44 GMTHow would one query this using the .Net Client API?http://ayende.com/160513/ravendb-feature-of-the-year-indexing-related-documents#comment11http://ayende.com/160513/ravendb-feature-of-the-year-indexing-related-documents#comment11Sat, 09 Mar 2013 04:49:51 GMTMy biggest pain with NoSQL is that they never contain any simple, efficient way of performing a join (denormalization is sometimes desired, sometimes not depending on your use-case). This pain has now gone away! Awesome feature!!!http://ayende.com/160513/ravendb-feature-of-the-year-indexing-related-documents#comment10http://ayende.com/160513/ravendb-feature-of-the-year-indexing-related-documents#comment10Mon, 07 Jan 2013 09:13:34 GMTBrillant! Thanks for the Christmas present!http://ayende.com/160513/ravendb-feature-of-the-year-indexing-related-documents#comment9http://ayende.com/160513/ravendb-feature-of-the-year-indexing-related-documents#comment9Wed, 26 Dec 2012 00:59:52 GMTThis is exactly the feature that we needed a lot! Thanks Ayende! Awesome Christmas gift for developers who love RavenDB :) http://ayende.com/160513/ravendb-feature-of-the-year-indexing-related-documents#comment8http://ayende.com/160513/ravendb-feature-of-the-year-indexing-related-documents#comment8Tue, 25 Dec 2012 21:53:59 GMTKiller feature, Oren! And first time I read "I am so excited I can barely sit" I misread "sit", haha!http://ayende.com/160513/ravendb-feature-of-the-year-indexing-related-documents#comment7http://ayende.com/160513/ravendb-feature-of-the-year-indexing-related-documents#comment7Tue, 25 Dec 2012 14:44:30 GMTCool! I was just looking for such a feature some days agohttp://ayende.com/160513/ravendb-feature-of-the-year-indexing-related-documents#comment6http://ayende.com/160513/ravendb-feature-of-the-year-indexing-related-documents#comment6Tue, 25 Dec 2012 03:01:06 GMTAwesome new feature, Oren. Can't wait until 2.0 is done and up on NuGet.http://ayende.com/160513/ravendb-feature-of-the-year-indexing-related-documents#comment5http://ayende.com/160513/ravendb-feature-of-the-year-indexing-related-documents#comment5Tue, 25 Dec 2012 00:12:42 GMTTheo, It is a bit more involved, since you also need to do updates on the fly when the referenced document changes, but yes.http://ayende.com/160513/ravendb-feature-of-the-year-indexing-related-documents#comment4http://ayende.com/160513/ravendb-feature-of-the-year-indexing-related-documents#comment4Mon, 24 Dec 2012 22:38:43 GMTDidn't you just describe a basic index side join? Nicehttp://ayende.com/160513/ravendb-feature-of-the-year-indexing-related-documents#comment3http://ayende.com/160513/ravendb-feature-of-the-year-indexing-related-documents#comment3Mon, 24 Dec 2012 20:56:43 GMTAmazing work! This is going to really come in handy. What I really love is now when people say "you can't do joins in nosql" - I can smile and say "oh yes you can!" - well, not exactly a true join in the Cartesian product sense, but certainly the same intent and benefit. Ayende - you rock!http://ayende.com/160513/ravendb-feature-of-the-year-indexing-related-documents#comment2http://ayende.com/160513/ravendb-feature-of-the-year-indexing-related-documents#comment2Mon, 24 Dec 2012 17:47:29 GMTYes... just... yes!http://ayende.com/160513/ravendb-feature-of-the-year-indexing-related-documents#comment1http://ayende.com/160513/ravendb-feature-of-the-year-indexing-related-documents#comment1Mon, 24 Dec 2012 17:08:45 GMT