Filter by discount in sort by

[laqmarc]

Hello, I would like to know if there is any way to filter by discount in the facets module.

I have tried adding a case in private function addSearchFilters($selectedFilters) but it doesn't quite work for me.

 case 'offer':
        if ($orderDirection === 'desc') {
            $this->query->addOrderBy('(price - reduced_price) / price', 'DESC');
        } else {
            $this->query->addOrderBy('(price - reduced_price) / price', 'ASC');
        }
        break;

But it doesn't work for me, I've been looking at the documentation but I'm quite lost.

Any ideas?

Greetings

[Musterheld]

Same here. Did you find a solution?

[vifen]

Hi, personally I don't know a way to do this.

https://19216811.cam/ https://1921681001.id/

Edited December 5, 2024 by vifen (see edit history)