Calling all developers! We invite you to provide your input on Feature Experimentation by completing this brief survey.

 

Mark Stott
Nov 19, 2021
  2597
(4 votes)

Optimizely Search Wildcard Queries and Best Bets

In a recent client build, I have been tasked with updating their search to use wild card searches.  I had read a number of posts pointing to the same solution as detailed by Joel Abrahamsson's 2012 blog post, Wildcard Queries with Episerver Find and Drew Null's post Episerver Find Wildcard Queries and Best Bets. These solutions included building an extension method that built a bool query wrapping a wild card query. This included complications in how to get best bets to work with wildcards.

While the solution did work, after reviewing the performance of the query and the structure of the query being sent to Optimizely Search and Navigation, I discovered that the solution was actually much simpler and did not need any new scaffolding of custom query building.  The For method has overloads which exposes the QueryStringQuery object that allows you to customise the query behaviour.

private ITypeSearch<T> GetQuerySearch<T>(
	string query, 
	bool isWildCardSearch) where T : MyVariant
{
	var specificQuery = isWildCardSearch ? $"*{query}*" : query;
	return _findClient.Search<T>()
                      .For(query, options =>
                      {
                          options.Query = specificQuery;
                          options.AllowLeadingWildcard = isWildCardSearch;
                          options.AnalyzeWildcard = isWildCardSearch;
                          options.RawQuery = query;
                      })
                      .InField(f => f.FieldOne, _settings.FieldOneBoost)
                      .InField(f => f.FieldTwo, _settings.FieldTwoBoost)
                      .InField(f => f.FieldThree, _settings.FieldThreeBoost)
                      .InField(f => f.FieldFour)
                      .InField(f => f.FieldFive)
                      .InField(f => f.FieldSix)
                      .InField(f => f.FieldSeven)
                      .InField(f => f.FieldEight)
                      .UsingSynonyms()
                      .UsingAutoBoost(TimeSpan.FromDays(_settings.AutoBoostTimeSpanDays))
                      .ApplyBestBets()
                      .FilterForVisitor();
}

By passing in the wild card version of the query string into options.Query and setting options.AllowLeadingWildcard and options.AnalyzeWildcard to true was all I needed for wildcard search to be functional.  I also passed in the unaltered query into options.RawQuery but this was not required in order to make Best Bets work.

The main downside to this approach is that synonym functionality no longer worked.  The query with the wildcards would never match a synonym but it would work with best bets.  I resolved this by using a Multi Search query and passed in the unaltered query and then the wild card query.  In Multi Search, each result set is returned in the same order in which it has been defined and they are packaged in a single API call.  It was then a simple case of selecting the first result set with at least one match.

var searchResult _findClient.MultiSearch<DentalVariantProjectionModel>()
                                            .Search<MyVariant, MyProjectionModel>(x => GetQuerySearch(query, false))
                                            .Search<MyVariant, MyProjectionModel>(x => GetQuerySearch(query, true))
                                            .GetResult();

var resultToUse = searchResult.FirstOrDefault(x => x.TotalMatching > 0) ?? searchResult.First();

Performance wise, the difference in sending two queries in a multi search request was negligable compared to a sending a single query.

Nov 19, 2021

Comments

Please login to comment.
Latest blogs
Level Up with Optimizely's Newly Relaunched Certifications!

We're thrilled to announce the relaunch of our Optimizely Certifications—designed to help partners, customers, and developers redefine what it mean...

Satata Satez | Jan 14, 2025

Introducing AI Assistance for DBLocalizationProvider

The LocalizationProvider for Optimizely has long been a powerful tool for enhancing the localization capabilities of Optimizely CMS. Designed to ma...

Luc Gosso (MVP) | Jan 14, 2025 | Syndicated blog

Order tabs with drag and drop - Blazor

I have started to play around a little with Blazor and the best way to learn is to reimplement some old stuff for CMS12. So I took a look at my old...

Per Nergård | Jan 14, 2025

Product Recommendations - Common Pitfalls

With the added freedom and flexibility that the release of the self-service widgets feature for Product Recommendations provides you as...

Dylan Walker | Jan 14, 2025

My blog is now running using Optimizely CMS!

It's official! You are currently reading this post on my shiny new Optimizely CMS website.  In the past weeks, I have been quite busy crunching eve...

David Drouin-Prince | Jan 12, 2025 | Syndicated blog

Developer meetup - Manchester, 23rd January

Yes, it's that time of year again where tradition dictates that people reflect on the year gone by and brace themselves for the year ahead, and wha...

Paul Gruffydd | Jan 9, 2025