Vulnerability in EPiServer.Forms

Try our conversational search powered by Generative AI!

Aniel Sud
Aug 2, 2017
  7936
(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
A day in the life of an Optimizely Developer - Optimizely CMS 12: The advantages and considerations when exploring an upgrade

GRAHAM CARR - LEAD .NET DEVELOPER, 28 Nov 2023 In 2022, Optimizely released CMS 12 as part of its ongoing evolution of the platform to help provide...

Graham Carr | Nov 28, 2023

A day in the life of an Optimizely Developer - OptiUKNorth Meetup January 2024

It's time for another UK North Optimizely meet up! After the success of the last one, Ibrar Hussain (26) and Paul Gruffydd (Kin + Carta) will be...

Graham Carr | Nov 28, 2023

Publish content to Optimizely CMS using a custom GPT from OpenAI 🤖

Do you find the traditional editor interface complicated and cluttered? Would you like an editorial AI assistant you can chat with? You can!

Tomas Hensrud Gulla | Nov 28, 2023 | Syndicated blog

Optimizely Graph and Next.js: Building Scalable Headless Solutions

Optimizely Graph harnesses the capabilities of GraphQL, an intuitive and efficient query language to, transform content within an Optimizely CMS in...

Szymon Uryga | Nov 27, 2023