Questions tagged [filter]

Denotes questions about filtering in Magento (layered navigation, collection filtering)

Filter by
Sorted by
Tagged with
0
votes
1answer
37 views

Magento 2.3.4 - How to create filter by product rating in layered navigation

I want to have a filter by product rating in layered navigation. Regarding this, I found a solution Magento 2 : Rating Filter in Layered Navigation. This is working fine if you modify vendor\magento\...
0
votes
0answers
7 views

Customers Grid's Filters Button is disabled

I just mount a developer environment (copy from my production environment). When I log in to the administrator and go to Customers > All Customers, the Customers Grid display weel. However, the "...
0
votes
0answers
16 views

Custom filter in order grid

I'm trying to add a new field to order grid with custom filter. Right now I managed to make it work, but I want to add my custom filtering rule. I added the column to db_schema.xml and in my module'...
0
votes
0answers
12 views

With GraphQL can I apply a filter in customAttributeMetadata?

I'm getting the values and labels for an specific attribute_code. query{ customAttributeMetadata( attributes: { attribute_code: "armazenamento" entity_type: "4" } ) { ...
0
votes
1answer
30 views

How to change the position of the filters in product page or Layered navigation

Hi, I need to change the layer navigation position as shown in below image the Manufacturer first and Category to second. But i can't find how to change these. The Category must come at second ...
0
votes
0answers
12 views

How to filter products by “ Set Product as New From To” datepicker ? Magento 2

I need to filter product collections by " Set Product as New From-To" (attached), can anyone helps me ? Thanks
3
votes
0answers
29 views

Change default price filter behaviour for pwa in magento 2.3.4 using graphql

I have a requirement in which i need to customise the default price filter in magento and change the behaviour so that the price ranges will be constant and need to show all the ranges after a price ...
0
votes
0answers
5 views

I can't add the product attribute in the fillter tab in magento 2.3

I need to add the product attribute in the filter tab but i can't add the attribute i followed the this link https://docs.magento.com/m2/ee/user_guide/catalog/navigation-layered-filterable-attributes....
0
votes
0answers
13 views

BRAND as catalog NAVIGATION AND as FILTER option. COMMENTS requested

The goal is to use the product’s brand for the Layered navigation (Categories) , AND for the filtering of the products. Yes…. Sure we know ... we can BUY plenty of MARKETPLACE solutions... BUT maybe ...
0
votes
0answers
11 views

Magento 2 Custom grid join with product table filter is not working

I've created a custom grid using Ui Component, In my custom table I have a product_id, So instead of showing the product_id, I like to show the product name in my grid so that I have added the below ...
0
votes
1answer
27 views

Magento 2 : Add product category filter in order grid

In admin I want to add product category filter in order grid so that admin can filter by category and processed the order. Please help me guys. Thanks
0
votes
0answers
13 views

Magento2.3 : Layered navigation still appear even Anchor =“No”

I want 1column design (No left bar) for the specific category in which I chose Display Mode = "static block only" Also set Achor ="No" 1column layout is applied But "shop by" still appear on ...
0
votes
1answer
30 views

Triyng to filter products with value_id

Tried filtering with option_id and value_id but it is looking for value and when I change it to catalog_product_entity_int.value_id or at_manufacturer.value_id it returns syntax error. Trying to ...
0
votes
0answers
16 views

Magento 2 Not show Layered Navigation in Advance Search Result

I need Layered Navigation in advance search result Here is the code of my file. httpdocs/app/design/frontend/Smartwave/porto/Magento_CatalogSearch/layout <?xml version="1.0"?> <!-- /...
0
votes
0answers
18 views

Filtering products with option_id

How can I filter products by option_id ? The "manufacturer.option_id" attribute name is invalid. Reset the name and try again. found something here https://mage2.pro/t/topic/1249 and tried something ...
0
votes
0answers
13 views

UI Component: How to filter a custom column with data generated by logic?

