Hi Chris,

The reason you're not getting any results from the query you mention is that the field is not included in the default facet index. I have changed the default index to include this field going forward.

Meanwhile, you can fix this by changing the SaveLanguage pipeline (this is where the index is created and recreated when necessary) to include the Variants value.

The task replaces the existing one by registering it in Custom.config using component id "Language.CreateIndex":

<component id="Language.CreateIndex"
service="UCommerce.Pipelines.IPipelineTask`1[[UCommerce.Infrastructure.Globalization.Language, UCommerce.Infrastructure]], UCommerce"
    type="MyNamespcae.CreateIndexTask, MyDll" />

And the implementation to include the new field:

public class CreateIndexTask : IPipelineTask<Infrastructure.Globalization.Language>
    {
        private readonly IRavenDbStoreProvider _storeProvider;
        private readonly IRepository<PriceGroup> _priceGroupRepository;

        public CreateIndexTask(IRavenDbStoreProvider storeProvider, IRepository<PriceGroup> priceGroupRepository)
        {
            _storeProvider = storeProvider;
            _priceGroupRepository = priceGroupRepository;
        }

        public PipelineExecutionResult Execute(Infrastructure.Globalization.Language subject)
        {
            var store = _storeProvider.GetStore();

            // Uses the display name of fields to create dynamic fields
            // and the display names of data type pre values to create field value.
            // If name or pre value doesn't have a language specific value it
            // uses the values as stored on product document.
            string indexDefinition = @"docs.Products.Select(product => new {
                                        product.ProductDefinition,
                                        product.ThumbnailImageUrl,
                                        product.PrimaryImageUrl,
                                        product.Sku,
                                        product.VariantSku,
                                        product.Name,
                                        product.DisplayOnSite,
                                        product.Weight,
                                        product.AllowOrdering,
                                        product.ModifiedBy,
                                        product.ModifiedOn,
                                        product.CreatedOn,
                                        product.CreatedBy,
                                    product.Variants,
                                        Rating = this.Recurse(product, x => x.Variants).Select(x => new[] {x.Rating}),
                                        product.CategoryIds,
                                        _ = this.Recurse(product, x => x.Variants).Select(x => x.Properties.Select(y => y.Value.Select(z => (z.Value is string ? (IEnumerable<object>) new [] { z.Value } : (IEnumerable<object>) z.Value).Select(v => this.CreateField(LoadDocument(product.ProductDefinition).Fields.SingleOrDefault(field => field.Name == z.Key).Properties[""{CULTURECODE}""][""DisplayName""] ?? z.Key, LoadDocument(LoadDocument(product.ProductDefinition).Fields.SingleOrDefault(field => field.Name == z.Key).DataTypeId).PreValues.SingleOrDefault(preValue => preValue.Value == v).Properties[""{CULTURECODE}""][""DisplayName""] ?? v))))),
                                        __ = this.Recurse(product, x => x.Variants).Select(x => x.Prices.Select(y => this.CreateField(y.Key, y.Value)))
                                    })".Replace("{CULTURECODE}", subject.CultureCode); // string.Format doesn't work with @literals

            string indexName = "Products/ByPropertyRecurse/{0}".FormatWith(subject.CultureCode);
            store.DatabaseCommands.DeleteIndex(indexName);

            var index = new IndexDefinition()
            {
                Map = indexDefinition,
                Analyzers =
                {
                    {"__all_fields", "KeywordAnalyzer"}
                }
            };

            foreach (var priceGroup in _priceGroupRepository.Select(x => !x.Deleted))
            {
                index.SortOptions.Add(priceGroup.Name, SortOptions.Double);
            }

            store.DatabaseCommands.PutIndex(indexName, index);

            return PipelineExecutionResult.Success;
        }
    }

Hi Soren,

Thanks for that code, I've added it and I now only get the expected 2 products and not the variants using this code:

var topLevelProductsOnly =
                    SearchLibrary.FacetedQuery().Where(x => x.Variants.Any()).ToList();

I'm trying to use the ToFacets() to only get Facets matching these 2 products, however the below code returns a list of Facets that include the Price Facet that has a Hit count of 6, not 2 which is including the Variant prices. Am I correct in thinking this should only return Facet values based on the LINQ query, or is there something extra I need to do here?

var topLevelProductsOnlyWithFacets =
                   SearchLibrary.FacetedQuery().Where(x => x.Variants.Any()).ToFacets().ToList();

Thanks

Chris

Please refer to answer in this topic on how to filter the returned facets.

https://our.umbraco.org/projects/website-utilities/ucommerce/ucommerce-support/65289-Price-facet-returns

is working on a reply...