how to add category wise filter

[ashish2409]

@moncherry29

Hello There,

Have you followed all above correctly? As it is very important to enable Layered Navigation while creating a new attribute for checking the details to be visible in Category Page.
In case you have any doubt we will be helping you for the same.

Thank You,

[moncherry29]

@ashish2409 Yes i did! The filter is now on my front-end, but when i try to filter on anything no products are appearing.

Look for example:

But on my product:

I am in the right category, that is not the problem. But I can’t filter in my attributes for some reason, but the price filter is working perfect.

[ashish2409]

@moncherry29

Can you please let us know in which version you are facing this issue, let me check the issue in same version as well.
I will help you in same.

[moncherry29]

@ashish2409 i am on version 2.0.0.

[moncherry29]

@ashish2409 this is my network when i filter on the item:

and this is in my database the value:

so the product_id is the 280 and the 44 is the attribute id of the "testfilter" attribute.

[ashish2409]

@moncherry29

Ok Thanks for sharing the screenshot, we will be checking the same in our localhost in master code and will update you ASAP.

[moncherry29]

@ashish2409 thank you very much! im waiting for your repsonse

[ashish2409]

@moncherry29

Hello There as I have checked the same in the master and lateset version of bagisto and there I was able to see that it is working fine. For an ease I have created a video for your reference.
I believe that this will help in resolving you concern.

Please follow the link -> https://jam.dev/c/4f6fa2cf-a2e8-4bef-b449-9d6a7be63dc8

[moncherry29]

@ashish2409 Very weird

I have the same settings as you, i have made a video. i am on version 2.0.0, are you too?

i have made a video of my settings: innovatiemedia.nl/video-trrc.mov

is it maybe possible to call you?

[ashish2409]

@moncherry29

No I am using latest version V2.1.2 and master version.

[moncherry29]

@ashish2409 are there differences in the filter or categoryattribute or other relevant files between 2.0.0 and 2.1.2?

[ashish2409]

@moncherry29

I am looking for the same case in V2.0.0 then only I can assist you better. Please allow me some time.

[moncherry29]

@ashish2409 Ok thank you very much, if it is easier maybe we can do a phone call or something

[ashish2409]

@moncherry29

"Hello there,
you can raise a ticket and share all the details so that we can assist you better.

Ticket Link -> https://webkul.uvdesk.com/en/customer/create-ticket/"

[moncherry29]

@ashish2409

I fixed the issue, i found it.

In v2.0.0 in ProductRepository.php in the searchFromDatabase function there is an added line:

             $qb->havingRaw('COUNT(*) = ' . count($attributes));

If you remove this line everything works fine again.

[ashish2409]

@moncherry29 said in how to add category wise filter:

$qb->havingRaw('COUNT(*) = ' . count($attributes));

Hello there,

You can check V2.1.2 , there are many changes and its the stable version you can check the details here as well.

https://github.com/bagisto/bagisto/blob/v2.1.2/packages/Webkul/Product/src/Repositories/ProductRepository.php

I would suggest to go and check here as well.

Thanks.

[ashish2409]

This post is deleted!