I added a custom column named Payment Code to order listing page in admin: <?xml version="1.0" encoding="UTF-8"?> <listing xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:...
0
votes
1answer
22 views

Dynamically generated block identical for all clients - Why?

I use PHP to create the content of a block dynamically on a CMS page (created via the admin portal). But I found out during testing that the first generated block remains active for all clients until ...
0
votes
0answers
13 views

How can i Display whole the products of website with filter in magento2

I have created multiple website in Magento 2. In Main website I want to display all the products but in second website i want to display only those product which have brand test. Brand is product ...
0
votes
0answers
22 views

Override Layered Navigation Filter(s) on Category Page

Not sure if I'm asking the correct question. I wanted to know if/where its possible to override the filter for the layered navigation on a category page. For example, in this image, if I wanted to ...
0
votes
0answers
9 views

Product list pagination missing second parameter (/category1/category2.html)

I created a custom module to handle filters by 2 categories, like: https://example.com/clearance/phones.html. Clearance and phones are both categories. The router is working properly. I'm filtering ...
0
votes
0answers
15 views

Magento 2 rest api: filtering products endpoint by ID

I find myself unable to filter product data by the integer field "id". Error I get is: HTTPError: 400 Client Error: Bad Request for url: https://www.REDACTED.com/rest/V1/products?searchCriteria[...
0
votes
1answer
21 views

Magento 2.2.3 How to export products with SKU filter in admin?

Hi, I need to export products with .csv file. But I need to export products with specific SKU. For example, I wanted to export the products which SKU was 60010, 60012 and 45580 I know I should apply ...
0
votes
1answer
30 views

Magento2 - Admin grid Filter tab always show active

How to make admin panel grid filter on all the page. Tab always show active. Like a shared screenshot.
0
votes
0answers
28 views

Magento2 - Price Layered Navigation Issue

When a product price is more than 100,000 . The price filter showing only two options 13,000 - 100,000 100,000 - 130,000 As filterable options , When i disabled the product which is having price ...
1
vote
0answers
41 views

How to filter pending and processing orders at the same time

I want to be able to filter orders "pending" and "processing" at the same time (like the last option on the image). How would I do that?
0
votes
1answer
45 views

Magento 2 - Display all products on homepage

I'm trying to add a overview of all products with filter on the Homepage of my Magento store. I followed the following tutorial from PHP Cuong which I got up and running. https://github.com/php-cuong/...
1
vote
0answers
25 views

Product attribute filter code

How does product attribute filtering works? It seems to return values through ajax when some URL like this is called "test.html?color=5459&size=5447" but where is this ajax is being called? And ...
0
votes
0answers
13 views

Product attribute filter with multiple attributes

I added some attributes to product and filter is only taking 1 filter option from each attributes. How do I make it like checkbox with multiple selections?
0
votes
0answers
13 views

Magento UI range filters missing in Magento 2.3.3

date range filters are missing in the My Quotes section after migrating magento from 2.2.10 to 2.3.3 <div class="quote-grid-filters-wrap" data-part="filter-form" visible="hasVisible()"> <...
1
vote
0answers
30 views

magento 2 keep the applied filters in opened state

I wish to make changes in the layered navigation filter, so that all the applied filters are visible(opened state). For example I am selecting red in color filter, all other options in color filter ...
0
votes
0answers
9 views

How to make Sales Order Grid “status” Filter working with custom Default Status Filter

I have added status filter to order grid using filterUrlParams method by passing the status value in url. But I am facing issue when i am trying to apply status filter, its gives no result. I need to ...
0
votes
0answers
19 views

Search / Filters - returning grouped/configurable/options results when their children match?

I am trying to understand why in the core Magento functionality search and layered navigation are fine returning parent products when children are a match, but why so many extensions fail to do so. ...
0
votes
1answer
78 views

How to add a multi select category and attribute filter on catalog page

My magento 2.3.3 theme provides me single select from same category or attribute. Here if i select a sub category all the other categories will get disappears because it is single select. But i want ...
0
votes
0answers
10 views

