Hi Jeroen,

What you need to do is use a FacetedQueryable from the SearchLibrary. You can specify the initial filter with type safe linq and then go .ToFacets() to get the facets or ToList() to get products. 

Docs on the matter can be found here: http://docs.ucommerce.net/ucommerce/v6/getting-started/search-foundation/search-library.html

Hope that helps.

Regards

Morten

Hi Morten,

Thanks for responding quickly. I'll try to figure it out with your tips.

regards,

Jeroen

Good afternoon,

i've tried to develop a sollution for my problem. It hasn't be succesful. it seems that ravendb couldn't understand my lambda expression.

I was trying to do a free search with a keyword, so I build a lambda expression to filter the result of FacetedQueryable(). this is what is was trying to do:

var query = SearchLibrary.FacetedQuery().Where(
                p=>p.VariantSku == null
                                && p.DisplayOnSite
                                &&
                                (
                                    (p.Sku.IndexOf(keyword) > -1)
                                    || (p.Name.IndexOf(keyword) > -1)
                                )
                );

and also tried:

            var query = SearchLibrary.FacetedQuery().Where(
                p=>p.VariantSku == null
                                && p.DisplayOnSite
                                &&
                                (
                                    p.Sku.Contains(keyword)
                                    || p.Name.Contains(keyword)
                                )
                );

With both implementation I got the error of ravendb that he could understand my expression.

any idea what I might do wrong?

Am I correct that UCommerce is offering development support to (paying)customers?

Regards,

Jeroen

Hi, We've a buddy program for paying customers. That doesn't include development support though. That is a starter pack which you can read about here: http://www.ucommerce.net/en/support/starter-pack.aspx

Why do you need to query on Sku ? 

is working on a reply...