Querying examples CMS 6 R2

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 CMS 6 R2. 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))
  .GetPagesResult();

Filtering by Author/ChangedBy

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

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))
  .GetPagesResult();

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

Filtering by page type

When using Page Type Builder, the easiest way to filter by page 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 PageData.PageTypeID.

int pageTypeId = 42;

var pages = SearchClient.Instance.Search<PageData>()
  .Filter(x => x.PageTypeID.Match(pageTypeId))
  .GetPagesResult();

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 PageData, named SiteId, is indexed. This can be used to filter for pages on a specific site.

var pages = SearchClient.Instance.Search<PageData>()
  .Filter(x => x.SiteId().Match("MySiteId"))
  .GetPagesResult();