Questions tagged [filter]

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

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

Magento 2 :: Error with customer field of M2E/Amazon

if you go into the product listing in in third party module M2E/Amazon and add a custom filter to search for products with specific values the result is the following error message: 1 exception(s): ...
0
votes
0answers
21 views

Magento 2 Filter admin grid with custom columns

I have a custom table that is assigned to multiple store so i do have another table for their relationship. my problem now is i want to filter my custom table by store in the admin grid. i was able to ...
0
votes
0answers
3 views

Loading Product collection based on custom attribute filter in magento 2.3.3

Please help me in achieving my below requirement. I have one category called as Tires. When user goes to that category page. It displayes 3 dropdown on the top of the product listing page https://prnt....
0
votes
1answer
145 views

Apply Filter not working on Magento 2 for custom column Sales Order

I have save my custom data in quote and sales_order table and show data in Admin grid but filter is not working in this as it is search in sales_order_grid table in Magento 2. my view/adminhtml/...
1
vote
1answer
115 views

Create filterable admin grid from external database table

As the title says - I am trying to create an admin grid from an external database-table. I was able to create one with an ui_component and some dirty tricks in my data provider - but the problem is, ...
0
votes
0answers
65 views

How to change Filter Url in Magento 2

How to change the URL of the Magento 2 store when Filter is applied. When I apply any Filter the URL looks like https://jpm2.mydemoweblink.com/watches/alpina?jpf_gender=6780 where I want to change the ...
0
votes
1answer
34 views

Add filter to custom grid created as ui_component

I rephrased my question and got it working (adding filters to a custom grid, that was made with a custom data provider). See question and answer here: Create filterable admin grid from external ...
2
votes
0answers
36 views

Add entity_id column and filter in sales order grid magento 2

I want to add entity_id column and filter for its search in sales_order_grid in magento 2.3 admin. Any one have any idea?
0
votes
0answers
11 views

How to Add New Custom Filter on Customer Group

I am facing issue on adding new filter in customer group from Backend at Magento 2.3 Could you pleas help me on adding new filter to load in customer group page from backend, Thanks
0
votes
1answer
65 views

How to Filter collection based on multiple store view ids?

My custom model collection has a database table that contains store_ids value separated by comma like this: ID | store_ids | +++++++++++++++++ 1 | 0,1,3 | 2 | 1 | 3 | 0,1 | 4 ...
0
votes
1answer
22 views

Filter a collection with a custom attribute

I'm trying to add a custom attribute to the customer_entity table and then sort the collection with that custom attribute. So far I've tried using etc/db_schema.xml to add a column to the table, and ...
0
votes
2answers
12 views

Filters on the dashboard don't work with the Spanish dashboard

When I put the panel in Spanish the filters stop working: Why can this be? And how can I fix it? Thank you so much!!
0
votes
2answers
38 views

Change product sorting from desc to asc on category page

When entering a category, I select the sorting type product name. Sorting shows products in desc mode (z-a) how to implement default asc mode (a-z)
0
votes
0answers
63 views

Magento 2 - REST API filter customer data by address fields

I want to filter customers in a country,state,city or street in REST API. How can I do it? I am using the /V1/customers/search API Call. Now I can only filter by the customers default billing address ...
1
vote
0answers
26 views

Secondary color not updated in filter

I've set up two color attributes 1 for creating configurable products with the provided colors form the manufacturers, these colors come with a lot of variations. The 2nd attribute is with main colors ...
0
votes
0answers
211 views

INSERT INTO “search_tmp…” very slow with custom attributes

l've a problem with filter. I've 3 custom filter ( pietre , materiali , inspiration ); When select Category , Pietre and Materiali , query that populates search_tmp finish at least in 1 minute. Query ...
0
votes
0answers
25 views

How to Filter grid on load added by insertlist tag in an admin form using url parameter magento 2.x

How can I filter the grid listing on page loading, which is added in the admin form using insertlist tag using an URL parameter? form.xml <insertListing name="slide_grid"> <...
1
vote
1answer
24 views

