I've got a scenario I need some guidance on both in terms of how to technically solve the issue "the Orchard way" and how to query the content.
I have a custom module that defines a number of custom content types. One of those items is a type Article. In the Article is a Content Picker Field to pick a Person - another custom content type in my module.
What I want to do is display a Person and show the Articles that Person is associated with. The problem I'm having is that I don't know exactly how I should retrieve that data.
I believe a Projection would just display a list of the Articles, when I want to show the Person data and then have a list of the Articles underneath.
Do I query that directly and display it via an AJAX call? Do I use a Projection and embed that somehow? There's probably a way to do either one, but I want to do it in a way that conforms to Orchard's best practices.
Any guidance or advice on the best tact to take?