Questions tagged [filter]

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

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

How to apply null value filter for magento admin grid

I have added an additional column to sales grid in admin by adding the following to sales_order_grid.xml <column name="email_sent" > <argument name="data" xsi:...
0
votes
0answers
16 views

How to apply Filters on custom Product Collection. Magento 2

I've created a custom phtml file where I'm showing specific Products.. Now I want to apply filters on that so for that in my Layout I've applied <?xml version="1.0" encoding="UTF-8&...
0
votes
0answers
17 views

Magento 2: Layered navigation $filter->getItemsCount() very slow

We are using layered navigation and are loading a filter block in sidebar. But $filter->getItemsCount() takes a long time to load. <?php foreach ($block->getFilters() as $filter): ?> ...
0
votes
0answers
13 views

dateRange filter can not properly parse format

I have a datetime column for custom made listing, where date filter calendar can not process given date format. <column name="ticket_time" sortOrder="150" class="Magento\Ui\...
0
votes
0answers
5 views

Sales Order Grid Set Predefined filter of 30 days

I need to set predefined filter on Purchase Date on 30 days from current date and load the orders for that filter only. Any time should be able to load all orders if we remove the filter I tried ...
0
votes
0answers
5 views

Filter on order comment history in order grid magento 1

I have added an column to the magento 1 order grid. it renders the order history of the order. I have made a renderer with the following code: class Mage_Adminhtml_Block_Sales_Order_Renderer_Red ...
3
votes
1answer
17 views

How to reset the products grid filter don't loading in the admin panel?

My backend keeps freezing and can't do anything with it. I think it is due to the filter that was put last week on the products page to show 1000 products in the grid. I tried to open it in an ...
0
votes
0answers
27 views

Filters are missed in Admin Panel

For some reason filters in Admin Panel are missed. I tried to debug it but it is without any result. Can someone say where this collection is prepared or maybe why is it happens?
0
votes
0answers
6 views

How to make price filter by default collapsible false?

How to make this price filter close by default in Magento 2. When i starting loading the page it shoes price filter open by default. How to make it close by default. Any help is appreciated.
0
votes
0answers
15 views

Allowed memory size exhausted, trying to select specific pages from widget

I am completely new in Magento and trying to create a widget that will simply display the selected pages on the frontend. That's what I have for now in my block class: public function getPages() { ...
0
votes
0answers
30 views

How to change HTML of Categoty Page in Magento 2?

how can i change the layout of Category page in Magento 2 Like to change some HTML in category page. i want to show product in full width and want to show price filter just above of product listing ...
0
votes
1answer
20 views

Magento 2.3 filter product enable but showing disable also

Filter with simple product and status enable but showing disable also please look at the screenshot.
0
votes
0answers
33 views

Magento 2 Error filtering template: Warning: filesize ()

Error filtering template: Warning: filesize(): stat failed for http://localhost/jaipurbkp/pub/media/catalog/product/s/c/screen_shot_2020-10-03_at_2.37.35_pm.png in C:\wamp64\www\jdrbkp\vendor\magento\...
0
votes
0answers
11 views

How to do apply filter of custom field value in Sales Order in Admin Magento 2?

I have created some fields and save data in quote and sales_order table on my order success. I have successfully display the data in Admin Sales Order but it doesn't apply filter on it as it will ...
0
votes
2answers
34 views

Filter is not working on Custom Values in Magento 2 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. I have found out a ...
0
votes
1answer
13 views

How can add filters in custom grid magento 2 without UI component

I have created a custom grid for reports in the admin without UI component. Now I want to add filters in the grid. Filters type Date-Range, Price-Range, Status. <?php protected function ...
0
votes
0answers
14 views

Orders grid not loading magento 2 (Something went wrong with processing the default view…)

Info: Magento 2.3.5 PHP 7.2 database: mariadb-10.2 Hi guys! Had someone already faced this issue on Magento order sales grid? "Something went wrong with processing the default view and we have ...
0
votes
0answers
11 views

How to add a custom attribute filter in Product listing, search result and also update layered navigation in Magento 2.4?

I have a custom attribute materials_used, I need to filter it's automatically (hardcode) in PLP & search with layered navigation. materials_used attribute is also hidden by customers. Hint: ...
0
votes
0answers
29 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
16 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
18 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
63 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
25 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
15 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
8 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
30 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
18 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
9 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
22 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
19 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
22 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
38 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
12 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
23 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
25 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
21 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
61 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
14 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 ...
2
votes
1answer
114 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
28 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
26 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
11 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
14 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
19 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
38 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 ...

1
2 3 4 5
15