Field Not Indexed Exception

[David Brower]

I should probably have asked this question here: RavenDB: Field Not Indexed Exception

We're currently evaluating RavenDB in a POC application and have hit a blocker. When I run a query against the index in the Raven Studio then I get the results I want but when I query against it from C# then I get an Index not found exception.

When 

[Oren Eini (Ayende Rahien)]

Are you actually specifying the index to use in the C# query?

Also note that a _much_ better way to specify this index is:

from job in docs.Jobs

select new

{

  Stages_AssignedAgents_Id = job.Stages.SelectMany(x=>x.AssignedAgents).Select(x=>x.Id)

}

Hibernating Rhinos Ltd  

Oren Eini l CEO l Mobile: + 972-52-548-6969

Office: +972-4-622-7811 l Fax: +972-153-4-622-7811

 

--
You received this message because you are subscribed to the Google Groups "RavenDB - 2nd generation document database" group.
To unsubscribe from this group and stop receiving emails from it, send an email to ravendb+u...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[Chris Marisic]

On Friday, August 28, 2015 at 4:48:59 AM UTC-5, Oren Eini wrote:

Are you actually specifying the index to use in the C# query?

Also note that a _much_ better way to specify this index is:

from job in docs.Jobs

select new

{

  Stages_AssignedAgents_Id = job.Stages.SelectMany(x=>x.AssignedAgents).Select(x=>x.Id)

}

This concept in raven is totally unintuitive. Something needs to be done to make this concept more obvious and better explained. It's very easy for people to get lost trying to query nested objects

[Oren Eini (Ayende Rahien)]

It is documented in multiple locations (quick search gives):

http://ravendb.net/docs/article-page/3.0/csharp/indexes/map-indexes#indexing-nested-data

http://ravendb.net/docs/article-page/3.0/csharp/client-api/configuration/conventions/querying

http://ravendb.net/docs/article-page/3.0/csharp/indexes/querying/full-query-syntax

Hibernating Rhinos Ltd  

Oren Eini l CEO l Mobile: + 972-52-548-6969

Office: +972-4-622-7811 l Fax: +972-153-4-622-7811

 

--

[Chris Marisic]

Documented != intuitive 

[Oren Eini (Ayende Rahien)]

Not all complex problems can be made initiative without actually going through and understanding the scope within they work

[Chris Marisic]

I don't believe that for a minute. User Experience is hard, never impossible.

[David Brower]

Thanks, Oren.

I realise now that I need to be able to filter a job document on both the status of a stage as well as the agentid. This works:

            Map = jobs => from job in jobs

                select new

                {

                    Stages_AssignedAgents_Id = job.Stages

                                                    .SelectMany(x => x.AssignedAgents)

                                                        .Select(x => x.Id),

                    Stages_Status = job.Stages.Select(x => x.Status)

                };

But is that good practice? Although, I guess in some ways this is now more of a LINQ question.

[Oren Eini (Ayende Rahien)]

Yes, that works, and that is great.

Hibernating Rhinos Ltd  

Oren Eini l CEO l Mobile: + 972-52-548-6969

Office: +972-4-622-7811 l Fax: +972-153-4-622-7811