Posting in the Magento forums has been disabled pending the implementation of a new and improved forum solution which should better serve the community.
For new questions please post at magento.stackexchange.com, the community-run support site for the Magento community. We will be providing updates on the new forum solution soon. For questions or concerns please email firstname.lastname@example.org.
How to get all products whose finalprice differ from original price
I have to display special products on home page, which according to customer should be the products that comes under any of the catalog price rule under that particular website.
Can anyone suggest the filter query or something. Please help