You can probably do something like this using Views relationships. <br><br>Here's some videos to get started:<br><a href="http://drewish.com/node/127">http://drewish.com/node/127</a><br><a href="http://gotdrupal.com/videos/drupal-views-relationships">http://gotdrupal.com/videos/drupal-views-relationships</a><br>
<br><br><div class="gmail_quote">On Fri, Nov 19, 2010 at 3:17 PM, Neil Coghlan <span dir="ltr"><<a href="mailto:neil@esl-lounge.com">neil@esl-lounge.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
I've actually managed to do half of this already. I have a content type<br>
that I use as a profile which included the taxonomy vocabulary<br>
"location". Each user chooses a country.<br>
<br>
I now have two views called "local content" and "local users". The first<br>
shows all content across the site that also shares the same taxonomy<br>
term and the second view shows all other users who share that same<br>
taxonomy term. Both use default arguments injected into the view by php<br>
code (an sql query)<br>
<br>
Now I'd like to create a final view where a user who has filled out a<br>
profile can see content created by other users who share the same<br>
taxonomy term - a sort of hybrid of the two I already have.<br>
<br>
I can't see how I could use arguments for this one...it seems more<br>
likely I'll have to play around with filters, but how can I use php/sql<br>
in filters?<br>
<br>
Has anyone else managed to do this type of thing with Views?<br>
<br>
Neil<br>
<font color="#888888">--<br>
[ Drupal support list | <a href="http://lists.drupal.org/" target="_blank">http://lists.drupal.org/</a> ]<br>
</font></blockquote></div><br>