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

Question

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?

Did you try `bool string.Contains(string substring)`, or `List.Contains(string s)` ? — Vladi Pavelka, Jul 05 '18 at 09:19
Could you add additional `OrFilter` with `MatchCaseInsensitive` to also find exact matches? — Ted Nyberg, Jul 05 '18 at 09:41

score 1 · Answer 1 · answered Jul 05 '18 at 10:41

1

Use this way with Or condition

searchTermFilters.Filter(x => x.Firstname.Contains(term) | 
                         x => x.Lastname.Contains(term) |
                         x => x.Username.Contains(term))

answered Jul 05 '18 at 10:41

Harshad Pansuriya

20,189
8
67
95

This works unless OP is about finding strings that strictly either _begins_ or _exactly matches_ the string. If it's OK for the string to appear anywhere, this should be the accepted answer. – Ted Nyberg Jul 06 '18 at 08:22

score -1 · Answer 2 · answered Jul 05 '18 at 09:44

-1

For single Filter=>

searchTermFilters = searchTermFilters.Where(w=>w.FirstName.Contains(term)).ToList();

For Multi Filter=>

searchTermFilters = searchTermFilters.Where(w=>w.FirstName.Contains(term) || w.Surname.Contains(term)).ToList();

Hope this help.

answered Jul 05 '18 at 09:44

lwin

3,784
6
25
46

The OP is about the Episerver Find search service, so this answer does not apply. – Ted Nyberg Jul 05 '18 at 09:54

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

2 Answers2