Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [search-criteria]

The tag has no usage guidance.

-1
votes
0answers
15 views

search criteria returns empty result

I'm using search criteria api to filter products, but it doesn't work for all attributes. It returns empty result for some attribute even there are products for that attributes
1
vote
0answers
28 views

Magento 2 - Query Builder

I need to create a query with searchCriteriaBuilder with this condition: WHERE visibility = [value] AND status = [value] AND ((category_id = [value] AND designer = [value]) OR (category_id = [value]))...
0
votes
0answers
15 views

Which are recommended to use while building search criteria for repositories?

Which class is recommended to use while preparing search criteria for any repository? Magento\Framework\Api\Filter or Magento\Framework\Api\FilterBuilder What are the differences between both of ...
3
votes
2answers
79 views

Search criteria builder does not filter an “out_of_stock” products

I am using Magento 2.3, Am filtering the product collection using the search criteria builder with a custom attribute as the filter. $filter1 = $this->_filterBuilder->setField('...
0
votes
1answer
26 views

Search type in Catalog don't search by Product's Name

I'm changed catalog search configuration to : System > Configuration > Catalog Search Type => Combine (Like and Fulltext) Product Listing Sort by => Name But when I search by name, the product ...
0
votes
0answers
26 views

magento 2.2 product repository interface returns no collection

I'm trying to get a product collection via ProductRepositoryInterface. The code I'm using is this: $searchCriteria = $this->_searchCriteriaBuilder->create(); $searchResults = $this->...
1
vote
1answer
117 views

CatalogSearch results looking for partial SKU

I need to be able to search by partial string of a SKU, for example, if a SKU of a product is "CUS123.5NYS" the customer may also be able to search by "123.5N", but currently, it only works if I ...
1
vote
1answer
379 views

How can we return an array of search results in APIs Magento 2

I need to return array of search results and so far I did this. DashBoardInterface.php <?php /** * Copyright © Magento, Inc. All rights reserved. * See COPYING.txt for license details. */ ...
4
votes
2answers
202 views

Filtered response does not show total records in response of REST APIs in Magento 2

I am using GET V1/products endpoint to fetch product list. I want to fetch sku and name only. http://localhost/magento/rest/default/V1/products?searchCriteria[sortOrders][0][direction]=ASC&...
0
votes
0answers
29 views

Repository collection join processor doesn't work when called twice

I have a repository that has to join a table for certain filters when using getList. I noticed that Magento does this using a JoinProcessor. Everything works fine except when calling getList a second ...
1
vote
0answers
11 views

Sphinx Search - How to Hide Archive Products

How I can Hide Archive Products appearing in Search results We are using Sphinx Search, Do anyone know how not to show some products pages showing in search results. Thanks.
0
votes
0answers
140 views

How to filter Multiselect in Magento 2 search Rest API?

I am using magento search rest api. Now i can filter attributes like neck, sleeve, etc.., but i need to give multiple values for same attribute (like mulitple select) My Request: rest/V1/search?...
0
votes
0answers
147 views

How to apply Search criteria filter on extension attribute

Is it possible to apply search criteria filter based on extension attributes? As /rest/V1/products?searchCriteria[pageSize]=10&searchCriteria[currentPage]=1&searchCriteria[filterGroups][1][...
1
vote
1answer
207 views

Use search_criteria to filter custom extension collection in Magento 2

I generated a custom extension with a custom model collection from mage2gen , is it possible to implement the search_criteria like when you retrieve product using rest api? what i know is the product ...
0
votes
0answers
19 views

Add a search criteria with radio buttons or dropdowns in home page by CMS

I am a fresher to Magento and php. I am customizing Magento 2.2.4 for an online bookstore. What I want to do is adding a search criteria commonly with radio buttons and/or dropdowns as follows even in ...
1
vote
1answer
374 views

Set Join in SearchCriteria select

I need to override the get orders list API call, and set a join with my custom table, but without loose the SearchCriteria terms, is this possible? Current Code: (I've created a plugin in Magento\...
1
vote
0answers
24 views

What is the proper way to perform a SEARCH with logic AND using the APIs?

I'm having trouble performing a search using the APIs. Below is the request I'm performing to my Magento backend: http://www.mybackend.com/rest/it/V1/products?searchCriteria[filterGroups][0][filters][...
2
votes
1answer
764 views

Customer Repository Interface, Limit Results

I'm trying to grab the oldest customer, using the customer repository from the database. Here's my code so far: // if custom is active $isActivefilter = $this->filter ->...
1
vote
0answers
107 views

order api search criteria

I have two magento accounts and i am fetching order with below route : ("/rest/V1/customers/search?searchCriteria[page_size]=20000&searchCriteria[current_page]=1&searchCriteria[...
2
votes
0answers
213 views

Magento 2 rest api: Ignore out of stock products in get products search criteria

I am using the following api call to get products. {{base_url}}/rest/V1/products?searchCriteria[filter_groups][0][filters][0][condition_type]=like&searchCriteria[filter_groups][0][filters][0][...
2
votes
0answers
828 views

Magento 2 filter products by price from Rest API

Magento-2 we would like to filter the products from REST API I have filtered product by price in the frontend please check the result in the below screenshot (24-MB02 price and special price we ...
3
votes
1answer
5k views

Magento2: How to add multiple AND and OR conditions to filter/filterGroups?

The question is too close to this topic: Magento 2: Product Repositories, Filter Groups, and `AND` but is it possible to create criteria with multiple OR and AND? In my case i would like to create ...
1
vote
1answer
581 views

filtering orderList with multiple filter searchCriteria in 'AND' logic

I am trying to filter the order list based on two filters. So far, all of my attempts failed and didn't work. The filter is not working properly and it returns very first order in list of orders in ...
1
vote
1answer
145 views

SearchCriteria Logical OR and AND search

I am trying to get a search criteria to become the following SQL: WHERE (a = 1 AND b = 2) OR (c = 3) Magento2 Documentation only has the example where AND and OR are reversed. Is this even possible? ...
2
votes
2answers
858 views

Magento 2 Search Rest API

I need to change the response of Search Rest API in Magento 2. Request:rest/V1/search?searchCriteria[requestName]=quick_search_container &searchCriteria[filterGroups][0][filters][0][field]=...
14
votes
1answer
7k views

What are the allowed condition types in Magento 2?

What is the list of allowed condition types while adding filter to search criteria in Magento 2? All of the examples about search criteria in the internet use eq condition type. Is there any other? ...
0
votes
2answers
233 views

Magento2: SearchCriteria OR/AND

use \Magento\CatalogSearch\Helper\Data as CatalogSearch; use \Magento\Catalog\Model\Layer\Category\FilterableAttributeList; use \Magento\Catalog\Api\ProductRepositoryInterface; use \...
1
vote
1answer
340 views

Magento2: setFilterGroups(array) SearchCriteria Error

I have the following code: $filter1 = $this->_filterBuilder->setField('name') ->setValue('%'.$searchTerm.'%') ->setConditionType("like") ->create(); $filter2 = $this->...
1
vote
1answer
2k views

Magento2: Collection to SearchCriteria

How to convert $products = $this->_catalogSearchAdvanced ->getProductCollection() ->addStoreFilter($storeId) ->setCurPage($page) ->setPageSize($...
0
votes
1answer
865 views

Search Criteria for the products in magento 2

I have gone through the Search Criteria functionality to filter the products, for this I have created the custom attributesmart_search multiselect attribute. And I have written some code for filter ...
1
vote
1answer
207 views

Retrieve extension_attributes with API searchCriteria working wrong

I created a new field on Creditmemos as an extension_attribute. I thought is working fine, when I create a Creditmemo, the field is saved correctly in the ddbb and when I get the creditmemo with the ...
1
vote
1answer
740 views

Magento2 Rest Api Search Criteria not working properly!

I am trying to get the sales orders from magento2 REST API. I am using the below query to get the complete orders within entity_id range: $ch = curl_init( Helper::getURL() . "orders?searchCriteria[...
0
votes
0answers
228 views

How to filter a product by a datetime attribute in Magento2?

I am trying to filter products on a search by an attribute of type 'datetime'. The problem is it does not filter by it, so it shows all the results. I have tested other attributes and it works fine, ...
0
votes
2answers
487 views

Cannot search correct result

I have a product named C.I.D However, I am not able to search it in Magento 2.0 I guess it's related to the dot character. Anyone got idea on how to fix it? Thanks
0
votes
1answer
392 views

How can I accomodate category names also to the magento quick search?

I am new to magento2, I wanted to know how we can bring category names also to the quick search. For eg: When I search using a keyword 'Bag', I should get a list off all products under the category "...
8
votes
4answers
1k views

Magento 2 API: Filter orders by extension attribute

I have an extension with an attribute assigned to order items called warehouse. I can see this attribute under the property "extension_attributes". I need to filter orders based on this attribute. I ...
0
votes
1answer
470 views

Assign Multiple Filter to Single FilterGroup in magento 2

I am working on to get product from custom attributes using search criteria. i need to assign multiple filter to single filter group. what i did: $cus Query: {"area":["320","321","322"],"city":"...
1
vote
0answers
1k views

Custom Attribute Search using SearchCriteria

I have created some custom attribute like city and I need to search how many products I have in a specific city using SearchCriteria. The SearchCriteria I apply does not filter products on my city ...
2
votes
1answer
810 views

SearchCriteria with 'OR' filter

I would like to get Cms Pages from repository using search criteria. I need to filter title and content fields. This is how I'm trying to do this: $this->filterBuilder->setField('title'); $this-...
5
votes
1answer
883 views

Magento 2: How to change Advanced Search from “AND” to “OR”?

I'm stuck with this situation: I have 2 select-type attributes: A and B for example In both of the attributes, I have the same list of Options (but they are different option ids) For example In ...
1
vote
1answer
444 views

Magento 2 cannot set searchCriteria to rest api for categories

Tried using the url below to get all sub-categories, but it retuns all categories without filtering. http://127.0.0.1/magento/index.php/rest/V1/categories/?searchCriteria[filter_groups][0][filters][0]...
0
votes
0answers
114 views

Magento Filter search on search page

Is there any way around that I can filter search result using via search. Example : Suppose I am on home page and there I searched "blue" in the search box. Now I am on the search result page ({{...
3
votes
0answers
374 views

Magento 2 - Changing Default Search Query Behavior

I have the following search criteria: /?free_from%5B%5D=265&free_from%5B%5D=266 I'm trying to query all products and return ONLY products with both options A and B selected for the custom ...
4
votes
1answer
410 views

Magento 2: difference between Api\SearchCriteriaBuilder and Api\Search\SearchCriteriaBuilder?

Those two classes are very similar but I don't get the differences and why should one be used instead of another ? Magento\Framework\Api\Search\SearchCriteriaBuilder => a handful of references in the ...
5
votes
1answer
2k views

Using searchCriteria with condition_type operators “from” and “to” in Magento 2.0

I'm trying to use the Get Orders API with searchCriteria to filter Orders with base_subtotal range between two values. But I have only been able to use the lt and gt. I'm unable to use both in the ...
4
votes
1answer
3k views

how to use Search rest api in magento 2?

How to get items using search rest apis,example: I want to search watch in mogento2,how can i get the data from rest apis. Tried like this : http://localhost/magento2/index.php/rest/V1/search?...
6
votes
2answers
2k views

Use preconfigured builders (e.g. for SearchCriteria) in Magento 2

Warning, this is a long winded question about module architecture. I'm not mad if it gets closed as opinion based, but I hope someone has a better idea than me. In Magento 2 we have builders like the ...
2
votes
1answer
343 views

Magento search rest api

In the application we are implementing a search function using rest api. The search will happen using multiple filters. By default, magento is using "and" operator between filters for producing search ...
0
votes
2answers
76 views

Search not returning desired results

I'm having problems with the search in my magento webshop. I have different products in my webshop. An example of the name of a product is like this: BODYSOL KIDS DOUCHE 2IN1 WATERMELOEN 250ML ...
7
votes
2answers
6k views

Using searchCriteria while searching attributes in magento 2.0

Fetching attribute info, if I apply multiple filters in a single search criteria, it does not work. But in case of single filter it works perfectly. Multiple filters HTTP request: http://192.168.1....