Querying examples

Introduction

In addition to providing great, near-real-time search, EPiServer Find can also be used to solve other types of querying needs for which we traditionally had to use the FindPagesWithCriteria method for. Below is a number of examples illustrating common querying scenarios specific to EPiServer 7/7.5 CMS. For more examples and documentation related to filtering, refer to the Searching/Filtering section under .NET API in this documentation.

Filtering by category

int categoryId = 3; //Category to match

var pages = SearchClient.Instance.Search<PageData>()
  .Filter(x => x.Category.Match(categoryId))
  .GetContentResult();

Filtering by Author/ChangedBy

var pages = SearchClient.Instance.Search<PageData>()
  .Filter(x => x.ChangedBy.Match("Zlatan"))
  .GetContentResult();

Filtering by publish date

The below example finds pages published in October 2011.

var pages = SearchClient.Instance.Search<PageData>()
  .Filter(x => x.StartPublish.MatchMonth(2011, 10))
  .GetContentResult();

var pages = SearchClient.Instance.Search<PageData>()
  .Filter(x => x.StartPublish.Before(new DateTime(2011, 10, 1)))
  .GetContentResult();

Filtering by page type

When using typed content, the easiest way to filter by content type is to simply specify the desired type in the type parameter to the Client Search method. However, in that case pages of page types inheriting from the specified type will also be matched. In other situations we may not know what type to filter by until at runtime. In both such cases we can filter by the IContent.ContentTypeID.

int contentTypeId = 42;

var pages = SearchClient.Instance.Search<IContent>()
  .Filter(x => x.ContentTypeID.Match(contentTypeId))
  .GetContentResult();

Filtering by Site ID

In an enterprise scenario with multiple sites all sites utilize the same index. To handle this the return value of an extension method for IContent, named SiteId, is indexed. This can be used to filter for content on a specific site.

var content = SearchClient.Instance.Search<IContent>()
  .Filter(x => x.SiteId().Match("MySiteId"))
  .GetContentResult();