Solr fulltext search - Solution for multi-field query with "AND"-operator

Hi Tino, you can extend DefaultFreeTextQueryBuilder class and replace the OR operator with AND for example . searchQuery.searchInField(field, ClientUtils.escapeQueryChars(value) + suffixOp + boost, SearchQuery.**Operator.AND**);

you get the following Query.

(field1_text_en:pants AND red) OR (field2_en_string_mv:pants AND red) OR (field3_text_en_mv:pants AND red) )

And i think its fulfill your requirement.

Please see:

https://experts.hybris.com/questions/4089/making-use-of-the-extendeddismax-for-solr-searches.html

I think you could make use of the edismax that supports lucene like queries out of the box. The only problem is, that hybris does not support this right out of the box.

We are currently working on introducing this in our project and I was asking if there are already experiences with it.

Oh this is simple. Your customer's requirements are wrong. They will realise this when they come to test it for themselves on their live site.

Hi Tino, Did you get any solution for this issue. I am also facing the same issue.

It is not really a solution, but I think it is the only solution for your case. You should override the method 'convertSolrQuery' in the 'DefaultSolrQueryConverter'. There you can change the query of the SolrQuery.

It is something we did also, because we need always to filter on B2BUnit and that was the best solution. (Also with a different AND/OR notation). I have added an example without the B2BUnit logic:

 public class CustomSolrQueryConverter extends DefaultSolrQueryConverter
 {
     private UserService userService;
 
     @Override
     public SolrQuery convertSolrQuery(final SearchQuery searchQuery) throws FacetSearchException
     {
         final SolrQuery res = super.convertSolrQuery(searchQuery);
 
         final UserModel user = userService.getCurrentUser();
         if (user instanceof B2BCustomerModel)
         {
             //Custom filter logic based on B2BUnit (Logic Removed)
             final String B2BUnitQueryString = "";
             
             final String query = res.getQuery();
             final StringBuilder queryWithFilter = new StringBuilder();
             if (StringUtils.isNotBlank(query))
             {
                 queryWithFilter.append("(").append(query).append(") AND ").append(B2BUnitQueryString);
             }
             else
             {
                 queryWithFilter.append(B2BUnitQueryString);
             }
             res.setQuery(queryWithFilter.toString());
         }
         return res;
     }
     
     /**
      * @param userService
      *           the userService to set
      */
     public void setUserService(final UserService userService)
     {
         this.userService = userService;
     }
 }