Questions tagged [filter]

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

Filter by
Sorted by
Tagged with
0 votes
0 answers
8 views

Magento 2 Graphql: custom filter products not working

I want to add a custom filter (Stock status filter) to products like this one but it's not working. How to filter product collection with default graphql products query in Magento 2 I used XDebug to ...
user avatar
1 vote
2 answers
121 views

Magento 2 : Create a JOIN

I am trying to display a report which GROUP BY : SKU and Subsidiary. So instead of displaying each RMA in different rows, I am trying to display Filtered Report, Group by SKU and 2nd group by ...
user avatar
  • 58
1 vote
3 answers
72 views

Filter admin order by store id magento 2

I'm trying to filter orders by store instead of store view. I have 2 stores, each has 2 store views. I wanted to filter order with store. I declared a collection in di.xml <type name="Magento\...
user avatar
0 votes
2 answers
35 views

Some Filters not showing on some Categories in Magento 2.4

Some Filters not showing on some Categories in Magento 2.4 As you can see in two images both are diffrent categories but Newest filter not showing in second image. In some categories it just show ...
user avatar
  • 526
0 votes
0 answers
15 views

Add Filter grid into existing newsletter table that not containing ui_component folder

can anyone help me please? its the original file newsletter module after installing magento2.4.3 i have tried a lot online ways buttheir was just add a column only.
user avatar
0 votes
1 answer
53 views

Magento 2.3: Add stock status filter in product admin grid

I want to add stock status dropdwon filter in product admin grid like this: I tried this: https://magecomp.com/blog/how-to-add-stock-status-column-in-admin-product-grid-magento-2/ but it didnt work.
user avatar
0 votes
1 answer
30 views

How to change filter "and" to "or"?

version : Magento 2.4 safira I want my website show every products related to filters I choose. If I choose multi filters, I only got products fulfilled all conditions. Is there any way I can edit ...
user avatar
0 votes
0 answers
25 views

Stock sources as filters layered navigation

I'm quite new to Magento2 so correct me if there is anything unclear or impossible to do. We have different stock sources (stock for Europe and for the UKs). I would like our customers to be able to ...
user avatar
0 votes
0 answers
14 views

How to add dropdown *select filter* for Province/State as we have like payment method filter or status filter in sales order grid magento 2

So I have customize my order grid by adding 1 more column states.. It goes well with the text filter. I want to add the dropdown filter of states rather than textfield. Does Anyone here to help? Or go ...
user avatar
  • 1
0 votes
0 answers
20 views

How to hide and show option from massaction dropdown for specific filter in Magento2?

I want to show options from massaction dropdown when I apply a UI component filter? Is there any way to achieve this functionality?
user avatar
  • 3,111
0 votes
2 answers
49 views

Magento 2.4 FilterSearch Custom admin grid

I'm trying to modify the admin grid's "filterSearch" field from default query if I type a whole word eg "Iphone", I'm trying to change the type search criteria in SQL to LIKE %ipho%...
user avatar
0 votes
0 answers
47 views

Magento 2 Add Custom date filter in UI Grid

I have created a custom grid for my custom table. It has a created_at column. Now I want to filter the entries by 7 days, 30 days, 90 days. ie, a dropdown with options 7days, 30 days, 90 days. How do ...
user avatar
0 votes
1 answer
18 views

How to make custom customer attribute filterable in the customer grid?

I've made a patch and this is the code for creating my customer custom attribute: public function apply() { $this->moduleDataSetup->getConnection()->startSetup(); /** @var ...
user avatar
  • 3,575
0 votes
0 answers
24 views

Magento 2.3.7 filter without results in prod system

On Product-Listing the available Filters got listed for the configured Product Attributes, also the availabe amount of products for this attribute is shown within braces on the listing. When apply a ...
user avatar
  • 141
0 votes
1 answer
38 views

Magento2 product distance sort and filter

