Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at


  • Tony Davis 2 posts 72 karma points
    Nov 20, 2022 @ 05:43
    Tony Davis
    0

    Query by Property of a ContentPicker Property

    I am a Cloud subscriber setting up a basic blog. I want to filter the list of blog articles by author, but I am having a hard time with querying a collection on the value of a property that has properties of its own. "Author" is a document type. "Article" is a document type that has a custom ContentPicker for selecting an "Author". I have the following code in my view template:

    var articles = Umbraco.Content(Guid.Parse("654c40f6-187e-4fa7-a68e-00ce50e7aa9c"))
            .Children<Article>("article")
            .Where(x => x.IsVisible())
            .OrderByDescending(x => x.Value<DateTime>("publishDate"));
    
    
    var requestQueryString = String.Empty;
    
    // If author parameter is selected, narrow articles to author in Request query author parameter
    if(!string.IsNullOrEmpty(HttpContextAccessor.HttpContext.Request.Query["author"]))
    {
        requestQueryString = HttpContextAccessor.HttpContext.Request.Query["author"];
    
        // Everything works until I try to filter by author
        articles = articles.Where(a => a.Author.Key == requestQueryString);
    }
    

    I'm not sure how I would achieve this in Umbraco. Any insights are greatly appreciated. Thank you. :)

  • This forum is in read-only mode while we transition to the new forum.

    You can continue this topic on the new forum by tapping the "Continue discussion" link below.

Please Sign in or register to post replies