Sort matching values first

Jesper Norr

Vote:

I would like to sort/boost some products to the top on my searchresult, I have a parameter on the products with budget period, yyyyx (where yyyy is budget year and x is 1 or 2 (first or second half of the year)).

So we can set a dropdown to: 0, 1, 2 and based on that value I want to sort/boost the result from find to that selected value.

I need to compare the selected valute to the last character of the property in find.

#208309

Oct 21, 2019 15:00

Paul Middleton

Vote:

Hi,

If you're only interested in the X portion of the budget period, I would just create an additional property for storing the period, and index that separately as part of your product content.

Then you can just perform an OrderBy on that specific property.

Thanks,

Paul

#208311

Oct 21, 2019 15:45

Jesper Norr

Vote:

Hi Paul,
This was exaclty what I came up with the second I was going to bed yesterday, after sitting with this issue the entire day trying to force out a solution at the sorting it came to me, as always when you stop thinking about it.

Was looking at it from the wrong direction.

Thanks

#208326

Oct 22, 2019 7:32

Paul Middleton

Vote:

Always the way isnt it! :D

#208332

Oct 22, 2019 9:11