Query dynamic content by related data

In the following example, you use the Sitefinity CMS API to query dynamic content items by their reltaed data fields. In the example, you use two dynamic module types:

Physicians
Specialties

Physicianshave a related data field to the Specialties type. Using a specific specialty, for example Neurology, you can query all physicians that have that specialty. To do this, use the following code:

using System;
using System.Linq;
using Telerik.Sitefinity.Data.ContentLinks;
using Telerik.Sitefinity.Model;

namespace SitefinityWebApp
{
   public class GetAllRelationsByParent
   {
       public IQueryable<IDataItem> GetRelationsByParent(Guid itemId, string itemProviderName, string itemTypeName, string fieldName)
       {
           ContentLinksManager contentLinksManager = ContentLinksManager.GetManager();

           var linksToRelatedItems = contentLinksManager.GetContentLinks()
               .Where(cl => cl.ParentItemId == itemId && 
                   cl.ParentItemProviderName == itemProviderName && 
                   cl.ParentItemType == itemTypeName && 
                   cl.ComponentPropertyName == fieldName);
           
           return linksToRelatedItems;

       }
   }
}

Make sure you include the namespaces that resolve the types you use in the query. In this example, you need to include in your project the following namespaces:

using System;
using System.Linq;
using Telerik.Sitefinity.Data.ContentLinks;
using Telerik.Sitefinity.Model;

namespace SitefinityWebApp
{
   public class GetAllRelationsByChild
   {
       public IQueryable<IDataItem> GetRelationsByChild(Guid itemId, string itemType, string itemProviderName, string parentItemTypeFullName)
       {
           ContentLinksManager contentLinksManager = ContentLinksManager.GetManager();

           var links = contentLinksManager.GetContentLinks()
               .Where(cl => cl.ChildItemId == itemId &&
                   cl.ChildItemType == itemType &&
                   cl.ChildItemProviderName == itemProviderName &&
                   cl.ParentItemType == parentItemTypeFullName);

           return links;
       }
   }
}

As a result, all physicians that have Neurology specialty are queried.

Want to learn more?

Enhance your Sitefinity skills by enrolling in free training sessions. Become Sitefinity certified through Progress Education Community to strengthen your professional credentials.

Get started with Integration Hub | Sitefinity Cloud

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

Web Security for Sitefinity Administrators

This free lesson teaches administrators the basics about protecting your Sitefinity instance and your 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 ASP.NET Core and take advantage of its decoupled architecture and modern development model.