Questions tagged [filter]

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

Filter by
Sorted by
Tagged with
0
votes
1answer
6 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
16 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
26 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
51 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
24 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
15 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
49 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
14 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
17 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
19 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
16 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
15 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
18 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
20 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
13 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
19 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
20 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
162 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
36 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
29 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
32 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
1answer
40 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
38 views

Magento 2.3.x : Display all products in custom page with layered navigation

I want to display all magento store products in one single page with layered navigation. I follow this answer. But, it's not display layered navigation and swatches. Also layout of page not display ...
0
votes
0answers
9 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
49 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
18 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
10 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
33 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
96 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
26 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
vote
0answers
28 views

Layered navigation and categories filter

I'm using multiple layered navigation filter (https://github.com/SlavaYurthev/MultipleLayeredNavigation-M2) is allows to select multiple categories at once. But categories filter is not working, I ...
0
votes
0answers
22 views

How can we move current filter (Not whole layered navigation)

How can we move current filter (Not whole layered navigation) <?xml version="1.0"?> <!-- /** * Copyright © Magento, Inc. All rights reserved. * See COPYING.txt for license details. */ --&...
0
votes
1answer
30 views

Magento 2: load disabled category childrens

I need to get all category children of a specific category but disabled categories too. I have this category tree: + Root (ID: 2) // enabled | + Main 1 (ID: 3) // enabled | | + Sub 1 (ID: 4) // ...
0
votes
1answer
90 views

Magento 2 : How to set the different product price to Storeview?

I have this Extension StoreViewPricing, you can set product price in store views, but in Layered Navigation when I'm applying price filter it's not showing proper results as expected. Here's the ...
0
votes
1answer
25 views

Magento 2 :Product Filter in magento 2

Please suggest any free module which can provide the filter in the product listing page like the below screenshot.
1
vote
1answer
79 views

how to filter magento 2 collection with 'or', 'and' combination?

For example, the search query is 'samsung lcd'. it can match with product name or SKU. I have below product names. 1.samsung xyz lcd. 2.samsung lcd pack. 3.samsung mobile 4.screen lcd. so when I ...
0
votes
1answer
82 views

How to Add Date with Time in Orders Filter : Magento 2 Admin Section

In M2 Admin I want to filter my orders with date and time, by default date only in purchase filter section. How to add date and time here. Purchase Date with time already show in the order grid!. How ...
0
votes
1answer
19 views

graphql filer options do not represent filters data

When I query the test site with chomeIQL extension using the query: query category($cat: String) { products(filter: {category_id: {eq: $cat}}) { filters { name filter_items { ...
0
votes
1answer
80 views

Filter does not seem to work (pwa-studio demo)

I cloned pwa studio 3.0.0 and followed the instructions: git clone https://github.com/magento/pwa-studio.git cd pwa-studio yarn install MAGENTO_BACKEND_URL="https://master-7rqtwti-mfwmkrjfqvbjk.us-4....
3
votes
1answer
95 views

Filter renderer column data

I've one grid similar to product grid. <?php namespace LazyCoder\WarehouseListing\Block\Adminhtml\Grid; use Magento\Backend\Block\Widget\Grid\Extended; use Magento\Backend\Block\Template\Context; ...
0
votes
1answer
18 views

Wrong price in url while using price filter - Magento 2

I'm using Magento layered navigation. While I'm trying to filter by price it's getting wrong value in the URL. Like I'm trying to filter from $2.00 to $4.99 but the URL got 2-5. What I want is either ...
0
votes
0answers
24 views

Magento 1.9 catalog layered filter via ajax

How can we get the filtered data via ajax without using any plugin? I have created a module for ajax filtering. But don't know how to render the data through catalog/product/list.phtml. Does anyone ...
1
vote
0answers
29 views

Filter search not working in magento 2

How to filter search work with select option(it still work with text field) <field name="job"> <argument name="data" xsi:type="array"> <item name="options" ...
0
votes
2answers
43 views

Magento 2 Round off layered navigation max price in the price range

I want to round off the price range values in the layered navigation. Now it is showing as below $40.00 - $49.99 $50.00 - $59.99 $60.00 - $69.99 $70.00 - $79.99 $90.00 and above I want the following ...
0
votes
1answer
32 views

Magento 1.9 : How can i filter specific state inside foreach with Observer

How can I add if the condition for my for each loop, my_observer : <?php class Gta_GetOrderDetails_Model_Observer { public function getdetailsafterorder($Observer) { ...
0
votes
0answers
13 views

Admin panel product filtering - Magento 1.9

when I open Catalog->Manage Products and want to filter by Name, SQU, Price, etc, after pressing enter Please wait ... message does freezes browser window and all I can do is refresh window. Of course ...
0
votes
1answer
346 views

Magento 2: Filter Custom Column in Admin Grid

I have a custom column in an admin grid, this column is populated with a custom renderer and is not actually saved to the database. Is it possible to still filter by this column? in my Grid.php file: ...
1
vote
2answers
43 views

How to output and filter collection using “->where” filter?

I trying to get output from collection using 'where' filter but no result. This is my code: $collection = Mage::getModel('my_work/datanews') ->getCollection() ->...