I need a custom extension for Magento2 - sort and filter product distance with map. Its extension for m1 i needed to m2 I try converter code m1 to m2 but - but lack of knowledge ( Please help anybody, ...
user avatar
0 votes
1 answer
147 views

Magento 2 Admin Orders Date show not actual result

I have Magento 2.4.2-p1 EE. When i filter orders by dates, example: Purchase Date: 12/12/2021 - 12/12/2021 I have result with 777 found orders. But on last page i can see orders with wrong dates for ...
user avatar
0 votes
0 answers
33 views

How to get category name and count product when selecting manufacturer select attribute in Magento 2?

I have created a new page where I want to get the number of selected products from the same manufacturer in all categories into a list. Does anyone have any idea, how to get this data? Thanks. https://...
user avatar
0 votes
1 answer
111 views

How we can add category Filter to assign product grid

I want to add a category filter to the assigned product grid in Magento 2. Please help me out. Thanks in advance.
user avatar
0 votes
0 answers
98 views

Magento 2 catalog search - request query and filters aren't set

I am configuring a fresh Magento 2 installation, and encountered a problem with the catalog search. The request returns this exception: #1 Magento\Framework\Data\Collection\AbstractDb->...
user avatar
  • 165
0 votes
0 answers
13 views

Catalog Price Rule - filters not showing

I am trying to filter on my store, but the results are not appearing? As you can see below. I also try to navigate page by page, but one page seems not to be working. Any ideas how to solve this? ...
user avatar
  • 1
0 votes
0 answers
26 views

how i can change number format in filter price

when i use the filter price in any category the filter show decimal value like this but my filter is ?price=100000-200000. How i can fix it? thanks advance. Regards
user avatar
0 votes
1 answer
230 views

Date range issue in sales order grid in Magento2

In the sales order admin grid when we select a date range in Filter option Magento backend Sales -> Orders, it is not sticking to that date, and showing other dates too in the filter... For example,...
user avatar
  • 561
0 votes
0 answers
32 views

How to add filter for particular field in Product Ordered Report Grid in magento 2

I have added a new custom column in Reports->Products->Ordered Grid and populated the corresponding data by following this link How to debug Reports > Products > Products Ordered ...
user avatar
  • 2,398
0 votes
0 answers
26 views

Magento 2: Get Layered Navigation filters by store id

We are fetching layered navigation filters as follows: $layer = $layerResolver->get(); $layer->setCurrentCategory(2); $productCollection = $layer->getProductCollection(); $productCollection-&...
user avatar
  • 548
0 votes
0 answers
13 views

Layered navigation results show only products with and-and attributes, now showing or-or attributes, Magento 2

How can I do and-and filter when filtering with layered navigation? For example: When I filter attributes (size = 50, color = red), the result returns a configurable product when some of this child ...
user avatar
  • 728
0 votes
0 answers
35 views

Registered coupon does not display in report filter

I'm having a hard time generating coupon report used in Magento 1.9 accessing Reports -> Sales -> Coupons, I select a date period, order status I keep "any", empty lines = "no&...
user avatar
0 votes
1 answer
35 views

Magento2 Add Custom Sort By Option ( Special Price Low - High)

I Want to Add New Sort By Option Like (Special Price From Low To High). Does any one know how i can do this ?
user avatar
0 votes
1 answer
49 views

Get Latest Entry For Duplicate Rows In Collection

I currently have a logs table which has the following rows which use the same order_id: log_id order_id user action 2410 1001318004 test1 Declined 2409 1001318004 test1 Declined Inside my app/code/...
user avatar
  • 109
0 votes
0 answers
73 views

Add Horizontal & Vertical Layered Navigation

I have a requirement in my project where I need to show both horizontal & vertical layered navigation in product listing page. I have tried to achieve it but facing issue of Illegal state I have ...
user avatar
0 votes
0 answers
32 views

Magento2 add filters for My Orders section in frontend

Magento2 How can I add custom filters on My Orders section Filters By LAST 30 DAYS & LAST 6 Months
user avatar
  • 3,446
0 votes
0 answers
13 views

How to filter Dataprovider results using OR conditions

I am looking for a way to filter orders for a grid based on one of 2 conditions: Order has a status of "processing_consultation" OR Order has an order source ID of 9 So I currently have ...
user avatar
  • 109
0 votes
0 answers
34 views

Admin Grid Filters Expanded on the base of Configuration

I am trying to create the configuration to expanded Magento 2 all grids filters, I overrider these 2 files its work, var config = { map: { '*': { 'Magento_Ui/js/grid/filters/...
user avatar
0 votes
0 answers
30 views

The code looks wrong but works correctly. Is it possible to optimize it and make it more logical?

I have a knockout component that shows or hides my items by tag. I do not work well with js and knockout is new to me, I would like to improve my filtering logic so that it works correctly and locally....
user avatar
  • 138
0 votes
0 answers
58 views

How to filter array and change data on front end KO

I using knockout to create a list with my custom collection data. <div data-bind="scope: 'myData'"> <!-- ko template: getTemplate() --><!-- /ko --> <script type=&...
user avatar
  • 1
1 vote
0 answers
99 views

Filter Grid with Comma Separated Values - Magento2

I'm working on a module where I need to filer store view which is stored as comma-separated values in a custom table. I tried solutions mentioned in Magento 2 -Admin Grid Select filter with comma ...
user avatar
  • 13
0 votes
1 answer
23 views

Custom Sort options for Catalog Dropdown

I created: di.xml on app/code/Filter/Sorting/etc <?xml version="1.0"?> <config xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="...
user avatar
  • 57
0 votes
0 answers
47 views

Magento 2 shop by price is not showing on sub category pages

Magento 2.3.5-p2 shop by price is not showing on the subcategory page, it is showing on category pages
user avatar
  • 1,143
0 votes
1 answer
50 views

Only display products with stock when filter is selected

guys so recently I noticed that when I select a filter, for example, the size M some of the products even though they have the size M some of them are out of stock and I was wondering if it's possible ...
user avatar
  • 137
0 votes
0 answers
10 views

Magento 2 | Enable filters on collection factory programmatically

In my phtml file that I recalled in a cms page I took the entire collection of products, filtered it and finally recalled it. Everything works fine but I can't get the navigation filters like they are ...
user avatar
  • 297
0 votes
0 answers
23 views

Magento 2 | Add Filters of Layered Navigation to custom collection

I asked this question because I would like to explain myself better. In my CMS page I have recalled my custom collection in this way: $blockProductColl = $block->getLayout()->createBlock(...
user avatar
  • 297
0 votes
0 answers
148 views

Add default date from filter to UI Component grid in Magento 2

I have a custom grid created in the backend for a Magento 2.4.1 instance. Everything is working properly (filters, sorting, etc.), but I have one more request that seems to be more complicated. I have ...
user avatar
  • 33
0 votes
1 answer
254 views

How to add Text Input Filter to custom module (hidden column)

I am trying to add a custom filter to a custom module in admin grid, however I do not want that column to be shown therefore I have tried both ways by adding a column and making visible field to false ...
user avatar
  • 107
0 votes
0 answers
14 views

Magento 2: Need to add some additional product in filter result that is not part of the filter

I want to always show some of the product which is not part of selected filter. It means customer selects any filter then it will showing all filterable products but I also want some extra products ...
user avatar
  • 1,002
1 vote
1 answer
360 views

Admin Grid is Showing Wrong filter count Magento 2.4.2

I had updated the magento version 2.3.5 to 2.4.2, in the admin when i tried to search the configurable product alone it shows the wrong product count.
user avatar
  • 298
-1 votes
1 answer
128 views

I want filter for Most Viewed Products in Magento 2 in Category Page

I want to make a custom filter for Most Viewed Product on Category Page in Magento 2. I have used this code app/code/Hlcategory/Filter/Plugin/Catalog/Block/Toolbar.php public function ...
user avatar
  • 526
0 votes
1 answer
92 views

Magento2: I want to apply SKU filter in product layered navigation

I want to add the additional filter on product list page on frontend and product list should be filter by some SKU as well. I am able to filter using SKU but filter is not working properly.
user avatar
0 votes
1 answer
157 views

Magento 2 | Exclude duplicate Item ID from a collection before foreach

When I foreach my collection filtered by tier price, qty and customer group I get the error: "Item (Magento \ Catalog \ Model \ Product \ Interceptor) with the same ID already exists". This ...
user avatar
  • 297
0 votes
1 answer
192 views

Magento 2 | Join table catalog_product_entity_tier_price to collection

I'm trying to filter my product collection by tier price. I currently have this code but it doesn't work and it returns error: protected $_productCollectionFactory; public function ...
user avatar
  • 297
0 votes
1 answer
130 views

Url parameter in magento 2 collection filter

I need to filter Magento 2 custom grid model collection by URL parameter. I have used this below code. protected function _initSelect() { $objectManager = \Magento\Framework\App\...
user avatar
  • 828
0 votes
1 answer
234 views

Frontend Grid Filters not Working in magento 2.4.2

I am getting this after a click on the Apply Filters Button in the frontend grid. Uncaught TypeError: $(...).notification is not a function at UiClass.apply (filters.js:203) at HTMLButtonElement. (...
user avatar

1
2 3 4 5
16