Azuresearch search.in functionallity not working as expected

Question

Trying to figure out why the following filter returns different results.

According to the docs i should be able to use the and or condition with the search in function

search.in(f, ‘a, b, c’) is semantically equivalent to f eq ‘a’ or f eq ‘b’ or f eq ‘c’, except that it executes much faster when the list of values is large.

But the following filters returns different results. But why?

   // Returns nothing
   $count=true&$filter=companyGroupId eq 1595 and search.in(companyName, 'Sky Blue, Green Ice')

But if i do it this way

   // Returns expected results
    $count=true&$filter=companyGroupId eq 1595 and (companyName eq 'Sky Blue' or companyName eq 'Green Ice')

Why are the results so different to me it seems like they should be the same.

My CompanyName Property looks like this

[IsFilterable]
[IsSortable]
[IsFacetable]
public string CompanyName { get; set; }

Bruce Johnston Bruce Johnston · Accepted Answer · 2018-10-25T20:38:05

They are different because of the way search.in parses the second parameter. Since your values have spaces in them, you'll need to specify your own separator as a third parameter to search.in. The default behavior is to break on spaces and commas. Try this instead:

search.in(companyName, 'Sky Blue|Green Ice', '|')

You can find other examples of using search.in here.

Azuresearch search.in functionallity not working as expected

1 Answers