Mrthdrb

How can a day be of 24 hours?

What is required to make GPS signals available indoors?

Why is it a bad idea to hire a hitman to eliminate most corrupt politicians?

What is a Samsaran Word™?

Car headlights in a world without electricity

Does marriage to a non-Numenorean disqualify a candidate for the crown of Gondor?

Different meanings of こわい

Machine learning testing data

Getting extremely large arrows with tikzcd

Was the Stack Exchange "Happy April Fools" page fitting with the '90's code?

Mathematica command that allows it to read my intentions

Rotate ASCII Art by 45 Degrees

Is it possible to map the firing of neurons in the human brain so as to stimulate artificial memories in someone else?

Do creatures with a listed speed of "0 ft., fly 30 ft. (hover)" ever touch the ground?

Could neural networks be considered metaheuristics?

Notepad++ delete until colon for every line with replace all

What is the opposite of "eschatology"?

What Exploit Are These User Agents Trying to Use?

Why was the shrink from 8″ made only to 5.25″ and not smaller (4″ or less)

My ex-girlfriend uses my Apple ID to log in to her iPad. Do I have to give her my Apple ID password to reset it?

How seriously should I take size and weight limits of hand luggage?

Avoiding the "not like other girls" trope?

Does Dispel Magic work on Tiny Hut?

Why do I get negative height?

Magento 2 Get Product collections by specific attribute

Get specific attribute for each product on catalog pageRead attribute set id from productGet the value of a dropdown attribute of an associated productGet product attribute value from custom groupCannot update custom product attribute valuesMagento2 - Custom product attribute in product collectionGet product attribute in cart in Magento2how to get attribute all dropdown values selected by the product in magento 2?Get product collection based on custom attribute (drop down attribute value)How to get product names by attribute value?

0

I'm trying to get product collection by custom attribute "Age"

Age is a Dropdown attribute

Please help me to get this solution?

magento2 attributes

share|improve this question

edited May 22 '18 at 6:23

hweb87

5942724

asked May 22 '18 at 4:58

RanganathanRanganathan

555417

bumped to the homepage by Community♦ 2 days ago

This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.

add a comment | 

0

I'm trying to get product collection by custom attribute "Age"

Age is a Dropdown attribute

Please help me to get this solution?

magento2 attributes

share|improve this question

edited May 22 '18 at 6:23

hweb87

5942724

asked May 22 '18 at 4:58

RanganathanRanganathan

555417

bumped to the homepage by Community♦ 2 days ago

This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.

add a comment | 

I'm trying to get product collection by custom attribute "Age"

Age is a Dropdown attribute

Please help me to get this solution?

magento2 attributes

share|improve this question

edited May 22 '18 at 6:23

hweb87

5942724

asked May 22 '18 at 4:58

RanganathanRanganathan

555417

share|improve this question

edited May 22 '18 at 6:23

hweb87

5942724

asked May 22 '18 at 4:58

RanganathanRanganathan

555417

share|improve this question

edited May 22 '18 at 6:23

hweb87

5942724

asked May 22 '18 at 4:58

RanganathanRanganathan

555417

edited May 22 '18 at 6:23

hweb87

5942724

edited May 22 '18 at 6:23

hweb87

5942724

asked May 22 '18 at 4:58

RanganathanRanganathan

555417

asked May 22 '18 at 4:58

RanganathanRanganathan

555417

2 Answers
2

active

oldest

votes

0

For the drop-down attribute, We can filter using drop-down option ID instead of Label.

Your code is like below.

$productcollection = $this->_productCollection
 ->addAttributeToSelect('*')
 ->addAttributeToFilter('age', 18)
 ->load();

share|improve this answer

edited May 22 '18 at 5:10

answered May 22 '18 at 5:01

Nikunj VadariyaNikunj Vadariya

2,8911821

add a comment | 

0

You can filter the collection by attribute code and Option ID.

You can use addAttributeToFilter for collection filter by using a custom attribute.

protected $productCollectionFactory;

public function __construct(
 MagentoCatalogModelResourceModelProductCollectionFactory $productCollectionFactory

)
 $this->productCollectionFactory = $productCollectionFactory;


$productcollection = $this->productCollectionFactory
 ->addAttributeToSelect('*')
 ->addAttributeToFilter('attribute code', 'option id');

share|improve this answer

answered May 22 '18 at 5:36

YogeshYogesh

9221923

add a comment | 

Your Answer

StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "479"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);

