I'm trying to come up with a way to filter a views list based on if the nodes listed are referred to by another node. My scenario is this;
I have a restaurant site that list all of the restaurants in town. The restaurants can have coupons (these coupon type nodes refer back to the restaurant). When I'm viewing a list of restaurants I want to be able to filter them by if they have a coupon. I can write an sql statement to give me this but can't figure out how to make cck/views do the equivalent. Thanks in advanced for any help!

Mike

Comments

mnapier’s picture

mnapier commented

Guess I'm going to make a cron job to change a hidden field for if a node has a coupon and filter by that. If anyone comes up with a way to make this filter without doing it through a separate field and a cron job let me know.

joachim’s picture

joachim commented
Status: Active » Closed (fixed)

On the offchance you're still working on this, http://drupal.org/project/ReferencedByFilter does what you need I think.