Filter product by price

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

Filter product by price

Abhishake Agarwal
Hi,

I want to filter product by price on category detail screen.

e.g. If user clicks on link $50 - $100, Product between this two price range
should only be viewable.

Please let me know what can be the best way of implementing this.

Regards,
Abhishake
Reply | Threaded
Open this post in threaded view
|

Re: Filter product by price

Eric DE MAULDE
Hi,

Call 2 entities "ProductCategoryAndMember" and "ProductPrice"

with EntityCondition and EntityOperator class
ex :
...
EntityCondition.makeCondition("price", EntityOperator.BETWEEN,
UtilMisc.toList(50,100));
...

or into a screen in order to  group your SQL result

Eric

----- Original Message -----
From: "Abhishake Agarwal" <[hidden email]>
To: <[hidden email]>
Sent: Thursday, May 14, 2009 2:13 PM
Subject: Filter product by price


> Hi,
>
> I want to filter product by price on category detail screen.
>
> e.g. If user clicks on link $50 - $100, Product between this two price
> range
> should only be viewable.
>
> Please let me know what can be the best way of implementing this.
>
> Regards,
> Abhishake
>