As the title says. I'm looking for a way to theme nodes in teaser listings according to whether they have flagged comments. I don't care about the number of flagged comments, only it should have a TRUE / FALSE state based on whether there is anything in there that is flagged. Is this a quest that is doomed to fail?

Comments

quicksketch’s picture

quicksketch
he/him
commented

You'll probably need to do a manual SQL query to efficiently do what you're attempting. There's no reason why this couldn't be done, it's just a matter of writing the correct query that joins the comment and flag_counts tables.

mitchell’s picture

mitchell commented
Status: Active » Postponed (maintainer needs more info)

If writing SQL query is too difficult, I would recommend you start with learning views relationships. Here's a very good video if you're just starting with the feature: http://drewish.com/node/127

Good luck!

magnestyuk’s picture

magnestyuk commented
Component: Code » Views integration

thanks!
I will check it out.

quicksketch’s picture

quicksketch
he/him
commented
Status: Postponed (maintainer needs more info) » Closed (fixed)