Query returns document Id with lower case in projections fields

[Xevi Mayolas]

I’m working with version 2.5 build 2939 and I’m experiencing this issue with the following data:

Executing the following projection query I'm getting the entire Id's converted to lower case, while the Name field keeps the original case:

var countries = from c in session.Query<Country>()
                                    where c.Name != null
                                    orderby c.Name
                                    select new { DisplayText = c.Name, Value = c.Id };


Here is the result:

[Oren Eini (Ayende Rahien)]

What build are you using?

--
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.

[Xevi Mayolas]

I’m working with version 2.5 build 2939

[Oren Eini (Ayende Rahien)]

Are you doing explicit projection? In this case, you are getting the data directly from the index, and it would be lower cased.

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

 

[Xevi Mayolas]

OK, now I see that, the indexes store the Id's in lower case, but I'm not able to get the Id from the document, What is the way for get the real Id?

[Kijana Woodard]

I think this post is relevant:

https://groups.google.com/forum/#!topic/ravendb/sQbuuT-GckA

On Wed, Nov 19, 2014 at 4:54 PM, Xevi Mayolas <xevi...@gmail.com> wrote:

OK, now I see that, the indexes store the Id's in lower case, but I'm not able to get the Id from the document, What is the way for get the real Id?

--

[Kijana Woodard]

It might be overkill for your case, but a results transformer might behave better. I can't remember what happens with Id there.

http://ravendb.net/docs/article-page/2.5/Csharp/client-api/querying/results-transformation/result-transformers

[Chris Marisic]

You should also be able to store the id

[Chris Marisic]

FieldStorage.Yes that is, to embed the actual value in the index.

Not saying this is for everyone but when i index anything, i store ever single value. I never used indexes to return documents, i only ever read index results. If i want transactionally consistent data I will use Load or LoadStartingWith. I prefer the convention of everything is stale, everything is eventually consistent. Then make a select few things be consistent (like updates).

[Kijana Woodard]

Using values from the index makes sense. 

I've run into cases where the documents you get back no longer meet the criteria in the Where clause of the Query. If that matters, it can be confusing. :-]

--