StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POFilter Product collection by multiple price ranges
primarykey
Id
20654188
data
AcceptedAnswerId
20657050
AnswerCount
1
ClosedDate
CommentCount
2
CommunityOwnedDate
CreationDate
2013-12-18T09:29:27.677
FavoriteCount
2
LastActivityDate
2013-12-18T11:34:06.203
LastEditDate
LastEditorUserId
0
OwnerUserId
2288978
ParentId
0
PostTypeId
1
Score
0
ViewCount
3957
LastEditorDisplayName
text
Body
I want to filter product collection by some attributes including diy_kit_price attribute (new attribute already added) as shown below. Price Ranges: <ol> <li>0 - 5000</li> <li>10000 - 15000</li> </ol> I tried several ways but no luck. Working Code: when i am filtering by one price range: <pre><code>$products = Mage::getModel('catalog/product')->getCollection() ->addAttributeToSelect('*') ->addAttributeToFilter('type_id', 'configurable') ->joinField('category_id', 'catalog/category_product', 'category_id', 'product_id = entity_id', null, 'left') ->addAttributeToFilter('category_id', array( array('finset' => '37') )) ->addAttributeToSort('name', 'asc') ->addAttributeToFilter('diy_kit_price', array('gt' => 0)) ->addAttributeToFilter('diy_kit_price', array('lt' => 5000)); </code></pre> Not Working Code: when i am filtering by one price range: <pre><code>$products = Mage::getModel('catalog/product')->getCollection() ->addAttributeToSelect('*') ->addAttributeToFilter('type_id', 'configurable') ->joinField('category_id', 'catalog/category_product', 'category_id', 'product_id = entity_id', null, 'left') ->addAttributeToFilter('category_id', array( array('finset' => '37') )) ->addAttributeToSort('name', 'asc') ->addAttributeToFilter('diy_kit_price', array('gt' => 0)) ->addAttributeToFilter('diy_kit_price', array('lt' => 5000)) ->addAttributeToFilter('diy_kit_price', array('gt' => 10000)) ->addAttributeToFilter('diy_kit_price', array('lt' => 15000)); </code></pre> Is there any other way to filter. Can we filter using plain SQL with multiple price ranges. Thanks in advance.
Tags
<magento>
Title
Filter Product collection by multiple price ranges
singulars
PostAcceptedAnswerId
1. PO
 singulars
 PostTypePostTypeId
 PTAnswer
PostParentId
1. This table or related slice is empty.
PostTypePostTypeId
1. PTQuestion
UserLastEditorUserId
1. This table or related slice is empty.
UserOwnerUserId
1. USSivakumar
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. PO
 singulars
 PostTypePostTypeId
 PTAnswer
VotesPostIdCreationDate
1. VO
 singulars
 PostPostId
 POFilter Product collection by multiple price ranges
 UserUserId
 USSivakumar
 VoteTypeVoteTypeId
 VTFavorite
CommentsPostId
1. COIn the second case actually your filter is from 0 to 15000. 5000 and 10000 are becoming useless. You should use `(> 0 AND < 5k) OR (> 10k AND < 15k)`. Not sure if it could be done without converting to Zend query.
 singulars
 PostPostId
 POFilter Product collection by multiple price ranges
 UserUserId
 USenenen
2. COHow can use the code that you are mentioned. Can you please give me an example.
 singulars
 PostPostId
 POFilter Product collection by multiple price ranges
 UserUserId
 USSivakumar

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.