else
createEditor();

);

function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);



);

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);

Sign up using Google

Sign up using Facebook

Sign up using Email and Password

Post as a guest

Name

Email

Required, but never shown

StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fmagento.stackexchange.com%2fquestions%2f226897%2fmagento-2-get-product-collections-by-specific-attribute%23new-answer', 'question_page');

);

Post as a guest

Name

Email

Required, but never shown

0

For the drop-down attribute, We can filter using drop-down option ID instead of Label.

Your code is like below.

$productcollection = $this->_productCollection
 ->addAttributeToSelect('*')
 ->addAttributeToFilter('age', 18)
 ->load();

share|improve this answer

edited May 22 '18 at 5:10

answered May 22 '18 at 5:01

Nikunj VadariyaNikunj Vadariya

2,8911821

add a comment | 

0

For the drop-down attribute, We can filter using drop-down option ID instead of Label.

Your code is like below.

$productcollection = $this->_productCollection
 ->addAttributeToSelect('*')
 ->addAttributeToFilter('age', 18)
 ->load();

share|improve this answer

edited May 22 '18 at 5:10

answered May 22 '18 at 5:01

Nikunj VadariyaNikunj Vadariya

2,8911821

add a comment | 

For the drop-down attribute, We can filter using drop-down option ID instead of Label.

Your code is like below.

$productcollection = $this->_productCollection
 ->addAttributeToSelect('*')
 ->addAttributeToFilter('age', 18)
 ->load();

share|improve this answer

edited May 22 '18 at 5:10

answered May 22 '18 at 5:01

Nikunj VadariyaNikunj Vadariya

2,8911821

$productcollection = $this->_productCollection
 ->addAttributeToSelect('*')
 ->addAttributeToFilter('age', 18)
 ->load();

share|improve this answer

edited May 22 '18 at 5:10

answered May 22 '18 at 5:01

Nikunj VadariyaNikunj Vadariya

2,8911821

answered May 22 '18 at 5:01

Nikunj VadariyaNikunj Vadariya

2,8911821

answered May 22 '18 at 5:01

Nikunj VadariyaNikunj Vadariya

2,8911821

0

You can filter the collection by attribute code and Option ID.

You can use addAttributeToFilter for collection filter by using a custom attribute.

protected $productCollectionFactory;

public function __construct(
 MagentoCatalogModelResourceModelProductCollectionFactory $productCollectionFactory

)
 $this->productCollectionFactory = $productCollectionFactory;


$productcollection = $this->productCollectionFactory
 ->addAttributeToSelect('*')
 ->addAttributeToFilter('attribute code', 'option id');

share|improve this answer

answered May 22 '18 at 5:36

YogeshYogesh

9221923

add a comment | 

0

You can filter the collection by attribute code and Option ID.

You can use addAttributeToFilter for collection filter by using a custom attribute.

protected $productCollectionFactory;

public function __construct(
 MagentoCatalogModelResourceModelProductCollectionFactory $productCollectionFactory

)
 $this->productCollectionFactory = $productCollectionFactory;


$productcollection = $this->productCollectionFactory
 ->addAttributeToSelect('*')
 ->addAttributeToFilter('attribute code', 'option id');

share|improve this answer

answered May 22 '18 at 5:36

YogeshYogesh

9221923

add a comment | 

You can filter the collection by attribute code and Option ID.

You can use addAttributeToFilter for collection filter by using a custom attribute.

protected $productCollectionFactory;

public function __construct(
 MagentoCatalogModelResourceModelProductCollectionFactory $productCollectionFactory

)
 $this->productCollectionFactory = $productCollectionFactory;


$productcollection = $this->productCollectionFactory
 ->addAttributeToSelect('*')
 ->addAttributeToFilter('attribute code', 'option id');

share|improve this answer

answered May 22 '18 at 5:36

YogeshYogesh

9221923

protected $productCollectionFactory;

public function __construct(
 MagentoCatalogModelResourceModelProductCollectionFactory $productCollectionFactory

)
 $this->productCollectionFactory = $productCollectionFactory;


$productcollection = $this->productCollectionFactory
 ->addAttributeToSelect('*')
 ->addAttributeToFilter('attribute code', 'option id');

share|improve this answer

answered May 22 '18 at 5:36

YogeshYogesh

9221923

answered May 22 '18 at 5:36

YogeshYogesh

9221923

answered May 22 '18 at 5:36

YogeshYogesh

9221923