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!

Øyvind Hognestad
Aug 4, 2009
(1 votes)

Globalization, categories and sorting using LINQ

I have been working with a globalized website for some time and have a couple of tips to share regarding globalization.

I’m using FindPagesWithCriteria to get pages based on categories defined on pages. As we teach during the EPiServer developer course FindPagesWithCriteria uses queries directly to the database. The method has got a performance boost in EPiServer CMS5, but should never be used on a typical landing page without caching.

Categories are quite useful if you do not need the complete Topic Maps structure. Anders Hattestad has written a nice post on how to create a custom property to display a part of the categorytree.

Well, back to the topic. Using FindPagesWithCriteria will not return the pages as they are displayed in editmode with fallback and replacement languages (which I hopefully thought). After some testing I found that the best way to get the pages I needed was to use LanguageSelector.AutoDetect(true) as the last parameter.

   1: PageDataCollection pages = 
   2: DataFactory.Instance.FindPagesWithCriteria(searchFrom, crits, 
   3: language, LanguageSelector.AutoDetect(true));

The pages collection will now also contain pages not translated to the current language. So, with a little help from reflector I removed the unwanted pages like this.

   1: public static PageDataCollection FilterForFallbackLanguages(PageReference pageLink, string languageBranch, PageDataCollection result )
   2:        {
   3:            PageLanguageSetting setting = PageLanguageSettingsTree.Instance.Get(pageLink, languageBranch);
   5:            if (setting != null)
   6:            {
   7:                List<string> fallback = new List<string>(setting.LanguageBranchFallback);
   9:                for (int i = result.Count - 1; i >= 0; i--)
  10:                {
  11:                    if (result[i].LanguageBranch != setting.LanguageBranch && fallback.Contains(result[i].LanguageBranch) == false)
  12:                        result.RemoveAt(i);
  13:                }         
  14:            }
  16:            return result;
  18:        }

Then my collection was complete. The last step was to sort the collection so the pages of the origin language – Norwegian – came first in the list and the fallback language – English - at the bottom of the list. In addition the sorting inside the language should be PageName. I could write my own comparer or my own filter but a better, and much easier solution, is to use LINQ (thanks Ahsan at support who suggested this solution to a partner in a post I came across while surfing around).

   1: var sorted = from page in pages
   2: orderby page.LanguageID descending, page.PageName ascending 
   3: select page;
   5: pageList.DataSource = sorted;
   6: pageList.DataBind();

To get this to work I needed to change the webcontrol which render this list from EPiServer:PageList to Asp:Repeater. EPiServer:PageList do not support this and you will get an error like this if you try.

System.NotSupportedException: Specified method is not supported.

After changing the webcontrol from EPiServer:PageList to Asp:Repeater, remember to use the FilterForVisitor.Filter(pages); to set the right security and remove the unpublished pages.


Globalization is cool, it works like a charm in most cases, but be aware of that the time used to develop could take a little longer than you think. Perhaps more important – put some effort when testing the site after the content is in place and real fallback and replacement language is set.

Aug 04, 2009


Apr 3, 2017 11:14 AM

Please login to comment.
Latest blogs
Remove a segment from the URL in CMS 12

Problem : I have created thousands of pages dynamically using schedule jobs with different templates (e.g. one column, two columns, etc..) and stor...

Sanjay Kumar | Jun 21, 2024

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