When reading a blog post in SharePoint, I'd like to be able to display a list of other posts that are related based on the category of the existing post. I thought I could just add the post list web part and then connect it to the post on the page and send the category, but that doesn't work. Maybe because in the blog you can select multiple categories. So I'm a bit stuck on how to accomplish this. Anyone have any suggestions?
We are on SharePoint 2010, and I'm using the OOB blog site. One other caveat is that I'm not a developer, so complex coding solutions are not an option. Need to be able to use OOB web parts. Can use script in a CEWP if necessary.