Mrthdrb

Is it tax fraud for an individual to declare non-taxable revenue as taxable income? (US tax laws)

How can I automatically replace [[ and ]] with the [LeftDoubleBracket] and [RightDoubleBracket] operators?

Question about Goedel's incompleteness Proof

Continuity at a point in terms of closure

Is there really no realistic way for a skeleton monster to move around without magic?

How long does it take to type this?

Symplectic equivalent of commuting matrices

Prevent a directory in /tmp from being deleted

What is the offset in a seaplane's hull?

Can I interfere when another PC is about to be attacked?

How to re-create Edward Weson's Pepper No. 30?

What do you call something that goes against the spirit of the law, but is legal when interpreting the law to the letter?

Email Account under attack (really) - anything I can do?

Example of a relative pronoun

Infinite past with a beginning?

Why has Russell's definition of numbers using equivalence classes been finally abandoned? ( If it has actually been abandoned).

Why CLRS example on residual networks does not follows its formula?

A Journey Through Space and Time

Draw simple lines in Inkscape

How to add power-LED to my small amplifier?

When blogging recipes, how can I support both readers who want the narrative/journey and ones who want the printer-friendly recipe?

How is it possible to have an ability score that is less than 3?

Do airline pilots ever risk not hearing communication directed to them specifically, from traffic controllers?

Why is the design of haulage companies so “special”?

Add category attribute in collection filter (search)

Sort order by category id (or custom order)Reset layer product collection filter in searchWhat should the attribute value be for a custom attribute in an array passed to getProductByAttributes?Mini search only in one categoryFilter Search Results using Attribute and CategoryHow to add custom product on catalog search collection?Category search logic (AND instead of OR)Modify catalogsearch module to search by attribute valuesMagento Search filter not workingFilter product search by categoryHow to filter category collection?

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;

1

I've created an attribute for my categories (it's displayed on back-office and I can save values).

In sur php file Result.php for the research process, I want to add this attribute as a filter.

how to I do that ? In _getProductCollection I've added this line :

 $this->productCollection = $this->getListBlock()->getLoadedProductCollection();
 $this->productCollection->getSelect()->join(array('cats' => 'catalog_category_product'), 'cats.product_id = e.entity_id');
 $this->productCollection->getSelect()->group("cats.attribute");

But it shows non filtered result

Any thoughts ?

magento2 category attributes search catalogsearch

share|improve this question

asked Apr 4 at 12:20

Morgan TartreauMorgan Tartreau

39312

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  If I remember correctly the catalog_category_product table is just a pivot table containing the ID of the product and category and position. If you want to add a group of your category attribute it will be a bit more complex if you're doing it like this because categories are EAV entities so you'll have to join a few tables to get your value. I don't fully grasp why you're grouping products by a category attribute. Should the attribute be on the product instead, or the grouping done on a collection of categories?
  
  – rain2o
  Apr 4 at 14:30
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Please see my other "old" post. magento.stackexchange.com/questions/266723/…
  
  – Morgan Tartreau
  Apr 4 at 14:37
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Maybe try using addCategoryIds on the collection first and then see if you can do a join. Part of the challenge here is the fact that products can belong to multiple categories so that could cause a complication in the joining and grouping.
  
  – rain2o
  Apr 4 at 15:03
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Already tried, but not a success
  
  – Morgan Tartreau
  Apr 4 at 15:06
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  What file should I override to do that ?
  
  – Morgan Tartreau
  Apr 4 at 16:04
  

  
  
  
  

add a comment | 

1

I've created an attribute for my categories (it's displayed on back-office and I can save values).

In sur php file Result.php for the research process, I want to add this attribute as a filter.

how to I do that ? In _getProductCollection I've added this line :

 $this->productCollection = $this->getListBlock()->getLoadedProductCollection();
 $this->productCollection->getSelect()->join(array('cats' => 'catalog_category_product'), 'cats.product_id = e.entity_id');
 $this->productCollection->getSelect()->group("cats.attribute");

But it shows non filtered result

Any thoughts ?

magento2 category attributes search catalogsearch

share|improve this question

asked Apr 4 at 12:20

Morgan TartreauMorgan Tartreau

39312

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  If I remember correctly the catalog_category_product table is just a pivot table containing the ID of the product and category and position. If you want to add a group of your category attribute it will be a bit more complex if you're doing it like this because categories are EAV entities so you'll have to join a few tables to get your value. I don't fully grasp why you're grouping products by a category attribute. Should the attribute be on the product instead, or the grouping done on a collection of categories?
  
  – rain2o
  Apr 4 at 14:30
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Please see my other "old" post. magento.stackexchange.com/questions/266723/…
  
  – Morgan Tartreau
  Apr 4 at 14:37
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Maybe try using addCategoryIds on the collection first and then see if you can do a join. Part of the challenge here is the fact that products can belong to multiple categories so that could cause a complication in the joining and grouping.
  
  – rain2o
  Apr 4 at 15:03
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Already tried, but not a success
  
  – Morgan Tartreau
  Apr 4 at 15:06
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  What file should I override to do that ?
  
  – Morgan Tartreau
  Apr 4 at 16:04
  

  
  
  
  

add a comment | 

I've created an attribute for my categories (it's displayed on back-office and I can save values).

In sur php file Result.php for the research process, I want to add this attribute as a filter.

how to I do that ? In _getProductCollection I've added this line :

 $this->productCollection = $this->getListBlock()->getLoadedProductCollection();
 $this->productCollection->getSelect()->join(array('cats' => 'catalog_category_product'), 'cats.product_id = e.entity_id');
 $this->productCollection->getSelect()->group("cats.attribute");

But it shows non filtered result

Any thoughts ?

magento2 category attributes search catalogsearch

share|improve this question

asked Apr 4 at 12:20

Morgan TartreauMorgan Tartreau

39312

 $this->productCollection = $this->getListBlock()->getLoadedProductCollection();
 $this->productCollection->getSelect()->join(array('cats' => 'catalog_category_product'), 'cats.product_id = e.entity_id');
 $this->productCollection->getSelect()->group("cats.attribute");

share|improve this question

asked Apr 4 at 12:20

Morgan TartreauMorgan Tartreau

39312

share|improve this question

asked Apr 4 at 12:20

Morgan TartreauMorgan Tartreau

39312

asked Apr 4 at 12:20

Morgan TartreauMorgan Tartreau

39312

asked Apr 4 at 12:20

Morgan TartreauMorgan Tartreau

39312