I need to set the 'OR' condtion for last where clause but it is setting as AND how can change in magento 2.3

SQL need to change AND condtion to OR in below code public function getOrders() { $po_number = "%"."A"."%"; if (!($customerId = $this->...
0
votes
1answer
31 views

I need to create a search bar on sales order view page in customer login magento 2.3

I need to search and filter the orders in sales order page customer side as like admin side also need the search box. But i can't find any related documentations or solutions. whether this can do in ...
0
votes
0answers
55 views

Magento 2: How to get the Filters values from a grid

Before loading the grid, I want to get the filters so I can load the collection depending on the value of these filters. The thing is that I don't want the column From in my grid but I want it marked ...
2
votes
1answer
167 views

How to print raw sql query by applying filter on searchCriteriaBuilder in Magento 2

How to print raw SQL query by applying filters on searchCriteriaBuilder ? I am using the following method, but it's giving error: "Uncaught Error: Call to undefined method Magento\Framework\Api\...
1
vote
0answers
17 views

Placeholders and Boolean Logic in Data-Table Filters

I can filter a data-table in the backend by a custom search term for textual columns, see devdocs. Can I somehow use placeholders or logical operations (like not or xor) therein? I have tried * as a ...
3
votes
1answer
305 views

Filter Magento2 Fulltext\Collection by OR condition

How can i filter the Magento2 Fulltext\Collection (Magento\CatalogSearch\Model\ResourceModel\Fulltext\Collection) by an OR condition between 2 product attributes, with respecting also the ...
1
vote
0answers
24 views

Missing field in filter tab of grid

i have some problem with grid in backend. [1]: https://i.stack.imgur.com/Oocnu.png I dont see any field of filter @@ any idea to fix or debug! tks very much
2
votes
0answers
40 views

Filter category products by quantity - Magento 2.3

My store allows backorders, so some of the products have quantity of 0. I want to create a switch on the category page on front-end for "hide out of stock products" which filters out ...
0
votes
1answer
32 views

Can i add product in category page product collection?

Can I add a product in category page product collection? I want to add product #123 in category page product collection but the same product already exists in the collection so it is possible? My ...
1
vote
0answers
11 views

How to Make Grid Component Select Filter Convert to the Like Comparison Operator in SQL

when a filter dataType is configured as select. It will be converted to filterName=selectedValue in the final SQL. When dateType is text, it will be converted tofilterName like '%inputValue%'. My ...
1
vote
0answers
12 views

Find filter definition

I am looking to the file Magento\LayeredNavigation\Block\Navigation\FilterRenderer (a preference actually but that's not the point). This class defines public function render(FilterInterface $filter) ...
0
votes
0answers
8 views

select element or add filter after massaction

I need your help because I really can't move forward with my problem. I would like to select or filter the elements that have been manipulated during my massaction in sales_order_grid. So I would like ...
0
votes
0answers
22 views

Admin Panel Grid - filter without column

Does it possible to create filter on grid without related column in grid? Now I'm using code like this: <column name="name" sortOrder="30"> <settings> ...
0
votes
0answers
20 views

Wrong attributes displaying in layered navigation

Don't know if anyone can help. Using Magento 2.3.2 We sell plants on our site, and I have set up different attribute groups for different types of plants - shrubs, veg, flowers, fruit, and herbs. Some ...
0
votes
0answers
111 views

I am getting incorrect count of products for layered navigation in magento 2.3

In layered navigation filter i am getting incorrect product count, i can't get the solution for this problem. Example : The products under Shorts category in 49 but in the filter for me showing as ...
0
votes
1answer
153 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
24 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
1answer
40 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
21 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
97 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
21 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
73 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
6 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
17 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 ...
1
vote
0answers
160 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 ...
1
vote
1answer
114 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
17 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
44 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
18 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
29 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
1answer
269 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
2answers
91 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
32 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
2
3 4 5
15