Querying items with multiple related data items (Sitefinity)

Question

I was referring to this article for querying dynamic content with related data:

https://docs.sitefinity.com/example-query-dynamic-content-by-related-data

This is all well and good when dealing with single related item, but currently I am dealing with this scenario:

I have a custom content item of Human, and two related data items of type Hair Color and Eye Color (these are just example types of course)

Suppose I wanted to query all Human items with Hazel eyes and black hair, how can I do that in a clean way?

I came up with a hacky solution, but I need something that will work with either no related data query needed, or with one or both (all combinations)

Is there a tried and true way of doing this with Sitefinity's native API?

Answer 1

I think the cleanest way is to use the ContentLinksManager in addition to the DynamicModuleManager.

Here is pseudo code:

1. using the DynamicModuleManager get the OriginalContentId of the HairColor item (from the HairColor module) where Color == "Black"

2. using the DynamicModuleManager get the OriginalContentId of the EyeColor item (from the EyeColor module) where EyeColor == "Hazel"

3. Then

   var cmanager = ContentLinksManager.GetManager(); var humanWithBlackHairMasterIds = cmanager
                     .GetContentLinks()
                     .Where(c => c.ParentItemType == "Human type" &&
                                 c.ChildItemType == "HairColor type" &&
                                 c.IsParentDeleted == false && 
                                 c.IsChildDeleted == false &&
                                 c.ChildItemId == ID_From_Point1)
               .Select(c => c.ParentItemId);
   

Now humanWithBlackHairMasterIds will have the masterIds of all humans with black hair.

You can do a similar thing with the Eye color module and get all humans with Hazel eyes and finally intersect both results to get the humans that satisfy both conditions.