user's own tikets shows tickets from everybody,

in /jobtrack/user/3?sort=asc&order=Prioriy

CommentFileSizeAuthor
screenshot1.png26.74 KBMiguel.Andrade

Comments

Miguel.Andrade’s picture

Miguel.Andrade commented
Title: user's own tikets shows tickets from everybody » user's own tickets shows tickets from everybody
Miguel.Andrade’s picture

Miguel.Andrade commented

Temporary fix:

add:

    $sql .= " AND n.uid = $user->uid";

after 

  $clients = jobtrack_search_available_clients();
  $sql = "SELECT DISTINCT(n.nid), n.title, n.type, n.changed, n.uid, u.name, GREATEST(n.changed, l.last_comment_timestamp) AS (...)

(about line 30 in jobtrack.user.inc)

so that becomes:

  $clients = jobtrack_search_available_clients();
  $sql = "SELECT DISTINCT(n.nid), n.title, n.type, n.changed, n.uid, u.name, GREATEST(n.changed, l.last_comment_timestamp) AS (...) 
  $sql .= " AND n.uid = $user->uid";

Note: Lines have been truncated.

jeremy’s picture

jeremy commented
Status: Active » Fixed

Thanks for noticing this bug, fixed.

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.