[SOLVED] Views - Filtering nodes by current user profile field

Creating a User view instead of Content view is the key.

Thank you, even though it's months later. :)

I have the same question, only taxonomy is not involved. I want to filter nodes based on common field in their content type and user profile.
I haven't found any useful relationships either in user view (nothing related to content) or node view (nothing related to current user). What am I missing?
I can probably do this with View PHP, but this really is a basic functionality and should be possible without any additional scripting.

Hello, Thanks for that, worked perectly, but i want to add:
After create the view, you must to apply permission to the view.

step by step if possible would real help a persons like me

Thanks for this, Itangalo... it works perfectly! Even a year+ later :)

Hi,

Itangalo's approach worked great for me.
But I don't want every content tagged with the term, just certain content-types.
If I add a normal filter, my view returns empty.
and I get this notice:

Handler views_handler_field_node tried to add additional_field language but node could not be added!

why does this handler start looking for a language field when I add a filter for content:type?

help appreciated

thx,
eR

I've spend many an hour trying to figure out how to do this and this worked brilliantly. Thanks.

Hi Itangalo,
Your explanation is perfect.
I am a similar problem just a little bit more complex.
I have a content type "Restaurant" with a field restaurant_user referencing the user_name. Then I have Commerce Order with a field order_restaurant referencing the Restaurant. I need to make a view showing to the logged in user only the Commerce Orders having order_restaurant the same as the Restaurant which references the logged in user in restaurant_user.
I am playing with Views but I still get only the Orders made by the user and not the Orders made to the restaurant referencing the user.
How can this be done?
Thanks in advance for anybody helping me to solve this issue!

Adriaan

Just wanted to say thanks for this. I needed something very similar and these straightforward instructions made it possible. THANKS!

Your recipy works for me, i could not done it without it. One addition: if you have another contextual filter in the view, than the order of the filters also should be considered. In my case i had to put the user: uid filter second otherwise the view generates no output.

Cheers,
Cas

I have a similar question but rather than being interested in the currently logged in user, I am interested in matching and displaying all users who completed a specific field in their user profile.

I have a content type called "idea hub" with a term reference field of interests.

I am using the same term reference field in the user profile where users can indicate issues they are interested in discussing.

I want to create an EVA display attached to the idea hub content type so that when a user visits a page for a given term, s/he will see a view display all users who have indicated an interest in discussing that issue via their user profile page.

So far, I have created a user view and pulled in the fields I want to display. If I use a regular filter and select a single category at a time, I can get a list of users for that term. But I want the filter to be dynamic so that I don't have to build 15 views, one for each category and so that I don't have to build a new view every time we add a new category.

I know that using a contextual filter is the way to go, but I can find the right setting to make it work. I've tried just adding the contextual filter for that field on the user's profile and matching it on the token for the same field in the idea hub content type but I get no results.

I also tried creating a relationship to the user's interests field then adding the contextual filter using that relations. Still, no results. What am I missing here? Any help would be much appreciated.

I understand your steps if using taxonomy reference but I am using an entity reference field in the user profile. they are selecting a field from another content type. I basically want the same thing but i'm using entity reference and can't seem to get it to work and display all content that has the same field that's referenced in the user profile. do you know what relationships would be used for that?

Thanks

Itangalo, after almost 5 years, your post has helped me out of a depression! THX!

Using Contextual Filters means that the Current User ID can be overridden with any UID by simply including it in the URL. For instance, someone could see the info for User 1 by going to “…/myViewPage/1” instead of “…/myViewPage” by itself. This could lead to access bypass and information disclosure vulnerabilities.

To prevent this, don’t use Contexual Filter! Instead, add a regular Filter of type “User: Current.” Set it to “Yes” and don’t Expose it. That way it can’t be so easily overridden and will only display the info for the currently logged-in user, no matter what they put in the URL. You can also restrict by User: Roles or User: Permission or other such while you’re at it.

Other than that, follow @Itangalo’s instructions.

Tanks to Itangalo

Thank you to Guerno and Doppel above. Using your examples, I managed to solve my problem.

I wanted to create a content list of nodes that matched user profile choices. In particular I had two taxonomies that apply to nodes and to users and needed to match these nodes against the user choices. I used a content view and needed to satisfy five different filters. Two of the filters for the taxonomies needed to be dynamic. I needed the filters to be grouped as:

A & B & C & (D or E)

The taxonomy dynamic filters are represented by C and D. I managed to solve my problem by using two contextual filters for D and E. D was a term ID using php code to return corresponding author choices using the code:

global $user;
$account = user_load($user->uid);
$field_items = field_get_items('user', $account, 'field_categories');
//print_r($field_items);
$tids = "";

if ($field_items) {
foreach ($field_items as &$value) {
      $tids .= '' . $value['tid'] . '+';
}
  $tids = substr($tids, 0, -1);
}
 return $tids;

I needed to tick the Reduce Duplicates tick box for this filter to make the view use a left join, rather than an inner join, as otherwise I wasn't getting all the results.

The other contextual filter was simply passing a fixed value. I used the Views Contextual Filters OR module to make these two contextual filters use an OR statement. I then used the Views PHP filter module to allow the other dynamic taxonomy filter to be in the static filters section. I tried using the code that Doppel gave, but all the row fields were simply returning the node ID rather than the field values. However, I followed Guerno's idea of adding the term ID's as a relationship and got the following code to work:

//call current user.
global $user;
//load current user custom profile.
$user_profile = user_load($user->uid);

$user_school = $user_profile->field_school['und'][0]['tid'];
$school = $row->tid;

//Compare views field to current user's custom profile.
if($user_school == $school){
  return false;
}
else {
  return true;
}

Using this configuration I managed to get the filters working in the way I needed.