Board logo

Subject: 自己的任务单 [Print This Page]

Author: laney    Time: 2008-7-22 11:30     Subject: 自己的任务单

今天浏览官方网站,刚好看到一个自己需要的功能,贴出来与大家共享


SELECT
  CASE WHEN t.status='new' THEN '#ffaa99'
       WHEN t.status='active' THEN '#f2dcdc'
       WHEN t.status='review' THEN '#e8e8bd'
       WHEN t.status='tested' THEN '#bde5d6'
       ELSE '#cacae5' END as 'bgcolor',
  t.tn AS '#',
  e.value AS '类型',
  t.status AS '状态',
  sdate(t.origtime) AS '创建时间',
  t.owner AS '创建人',
  t.subsystem AS '子系统',
  sdate(t.changetime) AS '更新时间',
  t.assignedto AS '分配给',
  t.severity AS '严重',
  t.priority AS '优先',
  t.title AS '标题'
FROM enums e, ticket t
WHERE e.type='type'
  AND e.name=t.type
  AND t.status NOT IN ('fixed','closed')
  AND t.assignedto=user()
ORDER BY t.priority, t.severity, t.origtime

Image Attachment: [效果图] {480C0345-5099-44DF-9BD3-E1EDDCB095C7}.bmp (2008-7-22 11:30, 492.26 K) / Download count 513
http://bbs.cnpack.org/attachment.php?aid=439






Welcome to CnPack Forum (http://bbs.cnpack.org/) Powered by Discuz! 5.0.0