Magento – get product collection and subcategory id using category id magento 2

magento2

I want to get product collection and subcategory using category id.

I am trying

$category =  2;
    $product = $this->productFactory->create()->getCollection();
    $product->addAttributeToSelect('*');
    $product->addAttributeToFilter('category_ids',$category);

But it gives error like this

Column not found: 1054 Champ 'e.category_ids' inconnu dans where clause,…

And how to get subcategory id from category id?

Best Answer

Please change like this and it will works.

$collection = $this->productFactory->create()
->getCollection()
->addAttributeToSelect('*')
->addCategoriesFilter(['eq' => 2]);

Related Solutions

Magento – How to get custom module collection on form page magento 2

Have you debugged what $this->_categoryFactory->create()->getCollection()->getData() gives you? Just outputting the collection data like that into a select box values field wont get you anywhere.

You need to do something like this i think:

$itemsArray = [];    
foreach($this->_categoryFactory->create()->getCollection()->getItems() as $item) {
    $itemsArray[] = $item->getName(); //or title or whatever it is
}

  $fieldset->addField(
            'category', 'select', array(
        'name' => 'category',
        'label' => __('Select Category'),
        'title' => __('Select Category'),
        'values' => $itemsArray,
        'required' => true,
            )
    );

This is a rough example. Some things might not be correct but should get you going.

Magento – Magento 2 Custom Module Delete Issue [SOLVED]

Check if you have following line in your Model\ResourceModel\Module\Collection.php file:

protected $_idFieldName = 'module_id';

Best Answer

Related Solutions

Magento – How to get custom module collection on form page magento 2

Magento – Magento 2 Custom Module Delete Issue [SOLVED]

Related Topic