How to display users associated with a node through Views I would like to create a View that displays users associated with a certain nid.

Under contextual filters, I have checked Content: Nid and selected

Provide a default value - Content ID from URL


Under Relationship, I have selected 

Entity Reference: Referencing entity


Then under Fields, I have selected 

(User referencing Content from field_office) User: First Name (First Name)
(User referencing Content from field_office) User: Last Name (Last Name)


But nothing is being displayed when I type in my nid into Preview with contextual filters

Essentially what I am trying to do is perform the following query:

$args = array(':nid' =&gt; $node-&gt;nid);
$results = db_query('SELECT USER_ID FROM USER INNER JOIN node ON USER.OFFICE_ID =
  node.title AND node.nid = :nid', $args);


I have done this before, but accidentally deleted the View. Now I am unable to make the View again, thought the DB structure has not changed at all.

Could someone please point out what I'm missing?
It seems to me that since your node reference field is on your user object and you want to list users, all you have to do is:


create a view listing Users
add a contextual filter corresponding to your entity reference field. The entity reference field on the User should appear in the contextual filters list. Choose that one.
Choose where the contextual filter value is coming from. If your view will be at myview/nid, where nid is the node id you want to use to filter, then you don't need to choose any other behavior. If you'll be displaying this view on a node page, use the default->content id from URL option.
Choose your user name fields without relationships. There is no relationship needed unless you need to bring in fields from the node being referenced.