Create single exposed filter that does OR filter based on two fields D7 - Views 3 I have a content type teams and a content type games. Games has two node reference fields: home-team and away-team (that both reference content type teams). I want to create a single exposed filter teams that filters to games where either home-team or away-team matches the selected team. 

For those with more experience hacking views - what approach would you take? Should I extend a handler to do this (views_handler_filter_in_operator)? Any pointers? 

Or run a db_query and pass the results to a views alter hook? 

Any input appreciated.
Views 3 views have a neat little semi-hidden feature. Click the arrow on the add button in the Filters section and pick and/or. From here, you can create filter groups and sort your filters to use AND or OR depending on your needs. Play with it; I think you'll be able to solve your issues like this.