Topics

All topics

Development

    Example: Filter dynamic content items by dynamic field

    NEW TO SITEFINITY?

    This example uses a Movie Collection module with the following hierarchical structure:

    • The module is named Movie Collection
    • The module has content type Movies. Movies holds information about different movies and has the following fields:
      • Title - ShortText field
      • Year - Number field
      • ShotIn3D - Yes/No field
      • Genre - Choices field
        • Action
        • Drama
        • Comedy
      • Tags - Classification field
      • Actors - RelatedData field
      • Poster - RelatedMedia field
    • The module has content type Actor. The Actor content type has only one field Name that contains the name of the actor.

    using System;
    using System.Linq;
    using Telerik.Sitefinity.Data.Linq.Dynamic;
    using Telerik.Sitefinity.DynamicModules;
    using Telerik.Sitefinity.DynamicModules.Model;
    using Telerik.Sitefinity.Modules.Libraries;
    using Telerik.Sitefinity.RelatedData;
    using Telerik.Sitefinity.Taxonomies;
    using Telerik.Sitefinity.Taxonomies.Model;
    using Telerik.Sitefinity.Utilities.TypeConverters;
    namespace Telerik.Sitefinity.Documentation.CodeSnippets.SFTools.TemplateBuilder.HierarchicalDM
    {
    public partial class FilterDynamicContentItems
    {
    private void FilterDynamicContent()
    {
    // Get an instance of the dynamic module manager
    var providerName = String.Empty;
    DynamicModuleManager dynamicModuleManager = DynamicModuleManager.GetManager(providerName);
    // Resolve dynamic content item types
    Type movieType = TypeResolutionService.ResolveType("Telerik.Sitefinity.DynamicTypes.Model.MovieCollection.Movie");
    Type actorType = TypeResolutionService.ResolveType("Telerik.Sitefinity.DynamicTypes.Model.MovieCollection.Actor");
    // Get collection of movies
    var allMovies = dynamicModuleManager.GetDataItems(movieType);
    // Get collection of actors
    var allActors = dynamicModuleManager.GetDataItems(actorType);
    // Filter movie collection by ShortText field
    var moviesByTitle = allMovies.Where("Title = \"Some Title\"");
    var moviesByTitleAlternative = allMovies.Where("Title.Contains(\"Some Title\")");
    var moviesByTitleAndStatus = allMovies.Where("Title.Contains(\"Some Title\") && Status = \"Live\"");
    // Filter movie collection by a Number field
    var moviesFrom2003 = allMovies.Where("Year = 2003");
    var moviesBefore2000 = allMovies.Where("Year < 2000");
    // Filter movie collection by a YesNo field
    var moviesIn3D = allMovies.Where("ShotIn3D = true");
    var moviesNotIn3D = allMovies.Where("ShotIn3D = false");
    // Filter movie collection by a Choices field
    var dramaMovies = allMovies.Where("Genre = \"Drama\"");
    var actionMovies = allMovies.Where("Genre = \"Action\"");
    var comedyMovies = allMovies.Where("Genre = \"Comedy\"");
    // Filter movie collection by Classification field
    var taxonomyManager = TaxonomyManager.GetManager();
    var tags = taxonomyManager.GetTaxonomies<FlatTaxonomy>().FirstOrDefault(x => x.Title == "Tags");
    var tag = tags.Taxa.FirstOrDefault(x => x.Title == "Some movie tag");
    var moviesByTag = allMovies.Where("Tags.Contains((" + tag.Id.ToString() + "))");
    // Filter movie collection by RelatedData field
    var actor = allActors.Where("Name.Contains(\"Actor Name\")").FirstOrDefault();
    var moviesByActor = actor.GetRelatedParentItems(movieType.FullName, providerName, "Actors").OfType<DynamicContent>();
    // Filter movie collection by RelatedMedia field
    var image = LibrariesManager.GetManager().GetImages().FirstOrDefault();
    var moviesByPoster = image.GetRelatedParentItems(movieType.FullName, providerName, "Poster").OfType<DynamicContent>();
    }
    }
    }
    view raw FilterDynamicContentItems.cs hosted with ❤ by GitHub

    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?