CnPack Forum

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

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 '子系统',
s ..

#1 >>Next Page

Forum:CVSTrac 相关问题
Thread:自己的任务单
Next Thread:邮件通知乱码问题 ...

Home
Login

Powered by Discuz!