Price Range Sort issue

[Former Member]

Hi Team,

Price range is showing incorrectly, it needs to be sorted based on the value.

in table SolrValueRange, solrvaluerangesetpos value provided based on value of Range.

eg:

$0-$9.99 value is 0.

$10.00-$19.99 value is 1.

Please find attahced screenshot and suggest.

price-range.png

[Former Member]

Any help?

[former_member683704 · Accepted solution]

Hi, Nagaraju,

OOTB, priceRange is an String value indexed to Solr. Therefore, you won't be able to sort this by number using the OOTB solr sorts as well.

One option is to create a custom Solr Sort Provider to achieve your goal, another is using a more meaningful avaible provider, such as facet value count.

Please find more information here about creating a custom sort provider: https://help.sap.com/viewer/d0224eca81e249cb821f2cdf45a82ace/2005/en-US/8ba153f886691014925f989160e5...

Regards,

Adriano Cabral

[Former Member · Accepted solution]

Hi Adriano,

Thanks for your response, yes this is the way to handle sort provider.

But my case is:

1. I had removed sort provider for priceRanges attribute.

2. added loggers in FacetSearchResultFacetsPopulator class by extending it.

3.for all categories sort provider object returning null, except for 1 category and it is displaying price range incorrectly as mentioned.
4. This is not happening on Local, but on Pre prod systems.
Please help or suggest any clues here?

[Former Member · Accepted solution]

Issue has been fixed.
Reason:
in Adaptive search, there is a search profile it has filter and boost settings on the impacted Category along with priceRanges field with sort provider based on display name. By removing it, issue had fixed.