CODEWITHSUNDEEP
c#sitecore
timT
timT

Reputation: 287

Get all items that match a DropLink option in Sitecore

This seems like it should be easy. Maybe it is and I'm just overthinking it. I have a bunch of items that have a category field set via a DropLink. I want to grab all of the items that match one of those options. E.g., Grab a list of all items where Category=Brochure. I can't seem to get the ID of the Droplink option to match against the Category option on the Item itself.

EDIT: Included current code by request. 

public List<PoolDownload> Manuals
        {
            get
            {
                LookupField cat = (LookupField)this.Item.Fields["Category"];
                return this.Downloads.Where(i => (i.Item.TemplateID == PoolDownload.TemplateId) &&
                                        (i.Item.GlassCast<Pdp.Pool.Website.Business.Entities.PoolDownload>().Category.ToString() == cat.TargetID.ToString()))
                                        .ToList();
            }
        }

Upvotes: 1

Views: 1056

Answers (1)

DougCouto
DougCouto

Reputation: 530

I believe the problem is you're comparing a Guid.ToString() to a Sitecore.Data.ID.ToString(). These two statements return different values:

var guidToString = Sitecore.Context.Item.ID.Guid.ToString();
// "2a6a1d9a-be1d-411b-821a-7e63775280b3"

var idToString = Sitecore.Context.Item.ID.ToString();
// "{2A6A1D9A-BE1D-411B-821A-7E63775280B3}"

Cast the TargetID to a Guid as well and you should be good.

And to answer your question in your comment below about displaying the "Download Items" grouped by Category, you could use the GroupBy method, https://msdn.microsoft.com/en-us/library/bb534304(v=vs.110).aspx like this:

public IEnumerable<IGrouping<Guid, PoolDownload>> Manuals
{
    get
    {
        LookupField cat = (LookupField)this.Item.Fields["Category"];

        return this.Downloads.Where(i =>
            i.Item.TemplateID == PoolDownload.TemplateId
            && i.Item.GlassCast<Pdp.Pool.Website.Business.Entities.PoolDownload>().Category.ToString() == cat.TargetID.Guid.ToString())
            .GroupBy(i => i.Category);
    }
}

And then, to loop over the results in the new Manuals property, you could do something like this:

foreach(var categoryGroup in Manuals)
{
    var categoryGuid = categoryGroup.Key;

    foreach(var download in categoryGroup)
    {
        var downloadInCurrentGroup = download.Item;
    }
}

Upvotes: 1

Related Questions