我创建了一些Trac报告,但是尝试使用SQL来制作它们时,得到的结果与我预期的不同。这是我的SQL查询:
SELECT p.value AS __color__,
reporter AS __group__,
id AS ticket, summary, resolution , component,
t.type AS type, priority, severity, time AS created,
changetime AS modified,
changetime AS __changetime, description AS _description,
reporter AS _reporter
FROM ticket t
LEFT JOIN enum p ON p.name = t.priority AND p.type = 'priority'
WHERE t.status = 'closed'
ORDER BY changetime DESC, CAST(p.value AS integer), milestone, t.type, time
使用这个查询,按报告人分组并没有起作用。我得到了几行每个报告人的结果。所以我尝试使用“自定义查询”功能来获得结果。使用以下TracQuery产生了我期望的结果:
query:?status=closed
&group=reporter
&col=id
&col=summary
&col=resolution
&col=component
&col=type
&col=priority
&col=severity
&col=time
&col=changetime
&order=changetime
&desc=1
我的问题是:我能否将TracQuery转换为SQL语句,或者能否查看后端执行的SQL语句?我之所以问这个问题,是因为我想要能够转换一些列或使用其他SQL函数。