Retrieve related item with single related item limitation

Use this example when you want to retrieve a related item of an item, in case multiple items are not allowed. For example, you may have the limitation that a conference can have only one speaker. This means that to one conference item, you can relate only one speaker item.

In this case, if you use the GetRelatedItems method with the limitation to return a single item, you will get the error “Query execution found more than one element."

This is because every item has two versions – the Master and the Live.

In this case, you can retrieve the single item, using the RelatedDataPropertyDescriptor in the following way:

By default, it applies status filtering and returns either a collection of items or a single item (when you have limitation on the field).  It will return the related speaker with status corresponding to the item status – Master or Live.

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

Web Security for Sitefinity Administrators

The free standalone Web Security lesson teaches administrators how to protect your websites and Sitefinity instance from external threats. Learn to 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?