Display all nodes for which user appears as a field on that user's profile? I have a site with a content type "Projects," which has a field "Project Manager" that takes a user. Is there a good way to display all Projects for which a user appears as the Project Manager for that Project on that user's profile?

Update:

Here is what I have so far in user_profile.tpl.php

...
function my_module_user_view($account, $view_mode, $langcode) {

  $my_field = 'field_pm';
  $uid = $account-&gt;uid; // The uid of the user being viewed.
  $query = "SELECT entity_id FROM {field_data_{$my_field}} WHERE {$my_field}_target_id = :uid AND bundle='user'";
  $args = array(':uid' =&gt; $uid,);
  $result = db_query($query, $args);
  $nids = $result-&gt;fetchCol();
  if (count($nids)) {
    $projects = node_load_multiple($nids); // Load all projects where that user is a PM
    foreach ($projects as $project) {
      $account-&gt;content['field_pm_projects'][0]['#markup'] = $project-&gt;title;
    }
  }
}
?&gt;

&lt;div class="profile"&lt;?php print $attributes; ?&gt;&gt;
 &lt;?php print render($user_profile); ?&gt;
 &lt;?php print $account-&gt;content['field_pm_projects']; ?&gt;&lt;/span&gt;
&lt;/div&gt;
Add a contextual filter for that entity reference field and in its settings, provide default: uid from url. That will only show nodes where the uids match.

There are two options, "referenced" and "referencing".. I'm pretty sure you want referenced but try both.