Questions tagged [filter]

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

Filter by
Sorted by
Tagged with
1
vote
0answers
22 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
11 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
10 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
24 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
8 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
17 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
36 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
9 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
13 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
16 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
16 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
33 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
90 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
43 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
1answer
232 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
20 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
11 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
30 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
23 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
37 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
26 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
63 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
58 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?
0
votes
0answers
35 views

How to Create Custom Grid Filter Show All “NULL” Values in Specific Column

How can I make a filter for null values of my order ID <column name="order_id"> <argument name="data" xsi:type="array"> <item name="config" xsi:type="array"> ...
0
votes
0answers
19 views

magento 2 show category filter options all the time

I want to show all category filter options even if filter is selected. When user selects option it only shows the selected option. Same question was asked by some one here magento 2 : show all ...
0
votes
1answer
66 views

Magento 2 : Custom column filter with serialize data in UI grid

I added product name column in my module ui grid. In my database, it's save product id. I display successfully product name in column by product id. But, filter not working when I search by product ...
0
votes
0answers
16 views

Are filterable attributes with negative values possible, using “prices” to be filterable using a slider?

In a Magento 2 shop, we have two new attributes for simple products, "temperature min" and "temperature max". These attributes should be used for filtering using a slider (for each attribute), as it ...
0
votes
1answer
29 views

How to change currency symbol in filter Magento 2

I am new in Magento 2 and in frontend category page there is a filter by price which is range and under it there are two inputs which are disabled and there values are from - to price and the currency ...
0
votes
0answers
20 views

Magento2: How can I apply filter on each column for custom report

I have created one custom report. As per Magento default, they do not provide a filter on each column in the report grid they provide only date range fields. I want a filter on all columns along ...
0
votes
0answers
29 views

Magento 2 How to expand all category filters by default?

I am using Magento 2.3.3 and there are multiple filters are on my category list page. I also used the "Manadev" layered navigation. which allows showing all filters if you select anyone of them. now:...
0
votes
0answers
20 views

How to use “Time Range Picker” for admin ui component grid filters?

I want to add the time range picker for admin UI component grid filters to filter the grid using the time range. In dev docs, I have seen the time range picker but I don't know how to use it in grid ...
0
votes
0answers
37 views

Magento 1 - Show custom module data in catalog search result page

I want to show custom module data in the search result page along with default data collection. Please suggest a proper solution for the same. Thanks in advance.
0
votes
1answer
34 views

Attention: Something went wrong, Error when applying filter

I added an attribute in sales_order, and display it as a column in sales_order_grid, all is set but when I try to apply filter on my custom column it gives me an error with a pop-up like: Attention: ...
0
votes
0answers
14 views

How to display the latest out of stock items

How to display products out of stock are the most recent on the search and category pages. I debug to the file vendor/magento/module-review/Observer/CatalogBlockProductCollectionBeforeToHtmlObserver....
0
votes
0answers
23 views

AMASTY EXTENSIONS - Category Filter when clicked, redirect to the home page url

When I click on one of the category filters in the sidebar, I get a redirect to the base url, I can’t find it because of what. Magento 2.2.3 I have 2 stores, the default store works with this module ...
2
votes
0answers
25 views

Magento 2: How to add product QTY in layered navigation filter?

I need to add qty filter in Layered Navigation so Customer can filter products using qty. I have implemented using product stock status but due to backorders. I need to display products based on ...
0
votes
3answers
169 views

Magento 2 sort by Attribute value

I have multi-select attribute name location like : Delhi , Maharashtra, Karnataka. I want to use sort by of filter by in such way when I use above filter / sort it should show all products but ...
0
votes
1answer
43 views

Magento 2 - Get disabled product by sku

I try to get disabled products by sku. These products are not in flat table, so I can't use collections to find them. I tried some methods to find products, but it doesn't work Magento 2.3.2: ...
0
votes
1answer
30 views

size attribute showing limited items but category products have more than that in magento 2

Size attribute showing limited items in filter navigation but category products have more than that in Magento 2. Please see the following images for more details. Anyone know how to solve it ? ...
1
vote
0answers
36 views

How data are coming into elasticsearch while running catalogsearch_fulltext?

I have elasticsearch as a catalog search engine. Whenever we are running catalogsearch_fulltext, it is pushing the data into elasticsearch. I need to do apply filter to those data before pushing into ...
0
votes
2answers
44 views

URL Query parameters are being lost

I am having a strange issue with my product filter (layered navigation) not working, I have narrowed this down to the URL paramaters being lost because of a 301 redirect. If I go to the URL... http://...
0
votes
0answers
14 views

product collection result overriding by other module

I have two 3rd party modules one groupCat module which filters out the product collection to display customers based on customer groups. another module is the search module which fetches all products ...
0
votes
0answers
13 views

Magento 2.3.1 Category filter option

I need to enable category filter options. I noticed that the "Use in Layered Navigation" dropdown is disabled under product attributes storefront properties. how can I update this to "Filterable (with ...
2
votes
2answers
52 views

Magento 2.3.2 Collection foreach didn't get disabled product

I am using Magento 2.3.2. I am filtering collection if product ids found in array. before foreach if I am printing collection I am getting data. But in foreach I am not getting any data. $productIds ...
0
votes
1answer
20 views

Loading collection of products from a Category with admin filters

I am currently working on a project where it loads a collection of products with a CategoryFilter. $category = $this->categoryFactory->create()->load($categoryId); $collection = $this-&...
0
votes
0answers
11 views

How to filter configurable product and simple product?

Here I am creating my own query for filter products. But I am facing one issue when I trying to filter by size. If size selected in simple product of configurable product then simple product is comes ...
0
votes
1answer
36 views

In Magento 2 how can I return a collection without the top 10% and bottom 10%?

I am looking to return a subset of reviews for example but discard the top x% and bottom x% I could do it with an SQL query such as SELECT * FROM ( SELECT review_date, review_score, @r:= @r + 1 ...
0
votes
1answer
211 views

How to add Store View Filter in Custom Listing Grid In Magento 2.X?

I have created a custom module in my Magento 2.3.1 site. The module has Admin Listing Grid and Add/Edit view. My site is multi-store site, Now I want to display "Store View" filter in listing grid at ...
0
votes
0answers
28 views

apply filter without join on custom column in sales order grid in magento 2

i have custom column in sales order grid and want to apply filter on this . When i apply filter then generate log unknown column my_custom_column is not exist My Custom Column is not exits in any ...

1 2 3 4 5 14