Filter Layer Collection

I rewrite getProductCollection in /vendor/magento/module-catalog/Model/Layer/Search.php. How could i filter collection there. In filter i need remove all products with attributeSetId = $id &&...
0
votes
0answers
18 views

Magento2: How to create custom module category page with filter?

I have category listing page and I want to display product on same page. I want to display same layout like category page with filter. Please help.
0
votes
0answers
17 views

Can we apply layered navigation filters for featured products block in category page?

We created one Featured product's slider in the category page, Is there is any possible way to apply the same layered navigation filters for the category products to the Featured products block in ...
0
votes
0answers
18 views

Magento2 I have using Magenative mobiconnect Extension But getting issue on filter product attribute api

I have using Magento2.2.6 and I have to used Third Party Mage native Mobiconnect Extension integrated and have find on filter size there data showing on website level properly if product in stock ...
1
vote
2answers
67 views

How to remove collection filter from Magento 1.9?

I want to add filter to grid. When I add filter to sales_billing_agreement, I got the following error. SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'store_id' in where clause is ...
2
votes
1answer
116 views

How to filter products by rating in Magento 2?

I want to get all products by rating filter. here my code $getProducts = $objectManager->create('Magento\Catalog\Model\ResourceModel\Product\Collection'); $getProducts->addAttributeToSelect('*')...
0
votes
1answer
120 views

Filter collection by config product attribute value in magento 2 programmatically

I would like to know. How can i filter collection by attributes value as I am making filter api for app. Please check below code where i am filter the collection this is working for simple products ...
2
votes
2answers
1k views

How to filter product collection with default graphql products query

I am using Magento 2 Graphql to get product collection based on category id. I want to apply filter by color, size, material etc. I have checked the graphql available filters and those are not ...
1
vote
0answers
23 views

How do I call the Magento API SOAP V2 with multiple complex filters to the same field?

How do I call the Magento API SOAP V2 with multiple complex filters to the same field? In my case I use the salesOrderList function. This source code does not work: $params = array(array( '...
0
votes
0answers
14 views

How to sort layered navigation items alphabetically and numerically

In my layered navigation, I have items that are being sorted by quantity. For example the items with the most quantity are listed higher, and lower quantity are listed lower. What i am looking for ...
2
votes
0answers
43 views

How to use the null- or notnull-operator with (complex) filter in Magento (1.9) API SOAP v2

For example: sales_order_list api function filter operators Possible solutions: value = "notnull" value = "" value = null value = "true" value = "1" use simple filter anything else?!?! Who knows?
2
votes
0answers
26 views

How do i add quick filters to the admin grids?

I've been trying to add a new filter category for an already existing column when I discovered the existence of Quick Filters. My question is twofold: is Quick Quickfilters compatible with the ...
1
vote
1answer
51 views

Filter range doesn't work on custom grid table dashboard. Magento2

In custom table in ui component i use <filterRange> for filter from to but it doesn't work. I need to filter between the date of the column, i.e. show the columns in which there is a match from ...
1
vote
0answers
44 views

Magento 2.3: How to create a custom filter?

I'm having a requirement that is related to filtering the products. By default, when the user clicks on the category, it will be redirected to the corresponding product listing page. But my ...
0
votes
1answer
189 views

Magento 2 Custom filter of product list page not affecting layered navigation

I have a filter in My list.phtml like below: $_productCollection = $block->getLoadedProductCollection(); if($_COOKIE['selectToGarageList']){ $dat = $_COOKIE['selectToGarageList']; ...
0
votes
0answers
14 views

Magento Custom Filter Value in Collection.php [duplicate]

I want to add this code: $this->addFieldToFilter("main_table.order_id", array("null" => 1)); return $this; To my Collection.php: protected function _initSelect() { parent::...
1
vote
1answer
80 views

Filter for Magento Admin Grid All “NULL” Values

Is there a way to create a filter for NULL values in Magento Custom Admin Grid?

1
2 3 4 5
14