|
Terms & Phrases
|
"test" or "hello dolly"
|
c.Where("test") or c.Where("hello dolly") or c.Where("test" || "hello dolly") |
|
Fields
|
title:"The Right way" and text:"go"
|
c.Title == "The Right way" or c.Text == "go" or c.Equals("go") |
|
WildCard
|
amber
|
c.ContactName.Contains ("amber") |
|
Prefix
|
amber amber
|
c.ContactName.StartsWith("amber") or c.ContactName.EndsWith("amber")
|
|
Fuzzy
|
roam or roam0.8
|
c.ContactName.Like("roam") or c.ContactName.Like("roam", 0.8) |
|
Proximity
|
"jakarta apache"~10
|
c.ContactName.Like("jakarta apache", 10) |
|
Inclusive Range
|
mod_date:[20020101 TO 20030101]
|
c.ModifiedDate.Between("20020101", "20030101", Inclusion.Both) |
|
Exclusive Range
|
title:{Aida TO Carmen}
|
c.Title.Between("Aida", "Carmen", Inclusion.None) |
|
Boosting
|
jakarta^4 apache
|
c.Title.Equals("jakarta".Boost(4)) || c.Title.Equals(“apache”) |
|
Boolean Or
|
"jakarta apache" OR jakarta
|
where c.Title.Equals("jakarta apache") || c.Equals("jakarta") |
|
Boolean And
|
"jakarta apache" AND "Apache Lucene"
|
where c.Equals("jakarta apache") && c.Equals("Apache Lucene") |
|
Boolean Not
|
"jakarta apache" NOT "Apache Lucene"
|
where c.Equals("jakarta apache") && !c.Equals("Apache Lucene") |
|
Grouping
|
(jakarta OR apache) AND website
|
where (c.Title == "jakarta" || c.Title == "apache") && (c.Title == "website") |
|
Restriction Operators
|
Where
|
var results = from d in queryable where d.Name == "Sitecore" select d; or var results = queryable.Where(d => d.Name == "Sitecore"); |
|
Projection Operators
|
Select
|
var results = from d in queryable select d.Name; or var results = queryable.Select(d => d.Name); |
|
Anonymous types
|
results = queryable.Select(d => new { d.Name, d.Id }); |
|
|
Unsupported
|
SelectMany
|
|
|
Partitioning Operators
|
Take
|
results =
queryable.Take(10); |
|
Partitioning Operators
|
Skip
|
results = queryable.Skip(10); |
|
Partitioning Operators
|
Page
|
results = queryable.Page(2, 100); |
|
Ordering Operators
|
OrderBy
|
results = queryable.OrderBy(d => d.Name);
|
|
Ordering Operators
|
OrderBy Descending
|
results = queryable.OrderByDescending(d => d.Name);
|
|
Ordering Operators
|
ThenBy
|
results = queryable.OrderBy(d => d.Name).ThenBy(d => d.Id);
|
|
Ordering Operators
|
ThenBy Descending
|
results = queryable.OrderBy(d => d.Name).ThenByDescending(d => d.Id);
|
|
Unsupported
|
Reverse
|
|
|
Grouping Operators
|
Unsupported
|
GroupBy -Simple 1 GroupBy -Simple 2 GroupBy -Simple 3 GroupBy -Nested GroupBy -Comparer GroupBy -Comparer, Mapped
|
|
Set Operators
|
Unsupported
|
Distinct Union Intersect Except
|
|
Element Operators
|
First -Simple
|
results = queryable.First(); |
|
Element Operators
|
First -Condition
|
results = queryable.First(d => d.Name == "Sitecore"); |
|
Element Operators
|
FirstOrDefault -Simple
|
results = queryable.FirstOrDefault(); |
|
Element Operators
|
FirstOrDefault -Condition
|
results = queryable.FirstOrDefault(d => d.Name == "Sitecore"); |
|
Element Operators
|
ElementAt
|
results = queryable.ElementAt(10); |
|
Element Operators
|
Last
|
'result = queryable.Last();' or
result = queryable.Last(d => d.Id > 10); |
|
Element Operators
|
LastOrDefault
|
result = queryable.LastOrDefault(); or result = queryable.LastOrDefault(d => d.Id > 10); |
|
Element Operators
|
Single
|
result = queryable.Single(); or result = queryable.Single(d => d.Id > 10); |
|
Element Operators
|
SingleOrDefault
|
result = queryable.SingleOrDefault(); or result = queryable.SingleOrDefault(d => d.Id > 10); |
|
Quantifiers
|
Any -Simple
|
results = queryable.Any(); |
|
Quantifiers
|
Any -Grouped
|
results = queryable.Any(d => d.Name == "Sitecore"); |
|
Quantifiers
|
Unsupported
|
All
|
|
Aggregate Operators
|
Count -Simple
|
results = queryable.Count(); |
|
Aggregate Operators
|
Count -Conditional
|
results = queryable.Count(d => d.Id < 10); |
|
Aggregate Operators
|
Unsupported
|
Sum Min Max Average Aggregate
|
|
Join Operators
|
Unsupported
|
Cross Join Group Join Cross Join with Group Join Left Outer Join
|
|
Filtering
|
results = queryable.Filter(d => d.Id > 4 && d.Id < 8); |
|
|
Facets
|
Simple Faceting
|
var results = queryable.FacetOn(d => d.Name); var facets = results.GetFacets(); foreach (var category in facets.Categories) { Console.WriteLine(category .Name); foreach (var facetValue in category.Values) { Console.WriteLine("{0}: {1}", facetValue.Name, facetValue.Aggregate); } } |
|
Pivot Faceting
|
var results = queryable.FacetPivotOn(p => p.FacetOn(d => d.Name).FacetOn(d => d.Year)); var facets = results.GetFacets(); foreach (var category in facets.Categories) { Console.WriteLine(category .Name); foreach (var facetValue in category.Values) { Console.WriteLine("{0}: {1}", facetValue.Name, facetValue.Aggregate); } } |
|
|
Boosting
|
results = queryable.Where(d => d.Id == 7.Boost(2f)).Where(d => d.Template.Contains("o")); |
|
|
Other
|
Between
|
results = queryable.Where(item => item.Price.Between(50.0f, 400.0f, Inclusion.Both)); or results = queryable.Where(item => item.Price.Between(2.0f, 12.0f, Inclusion.Both) || item.Price.Between(80.0f, 400.0f, Inclusion.Both)); or results = queryable.Where(d => d.Date.Between(new DateTime(2004, 12, 31), DateTime.Now, Inclusion.Both)); or results = queryable.Where(d => d.Id.Between(1, 4, Inclusion.Both)); or results = queryable.Where(d => d.Id.Between(1, 4, Inclusion.Lower)); or results = queryable.Where(d => d.Id.Between(1, 4, Inclusion.Upper)); or results = queryable.Where(d => d.Id.Between(1, 4, Inclusion.None)); |
|
Other
|
string.Contains
|
results = queryable.Where(d => !d.Template.Contains("Hello:)); |
|
Other
|
string.CompareTo
|
results = queryable.Where(d => !d.Name.CompareTo("Hello") == 1); |
|
Other
|
Equal
|
results = queryable.Where(d => d.Id.Equal(4)); |
|
Other
|
Matches
|
results = queryable.Where(i => i.Template.Matches("^.*$")); |
|
Other
|
MatchWildcard
|
results = queryable.Where(i => i.Template.Where(i => i.Template.MatchWildcard("H?li*m"))); |
|
Other
|
Like
|
results = queryable.Where(i => i.Template.Like("Citecoar")); |
|
Other
|
string.StartsWith
|
results = queryable.Where(d => !d.Name.StartsWith("Hello")); |
|
Other
|
string.EndsWith
|
results = queryable.Where(d => !d.Name.EndsWith("Hello")); |
|
GetResults
|
results = queryable.GetResults().Hits.Where(i => i.Document.Name.Contains("o")).Where(hit => hit.Score > 0.6); |
|
|
GetFacets
|
results = queryable.Where(d => d.Id > 0).FacetOn(d => d.Template, 0).GetFacets(); |
|
This returns the results of a query on your search index and returns it as a SearchResultItem type.
|
using (var context = ContentSearchManager.GetIndex(item).CreateSearchContext()) { IQueryable<SearchResultItem> searchQuery = context.GetQueryable<SearchResultItem>().Where(item => item.Name == “Sitecore”) } |
|
This converts the query to something your provider understands. For example, for Lucene it is converted to: _name:sitecore
|
using (var context = ContentSearchManager.GetIndex(item).CreateSearchContext()) { IQueryable<SearchResultItem> searchQuery = context.GetQueryable<SearchResultItem>().Where(item => item[“_name”] == “Sitecore”) } |
|
+(+_name:sitecore) +(title:test body:cms) or (+(+_name:sitecore) +(title:test body:cms))
|
using (var context = ContentSearchManager.GetIndex(item).CreateSearchContext()) { IQueryable<SearchResultItem> searchQuery = context.GetQueryable<SearchResultItem>().Where(item => item[“_name”] == “Sitecore”).Where(item => item.Title == “Test || item.Body.Contains(“CMS”)) } OR using (var context = ContentSearchManager.GetIndex (item).CreateSearchContext()) { IQueryable<SearchResultItem> searchQuery = context.GetQueryable<SearchResultItem> ().Where(item => item.Name == “Sitecore”).Where(item => item.Title == “Test || item.Body.Contains(“CMS”) |
|
Find all the items that have “s” in their names
|
var index = ContentSearchManager.GetIndex("sitecore_master_index"); using (var context = index.CreateSearchContext()) { Console.WriteLine( context.GetQueryable<SearchResultItem>().Where(resultItem=>resultItem.Name.Contains("s")) ); |
|
Finding the first item named Sitecore
|
context.GetQueryable<SearchResultItem>().FirstOrDefault(resultItem=>resultItem.Name=="sitecore") |
|
Finding the count of items in a database
|
context.GetQueryable<SearchResultItem>().Count() |
|
Finding all the items that use a certain template
|
context.GetQueryable<SearchResultItem>().Where(resultItem=>resultItem.TemplateName=="Sample Item")
|
|
same thing as above but this time using the template id
|
context.GetQueryable<SearchResultItem>().Where(resultItem=>resultItem.TemplateId==ID.Parse("{76036F5E-CBCE-46D1 -AF0A-4143F9B557AA}")) |
|
find all items that have some content in the "Page Title" field
|
context.GetQueryable<SearchResultItem>().Where(resultItem=>resultItem["page_title"]!="" |
|
find all items that have lorem in the body
|
context.GetQueryable<SearchResultItem>().Where(resultItem=>resultItem["body"].Contains("lorem")) |
|
finding an item where item.Fields["Taxonomy Items"] // is a multi list field and contains "{016424DF-865C-49DC- 9D7A-40EB8101C717}"
|
context.GetQueryable<SearchResultItem>() .Where(resultItem=>resultItem["taxonomy_items"].Contains(Sitecore.ContentSearch.Utilities.IdHelper.NormalizeGuid ("{016424DF-865C-49DC-9D7A-40EB8101C717}",true))) |
|
Find items based on Data Source string
|
var query = LinqHelper.CreateQuery(context, UIFilterHelpers.ParseDatasourceString(txtQuery.Text.Trim())).Select(x => x.GetItem()) .AsEnumerable() .Where(x => x.Language == Sitecore.Context.Language) |
|
Get Particular template's item for current website and latest version of an item only
|
var searchResultItem = context.GetQueryable<SearchResultItem>() .Where(x => x.Path.Contains(sitecoreItem.Paths.FullPath)) .Where(x => x.TemplateId == Sitecore.Data.ID.Parse("YOURTEMPLATEID")) .AsEnumerable() .Where(x => x != null && x.GetItem() != null && x.Version == x.GetItem().Versions. GetLatestVersion().Version.ToString()); |
|
To get all details related to search index like IsClean, LastUpdated, NumberOfDocuments,NumberOfFields
|
ISearchIndex isearchIndex = ContentSearchManager.GetIndex("YOURINDEXNAME"); |
|
The _content field aggregates all fields from the item to allow full text searching
|
[IndexField(Sitecore.ContentSearch.BuiltinFields.Content)] public string ItemContent { get; set; } |
|
To do your index field configuration
|
<fieldMap type="Sitecore.ContentSearch.FieldMap, Sitecore.ContentSearch"> <fieldNames hint="raw:AddFieldByFieldName"> |
No comments yet.
Cheatography n. The art of mapping complex subjects into clear, instantly navigable reference guides.
