We're using Trac 11.5rc1 with sqlite on python 2.4.3
What I'd like to do is show only the first line of the description
field in a report. Amazingly, sqlite doesn't appear to have a built-in
function for this, and I'd have to load an extension for sqlite,
and ....
Seems like there must be a better way. My current workaround is to
just display an arbitrary number of characters from the description
field via "substr" function. My current TrackReport query is:
SELECT p.value AS __color__,
priority AS __group__,
id AS ticket, owner, summary, component, t.type AS type,
substr(description,1,80) AS _Description_
FROM ticket t
LEFT JOIN enum p ON p.name = t.priority AND p.type = 'priority'
WHERE t.type <> 'event' AND status <> 'closed' AND milestone <>
'Suggestion Box' AND p.value <= '8' AND p.value <> '10'
ORDER BY p.value, t.type
Any suggestions on improving this welcomed.
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Trac
Users" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/trac-users?hl=en
-~----------~----~----~----~------~----~------~--~---
