-- ## 14: List tickets where priority is $PRIORITY (Dynamic variable test) ## --

-- Only tickets not already closed, btw.

SELECT id AS ticket,summary,status,  (SELECT (CASE
           WHEN delta > 86400 THEN round(delta/86400.0) || ' days'
           WHEN delta > 3600  THEN round(delta/3600.0) || ' hours'
           ELSE round(delta/60) || ' mins' 
           END)
   FROM (SELECT ((time.now * 1000000 - changetime) / 1000000.0) AS delta
        ) AS ct
  ) AS LastModified, changetime as _age
FROM ticket,  (SELECT extract(epoch from current_timestamp) as now) time
WHERE priority='$PRIORITY' and status != 'closed'
ORDER BY _age DESC