Aniel Sud
Optimizely
Aug 2, 2017
visibility 9807
star star star star star star
(3 votes)

Support for IQueryable data sources

One of the cooler features released with Ektron 9.20 was support for IQueryable data sources. This feature allows a developer to write native Linq queries against almost any native data type in the system, while still supporting all the baked-in permissioning and business logic for those items. And it’s super easy to use!

In version 8.5, Ektron introduced the Framework API, which features simple, criteria-based retrieval. For example, to retrieve all the content viewable to the currently loggedin user that exists in either folder ID 32 or 34, write a query like the following:

using Ektron.Cms.Framework.Content;
using Ektron.Cms.Content;
using Ektron.Cms.Common;
...
var contentManager = new ContentManager();
var contentCriteria = new ContentCriteria();

contentCriteria.AddFilter(ContentProperty.FolderId, CriteriaFilterOperator.EqualTo, 32);
contentCriteria.AddFilter(ContentProperty.FolderId, CriteriaFilterOperator.EqualTo, 34);
contentCriteria.Condition = LogicalOperation.Or;

var contentItems = contentManager.GetList(contentCriteria);

This works, and is easy enough to understand, but is verbose. And if you have more complex queries, with nested logic, it gets even worse. For example, here is a query searching for items in folder ID 32 with a last editor name beginning with “Ben”, in addition to all items in folder ID 34. The resulting list ordered by the content title.

using Ektron.Cms.Framework.Content;
using Ektron.Cms.Content;
using Ektron.Cms.Common;
...
var contentManager = new ContentManager();
var contentCriteria = new ContentCriteria();
        
var AuthorFolderFilter = new CriteriaFilterGroup<ContentProperty>();
AuthorFolderFilter.Condition = LogicalOperation.And;
AuthorFolderFilter.AddFilter(ContentProperty.FolderId, CriteriaFilterOperator.EqualTo, 32);
AuthorFolderFilter.AddFilter(ContentProperty.LastEditorFirstName, CriteriaFilterOperator.StartsWith, "Ben");

contentCriteria.Condition = LogicalOperation.Or;
contentCriteria.FilterGroups.Add(AuthorFolderFilter);
contentCriteria.AddFilter(ContentProperty.FolderId, CriteriaFilterOperator.EqualTo, 34);

contentCriteria.OrderByField = ContentProperty.Title;
contentCriteria.OrderByDirection = EkEnumeration.OrderByDirection.Ascending;

var contentItems = contentManager.GetList(contentCriteria);

That’s a lot of code for what is, in the end, a simple query. To make the Ektron platform more supportable and maintainable, in 9.20, we introduced the EktronContext manager. Let’s translate our two queries from above into fluent Linq syntax as supported by the EktronContext object. Here’s the first query:

using Ektron.Cms;
using Ektron.Cms.Linq;
...
var contentItems = EktronContext<ContentData>.Source.Where(t => t.FolderId == 32 || t.FolderId == 34);

And here’s the second query:

using Ektron.Cms;
using Ektron.Cms.Linq;
...
var contentItems = EktronContext<ContentData>.Source
    .Where(t => t.FolderId == 34 
                || (t.FolderId == 32 && a.EditorFirstName.StartsWith("Ben")))
    .OrderBy(t=>t.Title);

Query expression syntax is also supported. The same queries written that way would be:

using Ektron.Cms;
using Ektron.Cms.Linq;
...
var contentItems = from c in EktronContext<ContentData>.Source
                    where c.FolderId == 32 || c.FolderId == 34
                    select c;

and the second query would be:

using Ektron.Cms;
using Ektron.Cms.Linq;
...
var contentItems = from a in EktronContext<ContentData>.Source
    where a.FolderId == 34 
        || (a.FolderId == 32 && a.EditorFirstName.StartsWith("Ben")) 
    select a;

This is far more readable, and we worked hard to make sure it was applicable to a wide array of data types. In fact, nearly 80 core data types are supported. The most common data types are constructs like ContentData, FolderData, TaxonomyData, TaxonomyItemData or UserData, but even uncommon data types, like WarehouseData, FormData and CmsDeviceConfigurationData, are supported. To retrieve data of a desired type, use the data class in the generic EktronContext source; for example:

EktronContext<ContentData>.Source.Where(...)
EktronContext<UserData>.Source.Where(...)
EktronContext<AliasRuleData>.Source.Where(...)

These context sources support querying by almost any property on the data class. Specifically, they support the properties on the associated Criteria classes for the Data class in question. They also support a range of operators that are useful for each data type. For example, both strings and lists can be used with the Contains method operator, and almost every data type supports the core comparison operators (equals, greater than, greater than or equal, etc.).


Additionally, the context sources support paging implementations through the orderby, skip, and take operators. Since the context manager is still using the framework manager, you also get the advantage of a smart cache layer, and your queries still respect the system business logic applicable to that data type.

We hope you find this new API pattern useful! The full documentation and list of supported classes and properties supported are available in the Ektron documentation.

Aug 02, 2017

Comments

error Please login to comment.
Latest blogs
From Review to Release: Publishing My First Optimizely OCP App

Building an OCP app is only half the story. This post follows Publish Child Items from its first submission to a live App Directory release: what...

Chirag Khanna | Nov 16, 2026 |

Brilliant and Ignorant: Building an Optimizely Knowledge Base for AI Agents

Claude is a brilliant developer who has never seen Optimizely. How we gave our agents the framework experience a human needs half a year to earn:...

Allan Thraen | Nov 16, 2026 |

Budgeting for Agent Platform credits in 2027

How to budget for Optimizely Agent Platform (formerly Opal) credits in 2027: what a credit buys, how to size use cases, and what to agree with...

Matthew Dunn | Nov 15, 2026 |

Integrating Siteimprove with Optimizely: From Accessibility Compliance to Content Excellence

Over the last few months, I’ve worked on several Optimizely solution designs involving accessibility, SEO, analytics, governance, and content...

Madhu | Nov 14, 2026 |

Fallback images that fit: handling broken images with a service worker

A broken image is never the right shape On a content-heavy commerce site, some images will fail. Editors delete assets that are still referenced, C...

Allyn Thomas | Nov 14, 2026

First Impressions of Optimizely Mark Desktop

What is Mark Desktop Optimizely have announced the release of the Mark Desktop App. Mark is the name for the Optimizely Agent Platform formerly kno...

Mark Stott | Nov 12, 2026