Get a value from a collection in referenced document in index

[Haris Sheikh]

Hi, is it possible to select a field in index using this statement:

CatalogueName = ((IEnumerable<LocalizedLabel>)LoadDocument<Catalogue>(item.CatalogueId).LocalizedName.LocalizedLabels).Select(x => x.LabelText).FirstOrDefault()

Here is my complete map definition:

Map = catalogueitems => from item in catalogueitems
                select new
                {
                    CatalogueId = item.CatalogueId,
                    CatalogueSectionId = item.CatalogueSectionId,
                    CurrencyCode = item.CurrencyCode,
                    ExchangeRate = item.ExchangeRate,
                    CatalogueSectionName = LoadDocument<CatalogueSection>(item.CatalogueId).Name,
                    ProductVersionName = LoadDocument<ProductVersion>(item.TargetProductVersionId).Name,
                    ProductId = LoadDocument<ProductVersion>(item.TargetProductVersionId).ProductId,
                    ProductVersionId = item.TargetProductVersionId,
                    SKU = LoadDocument<ProductVersion>(item.TargetProductVersionId).SKU,
                    CatalogueName = ((IEnumerable<LocalizedLabel>)LoadDocument<Catalogue>(item.CatalogueId).LocalizedName.LocalizedLabels).Select(x => x.LabelText).FirstOrDefault()
                };

[Oren Eini (Ayende Rahien)]

That should work, yes. But this is probably an indication that you are doing something wrong.

You should NOT be doing so many LoadDocument.

--
You received this message because you are subscribed to the Google Groups "ravendb" 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/groups/opt_out.
 
 

[Haris Sheikh]

but when I query the index the field has null however Terms in studio displays proper value.

Haris

[Oren Eini (Ayende Rahien)]

When you query the index, you are getting the results from the _document_.

If you want to do this in the results, do that in the result transfomer.

[Haris Sheikh]

This is how I am querying the index:

var returnValue = _documentSession.Query<CatalogueItem, ProductListItemWithProductFromCatalogueItem>().AsProjection<ProductListItem>().ToList();

and I am storing the value in index:

Store(x => x.CatalogueName, FieldStorage.Yes);

[Oren Eini (Ayende Rahien)]

Go back three steps.
What is it that you are trying to do?

[Haris Sheikh]

I am trying to get a value from a collection in referenced document.

When I query the index, the value in null but Terms in studio is showing the value.

[Oren Eini (Ayende Rahien)]

Do you need to query on that?

[Haris Sheikh]

I have found the issue that I am trying to project CatalogItem to ProductListItem which is basically a denormalized copy of CatalogItem.  

In index I query CatalogItem and uses LoadDocuments to populate denormalized fields in ProductListItem. These denorm fields are obviously not present in CatalogItem.  

Therefore when I use AsProjection(ProductListItem) on CatalogItems in query the denormalized fields are not populated because they were not present in CatalogItem.  

_documentSession.Query<CatalogueItem, ProductListItemWithProductFromCatalogueItem>().AsProjection<ProductListItem>().ToList(); 

Does this make any sense?

[Kijana Woodard]

Should you consider TransformResults:

http://ravendb.net/docs/2.0/client-api/querying/results-transformation/of-type

Or, if using 2.5, a Results Transformer.