Query custom node by user Entity Reference I am trying to build a query that finds all nodes of a custom type where one of the fields is a user Entity Reference.  I am trying to use EntityFieldQuery but just as open to db_select().  The following is just an example of one of the queries I have tried.

$query = new EntityFieldQuery();

$query
  -&gt;entityCondition('entity_type', 'node', '=')
  -&gt;propertyCondition('type', 'custom_node', '=')
  -&gt;fieldCondition('field_marketer', 'value', $user-&gt;uid, '=');

$entities = $query-&gt;execute();


Thanks in advance for any help.
The column name for an entity reference field is target_id, so your code should be:

$query = new EntityFieldQuery();

$query
  -&gt;entityCondition('entity_type', 'node', '=')
  -&gt;propertyCondition('type', 'custom_node', '=')
  -&gt;fieldCondition('field_marketer', 'target_id', $user-&gt;uid, '=');

$entities = $query-&gt;execute();