Hi Supun,

The dimensions are not stored in the ExtendedDataCollection, they are proper properties on IProduct and are also exposed on ProductDisplay and IProductContent.

Hi Rusty,

Thanks for the reply.

Unfortunately we have them as extended properties with some other fields :(.

As a workaround, I'm the doing it the following way which is not very efficient.

            var queryResult = _merchello.Query.Product.Search(1, 150).Items.Select(x => (ProductDisplay)x)
            .Where(
                x =>
                    x.DetachedContents.Any(s=>CompareSize(s.DetachedDataValues, length, depth, width)));

And inside the CompareSize I do the following:

    private static bool CompareSize(IEnumerable<KeyValuePair<string, string>> valuePairs, decimal length, decimal height, decimal width)
    {
        var detachedValues = valuePairs.ToDictionary(s => s.Key);

        if (!detachedValues.Any())
        {
            return false;
        }

        if (!(detachedValues.ContainsKey("width") || detachedValues.ContainsKey("height") || detachedValues.ContainsKey("length")))
        {
            return false;
        }

        var productWidth= detachedValues.ContainsKey("width") && !string.IsNullOrEmpty(detachedValues["width"].Value) ? Convert.ToDecimal(detachedValues["width"].Value.Replace("\"", "")) :  0.0m;
        var productHeight = detachedValues.ContainsKey("height") && !string.IsNullOrEmpty(detachedValues["height"].Value) ? Convert.ToDecimal(detachedValues["height"].Value.Replace("\"", "")) : 0.0m;
        var productLength = detachedValues.ContainsKey("length") && !string.IsNullOrEmpty(detachedValues["length"].Value) ? Convert.ToDecimal(detachedValues["length"].Value.Replace("\"", "")) : 0.0m;

        if (productHeight == 0 && detachedValues.ContainsKey("depth") && !string.IsNullOrEmpty(detachedValues["depth"].Value))
        {
            productHeight = Convert.ToDecimal(detachedValues["depth"].Value.Replace("\"", ""));
        }


        if (productHeight >= height && productHeight <= height + 50)
        {
            if (productWidth >= width && productWidth <= width + 50)
            {
                if (productLength >= length && productLength <= length + 50)
                {
                    return true;
                }
            }

And so on, another requirement is that the search should pick up products with what ever pattern the user entered them on.

ie:

W -> W, H->H, L->L and also W->H, H->W, L->L and other permutations.

Thanks for your help in advance.

Thanks Rusty, will give it a go.

Cheers.

is working on a reply...