SaaS CMS has officially launched! Learn more now.

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


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
    .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?

Jul 05, 2018 11:12

Hi Mohsin,

You could try below

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

Jul 13, 2018 3:47

Did you catch this blog post?

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.