Hi,

At this point in time, I have a products listing where user can search by collections/categories.

I am using Merchello Version 2.2.0 where it was not that easy to search by multiple collections.

Below, you can find my logic how my search made up.

But it is quite slow, it takes about 10 to 15 seconds to return results.

At this point in time, which is at the final stage, I don't know if I can update to the latest and use some latest functions which can do this using Examine.

But I am asking if it is possible if this could be manageable without upgrading everything since there might be some issues

I would appreciate any solution for this guys.

public ReturnedSearchedResultsModel Search(UmbracoHelper umbracoHelper,List<int> umbracoCategories, string searchText, int pageSize, int currentPage, string sortyByEnumValue)
            {
                var merchelloHelper = new MerchelloHelper();
                var returnedSearchedResultsModel = new ReturnedSearchedResultsModel();

                //later on, we would need to get products according to track inventory

                var returnedProducts = merchelloHelper.Query.Product.Search(1, int.MaxValue).Items.Select(x => (ProductDisplay)x);

                if (umbracoCategories.Any())
                {
                    //var listOfCategoriesGuids = _umbracoHelperService.TypedContent(umbracoHelper, ConstantValues.ProductsPageId).Children().Where(x => x.DocumentTypeAlias == ConstantValues.Document_Type_Alias_Product_Category && umbracoCategories.Contains(x.Id)).Select(x => (ProductCategory)x).Select(pc => pc.Products.CollectionKey);

                    var listOfCategoriesGuids = new List<Guid>();
                    foreach (var productCategoryId in umbracoCategories)
                    {
                        var productCategoryAsModel = new ProductCategory(_umbracoHelperService.TypedContent(umbracoHelper, productCategoryId));

                        if (productCategoryAsModel != null)
                        {
                            listOfCategoriesGuids.Add(productCategoryAsModel.Products.CollectionKey);
                        }
                    }

                    returnedProducts = merchelloHelper.Query.Product.Search(1, int.MaxValue).Items.Select(x => ((ProductDisplay)x).AsProductContent()).Where(x => x != null).Where(x => x.Collections().Select(p => p.CollectionKey).Intersect(listOfCategoriesGuids).Any()).Select(x => x.AsProductDisplay());
                }

                if (!String.IsNullOrEmpty(searchText))
                {
                    returnedProducts = returnedProducts.Where(x => x.Name.ToLower().Contains(searchText.ToLower()));
                }

                //ordering
                var orderedProducts = returnedProducts.OrderBy(x => x.Name);
                var enumValueToEnum = EnumHelpers.ConvertStringToEnum(sortyByEnumValue, Enums.SearchSortyBy.NameAscending);
                bool sortingSelected = false;

                if (enumValueToEnum.Equals(Enums.SearchSortyBy.NameDescending))
                {
                    sortingSelected = true;
                    orderedProducts = orderedProducts.OrderByDescending(x => x.Name).ThenBy(x => new Product(x.AsProductContent()).Ranking);
                }
                else if (enumValueToEnum.Equals(Enums.SearchSortyBy.Newest))
                {
                    sortingSelected = true;
                    orderedProducts = orderedProducts.OrderByDescending(x => new Product(x.AsProductContent()).CreationDate).ThenBy(x => new Product(x.AsProductContent()).Ranking);
                }
                else if (enumValueToEnum.Equals(Enums.SearchSortyBy.NameAscending))
                {
                    sortingSelected = true;
                    //order by name is already done, at the top
                }

                if (!sortingSelected)
                {
                    orderedProducts = orderedProducts.OrderBy(x => new Product(x.AsProductContent()).Ranking);
                }

                returnedSearchedResultsModel.TotalNumberOfProducts = orderedProducts.Count();

                var totalPagesForProducts = (int)Math.Ceiling((double)orderedProducts.Count() / (double)pageSize);


                if (currentPage > totalPagesForProducts)
                {
                    currentPage = totalPagesForProducts;
                }
                else if (currentPage < 1)
                {
                    currentPage = 1;
                }

                returnedSearchedResultsModel.SearchedResultsForCurrentPage = orderedProducts.Skip((currentPage - 1) * pageSize).Take(pageSize);

                return returnedSearchedResultsModel;
            }

Thank you Kind Regards