SaaS CMS has officially launched! Learn more now.

Search query to find a word thats could be in inside multiple properties

Vote:
 

I have three properties 

  • First name
  • Last name
  • Username

User can search for a word that can be in all three properties. I have had this two queries to achieve the desired result

searchTermFilters = searchTermFilters
    .For(term)
    .InFields(x => x.Firstname, x => x.Surname, x => x.Username);
searchTermFilters = searchTermFilters
                .OrFilter(x => x.Firstname.AnyWordBeginsWith(term))
                .OrFilter(x => x.Surname.AnyWordBeginsWith(term))
                .OrFilter(x => x.Username.AnyWordBeginsWith(term));

The issue is that for both of them it matches exactly. I want something like .Contains in Linq. Any insights?

#194873
Jul 05, 2018 11:12
Vote:
 

Hi Mohsin,

You could try below

   query = query.For(term, q =>
                    {
                        q.Query = $"*{term}*";
                    }).InField(s => s.Name);



#195088
Jul 13, 2018 3:47
Vote:
 

Did you catch this blog post?

https://world.episerver.com/blogs/drew-null/dates/2018/4/find-wildcardquery-and-best-bets---a-workaround/

#195221
Jul 17, 2018 23:08
* You are NOT allowed to include any hyperlinks in the post because your account hasn't associated to your company. User profile should be updated.