Virtual Happy Hour this month, Jun 28, we'll be getting a sneak preview at our soon to launch SaaS CMS!

Try our conversational search powered by Generative AI!

Aniel Sud
Aug 2, 2017
  8314
(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

Please login to comment.
Latest blogs
Copying property values part 2

After publishing my last article about copying property values to other language versions, I received constructive feedback on how could I change t...

Grzegorz Wiecheć | Jun 18, 2024 | Syndicated blog

Enhancing online shopping through Optimizely's personalized product recommendations

In this blog, I have summarized my experience of using and learning product recommendation feature of Optimizely Personalization Artificial...

Hetaxi | Jun 18, 2024

New Series: Building a .NET Core headless site on Optimizely Graph and SaaS CMS

Welcome to this new multi-post series where you can follow along as I indulge in yet another crazy experiment: Can we make our beloved Alloy site r...

Allan Thraen | Jun 14, 2024 | Syndicated blog

Inspect In Index is finally back

EPiCode.InspectInIndex was released 9 years ago . The Search and Navigation addon is now finally upgraded to support Optimizely CMS 12....

Haakon Peder Haugsten | Jun 14, 2024