How to filter product collection using product's final price. As I have special price and catalog price rule applied on the products.
here is my code:-
$searchedProducts = $this->_productCollectionFactory->create(); $searchedProducts = $searchedProducts->addAttributeToSelect('*') ->addAttributeToFilter('price', array( array('gt' => $pricefrom, 'lt' => $priceto), ) );
Above code filter the product using price.
But not give any result if i am using
final_price in the product.
I want to filter products form there final price range.