Filter by special price

[LilD]

how could i filter by special price?
I tried in productRepository to do this but it doesn't work

   $qb->where('variants.min_price', '>=', core()->convertToBasePrice($priceRange[0]));
                    $qb->where('variants.min_price', '<=', core()->convertToBasePrice(end($priceRange)));
                    $qb->orWhere('variants.special_price', '>=', core()->convertToBasePrice($priceRange[0]));
                    $qb->orWhere('variants.special_price', '<=', core()->convertToBasePrice(end($priceRange)));

Can I do this:?

I would like to filter and if the price is low, not just show me the old price

[devansh-webkul]

Hi @LilD,

Product flat table already contains special price column, you don't need to join this.

[LilD]

@devansh-webkul yes but i put special_price and this not work