Mryntu

How do I express some one as a black person?

How do I deal with a powergamer in a game full of beginners in a school club?

Replacing Windows 7 security updates with anti-virus?

Set and print content of environment variable in cmd.exe subshell?

How do I locate a classical quotation?

Making a sword in the stone, in a medieval world without magic

How do you like my writing?

Low budget alien movie about the Earth being cooked

What does a stand alone "T" index value do?

infinitive telling the purpose

"One can do his homework in the library"

Algorithm to convert a fixed-length string to the smallest possible collision-free representation?

Built-In Shelves/Bookcases - IKEA vs Built

The bar has been raised

Solving "Resistance between two nodes on a grid" problem in Mathematica

What to do when during a meeting client people start to fight (even physically) with each others?

Do items de-spawn in Diablo?

Unreachable code, but reachable with exception

Rejected in 4th interview round citing insufficient years of experience

How did Alan Turing break the enigma code using the hint given by the lady in the bar?

A three room house but a three headED dog

Is there an elementary proof that there are infinitely many primes that are *not* completely split in an abelian extension?

Good for you! in Russian

Good allowance savings plan?

Magento 2 : Join category name in product collection

Add Customs column to Admin > sales >orderAdding attribute using JOIN to CollectionMagento 2 Join Product Name To Custom Grid DI Not workingAfter join the customer name with custom module, i can't filter the grid by customer namehow to join fields like product skus in sales order grid collection in magento2?Filter product collection by sku or nameMagento - Add customer attribute to order gridMagento 2 Create dynamic array From different Model Collection to use in multi select in gridAfter return parent::_prepareCollection() store filter not working in product collectionMagento 2 : Category name filter in product grid in custom module

0

I want to join category name in product collection. I want to use that in product grid filter which is used in my custom module.

This is my collection code. It's same as like this _prepareCollection() :

vendor/magento/module-catalog/Block/Adminhtml/Product/Grid.php

protected $productFactory;

public function __construct(
 .....
 MagentoCatalogModelProductFactory $productFactory,
 .....
) 
 .....
 $this->productFactory = $productFactory;
 .....


protected function _prepareCollection() 
 $store = $this->_getStore();
 $collection = $this->productFactory->create()->getCollection()
 ->addAttributeToSelect(
 'sku'
 )->addAttributeToSelect(
 'name'
 )->addAttributeToSelect(
 'attribute_set_id'
 )->addAttributeToSelect(
 'type_id'
 )->setStore(
 $store
 );

How to do it?

Any help would be appriciated.

Thanks.

magento2 product grid

share|improve this question

edited 9 hours ago

Gee Emm

1078

asked 10 hours ago

Emipro Technologies Pvt. Ltd.Emipro Technologies Pvt. Ltd.

2,5911825

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  I'm not sure what you want as result since a product can be in more than one category. Therefore your grid would have more entries for one product sku if the product is in more than one category. Is that what you expect?
  
  – HelgeB
  8 hours ago
  

  
  
  
  

add a comment | 

0

I want to join category name in product collection. I want to use that in product grid filter which is used in my custom module.

This is my collection code. It's same as like this _prepareCollection() :

vendor/magento/module-catalog/Block/Adminhtml/Product/Grid.php

protected $productFactory;

public function __construct(
 .....
 MagentoCatalogModelProductFactory $productFactory,
 .....
) 
 .....
 $this->productFactory = $productFactory;
 .....


protected function _prepareCollection() 
 $store = $this->_getStore();
 $collection = $this->productFactory->create()->getCollection()
 ->addAttributeToSelect(
 'sku'
 )->addAttributeToSelect(
 'name'
 )->addAttributeToSelect(
 'attribute_set_id'
 )->addAttributeToSelect(
 'type_id'
 )->setStore(
 $store
 );

How to do it?

Any help would be appriciated.

Thanks.

magento2 product grid

share|improve this question

edited 9 hours ago

Gee Emm

1078

asked 10 hours ago

Emipro Technologies Pvt. Ltd.Emipro Technologies Pvt. Ltd.

2,5911825

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  I'm not sure what you want as result since a product can be in more than one category. Therefore your grid would have more entries for one product sku if the product is in more than one category. Is that what you expect?
  
  – HelgeB
  8 hours ago
  

  
  
  
  

add a comment | 

I want to join category name in product collection. I want to use that in product grid filter which is used in my custom module.

This is my collection code. It's same as like this _prepareCollection() :

vendor/magento/module-catalog/Block/Adminhtml/Product/Grid.php

protected $productFactory;

public function __construct(
 .....
 MagentoCatalogModelProductFactory $productFactory,
 .....
) 
 .....
 $this->productFactory = $productFactory;
 .....


protected function _prepareCollection() 
 $store = $this->_getStore();
 $collection = $this->productFactory->create()->getCollection()
 ->addAttributeToSelect(
 'sku'
 )->addAttributeToSelect(
 'name'
 )->addAttributeToSelect(
 'attribute_set_id'
 )->addAttributeToSelect(
 'type_id'
 )->setStore(
 $store
 );

How to do it?

Any help would be appriciated.

Thanks.

magento2 product grid

share|improve this question

edited 9 hours ago

Gee Emm

1078

asked 10 hours ago

Emipro Technologies Pvt. Ltd.Emipro Technologies Pvt. Ltd.

2,5911825

protected $productFactory;

public function __construct(
 .....
 MagentoCatalogModelProductFactory $productFactory,
 .....
) 
 .....
 $this->productFactory = $productFactory;
 .....


protected function _prepareCollection() 
 $store = $this->_getStore();
 $collection = $this->productFactory->create()->getCollection()
 ->addAttributeToSelect(
 'sku'
 )->addAttributeToSelect(
 'name'
 )->addAttributeToSelect(
 'attribute_set_id'
 )->addAttributeToSelect(
 'type_id'
 )->setStore(
 $store
 );

share|improve this question

edited 9 hours ago

Gee Emm

1078

asked 10 hours ago

Emipro Technologies Pvt. Ltd.Emipro Technologies Pvt. Ltd.

2,5911825

share|improve this question

edited 9 hours ago

Gee Emm

1078

asked 10 hours ago

Emipro Technologies Pvt. Ltd.Emipro Technologies Pvt. Ltd.

2,5911825

edited 9 hours ago

Gee Emm

1078

edited 9 hours ago

Gee Emm

1078

asked 10 hours ago

Emipro Technologies Pvt. Ltd.Emipro Technologies Pvt. Ltd.

2,5911825

asked 10 hours ago

Emipro Technologies Pvt. Ltd.Emipro Technologies Pvt. Ltd.

2,5911825