-- ## 9: Related to current user ## --

-- All reports related to current user

SELECT id AS ticket, summary, component, type, 
   owner, status
  FROM ticket t
  WHERE status <> 'closed' 
  AND (owner=$USER OR reporter=$USER)
  ORDER BY id desc