Topics

All topics

Development

Query localized items

NEW TO SITEFINITY?

You can query items that have a localized field in multiple cultures. You can query all items from a specific culture, for example all items translated in French.

In the following example, you query all dynamic items that have a localized field with a value that applies to a specific culture. To do so:

  1. Get an instance of the DynamicModuleManager class.
  2. Resolve the name of the dynamic content type using the TypeResolutionService class.
  3. Get the localized field name for the specified culture using the LstringPropertyDescriptor class.
    For example, a localized name for a field, called Title in French culture is Title_fr.
  4. Filter the data items by passing the localized field name for the culture and select the Master version using the ContentLifecycleStatus class.
using System;
using System.Collections.Generic;
using System.Globalization;
using System.Linq;
using Telerik.Sitefinity.Abstractions;
using Telerik.Sitefinity.Descriptors;
using Telerik.Sitefinity.DynamicModules;
using Telerik.Sitefinity.DynamicModules.Model;
using Telerik.Sitefinity.GenericContent.Model;
using Telerik.Sitefinity.Model;
using Telerik.Sitefinity.Utilities.TypeConverters;
namespace Telerik.Sitefinity.Documentation.CodeSnippets.DevGuide.SitefinityEssentials.Multilingual
{
public partial class MultilingualSnippets
{
public static IEnumerable<DynamicContent> LocalizedQuery(string typeName, string fieldName, string targetCulture)
{
DynamicModuleManager manager = DynamicModuleManager.GetManager();
Type dynamicType = TypeResolutionService.ResolveType(typeName);
CultureInfo c = new CultureInfo(targetCulture);
// transform the given culture for persistence as it may be different than the one in the UI
var persistenceCulture = new CultureInfo(AppSettings.CurrentSettings.GetCultureName(new CultureInfo(targetCulture)));
string fieldNameForCulture = LstringPropertyDescriptor.GetFieldNameForCulture(fieldName, persistenceCulture);
var result = manager.GetDataItems(dynamicType)
.Where(x => x.GetValue<string>(fieldNameForCulture) != null)
.Where(x => x.Status == ContentLifecycleStatus.Master)
.ToList();
return result;
}
}
}
view raw LocalizedQuery2.cs hosted with ❤ by GitHub

As a result, you get a list of all items translated in the specified culture.

Want to learn more?

Increase your Sitefinity skills by signing up for our free trainings. Get Sitefinity-certified at Progress Education Community to boost your credentials.

Get started with Integration Hub | Sitefinity Cloud | Sitefinity SaaS

This free lesson teaches administrators, marketers, and other business professionals how to use the Integration hub service to create automated workflows between Sitefinity and other business systems.

Web Security for Sitefinity Administrators

This free lesson teaches administrators the basics about protecting yor Sitefinity instance and its sites from external threats. Configure HTTPS, SSL, allow lists for trusted sites, and cookie security, among others.

Foundations of Sitefinity ASP.NET Core Development

The free on-demand video course teaches developers how to use Sitefinity .NET Core and leverage its decoupled architecture and new way of coding against the platform.

Was this article helpful?

Next article

Query all pages of a translation