Supported methods and operators for xConnect search

xConnect search provider limitations

xConnect search providers do not support the following scenarios:

Limitations of xConnect search providers:

• Scenario: Limitation

• Custom methods inside search expressions: The xConnect Client API does not support custom method calls inside LINQ query expressions. You receive a Sitecore.XConnect.Search.YourLinqIsTooStrongException or an XdbModelException exception.

• Search for null values: It is not possible to check if a facet is null. For example:

  var notWebVisits = client.Interactions.Where(c => c.WebVisit() == null);

• Search by Timespan in custom event properties: The following query (using a custom Timespan property) is unsupported

  can still use the default Duration property on events. This restriction only applies to events, not facets.

  var interactions = await _client.Contacts.Where(c => c.Interactions.Any(i => i.Events.OfType<CampaignEvent>().Any(e => e.CustomCampaignTimespan == TimeSpan.Zero)));

• First, FirstOrDefault, Last, LastOrDefault, or Count inside a LINQ expression: Not supported:

  // First() inside a LINQ expression is unsupported:
  var interactions = await _client.Interactions.Where(i => i.Events.First().EngagementValue == 11).ToList();
  
  // FirstOrDefault() inside a LINQ expression is unsupported:
  var contacts = await _client.Contacts.Where(contact => contact.Interactions.OrderByDescending(x => x.StartDateTime).FirstOrDefault().WebVisit().SiteName == "value");
  
  // Last() inside a LINQ expression is unsupported:
  var contacts = await _client.Contacts.Where(contact => contact.Interactions.Last().WebVisit().SiteName == value);

• Timespan: You cannot use Timespan with a query that combines the OfType operator AND a Timespan property (for example, Hours, Minutes, Seconds, and so on).Supported

  supported:

  events.OfType<SomeEventType>(e => e.SomeTypeTimeSpanField > TimeSpan.FromHours(2))

  events.OfType<SomeEventType>(e => e.SomeTypeTimeSpanField.Hours > 10)

• Repeated names in paths to complex lists: The following queries are unsupported because Path.To.Nested is the same for both lists:

  i.Scores().Scores.Any(s=>s.Path.To.Nested.Any())
  i.ProfileScores().ProfileScores.Any(s=>s.Path.To.Nested.Any())

Azure Search provider limitations

The following limitations are specific to the Azure Search provider for xConnect search:

Limitations of Azure Search providers:

• Scenario: Limitation

• contact.Interactions.Any(): Azure Search provider does not support joins.For more information, see Work with search and Search contacts (includes examples with and without joins).ImportantThis Azure Search limitation affects which segmentation rules you can use. For example, you cannot filter contacts by email events (such as opening an email or clicking a link).

• Partial text search: Not supported by the Azure Search provider. For example:

  client.Contacts.Where(c => c.TextMatch("Mar"))

Azure Search list field limitations

The following table relates to complex type limitations in Azure Search.