Search With BuildFilter

November Happy Hour will be moved to Thursday December 5th.

AI OnAI Off

Home / Forums / Developers (Apps and Integrations) Forum / Search & Navigation /

Search With BuildFilter

Pa Njie

Vote:

Hi,

I am trying to search two fields using the BuildFilter extension method but no results are returned. Here is the code I am using

var placeFilter = client.BuildFilter<Place>();

placeFilter = placeFilter.And(p => p.Name.MatchCaseInsensitive("Name"));
placeFilter = placeFilter.And(p => p.Locality.MatchCaseInsensitive("Locality"));

var place = _findClient.Search<Place>()
    .Filter(placeFilter)
    .GetResult();

Running a search using either one of Name or Locality returns results, when used in an AND query nothing is returned.

Any help would be appreciated.

Thanks

#203245

Apr 12, 2019 16:17

Bob Bolt

Vote:

Hi Pa, Are you using Epi Find? If so, which version?

#203246

Apr 12, 2019 16:42

Pa Njie

Vote:

Hey Bob,

Yes, I am using Episerver Find version 13.03.

#203247

Apr 12, 2019 16:47

Scott Reed

Vote:

"using either one of Name or Locality" would suggest you should do an Or filter. An and will only match if both the values of Name AND Locaility match.

If it is an AND you can achieve that in one simple query using an & or even chaining filters as shown here https://world.episerver.com/documentation/developer-guides/find/NET-Client-API/searching/Filtering/

var place = _findClient.Search<Place>()
.Filter(p => p.Name.MatchCaseInsensitive("Name") & p.Name.MatchCaseInsensitive("Locality"))
.GetResult();

#203281

Edited, Apr 15, 2019 15:29

Pa Njie

Vote:

School boy error! I had a trailing blank space in my search criteria resulting in zero results being returned.

#203352

Apr 17, 2019 12:22

This topic was created over six months ago and has been resolved. If you have a similar question, please create a new topic and refer to this one.