Thanks matt. That worked.
Incase someone else is looking for it ... here's our active tickets with
short description report
SELECT p.value AS __color__,
id AS ticket, summary, component, version, milestone, t.type AS type,
(CASE status WHEN 'assigned' THEN owner||' *' ELSE owner END) AS owner,
time AS created,
changetime AS _changetime, *substr(description, 1, 1000)* AS
_description_,
reporter AS _reporter
FROM ticket t, enum p
WHERE status IN ('new', 'assigned', 'reopened')
AND p.name = t.priority AND p.type = 'priority'
ORDER BY p.value, milestone, t.type, time
Shane
On 3/22/07, Matt Good <[EMAIL PROTECTED]> wrote:
>
> On Mar 21, 10:30 am, "Shāné" <[EMAIL PROTECTED]> wrote:
> > Is there any way I can display the first 200 words or 1000 chars of
> > the description of a ticket in a report instead of the full
> > description?
>
> In the sql:
> substr(description, 1, 1000)
>
> -- Matt Good
>
>
> >
>
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Trac
Users" group.
To post to this group, send email to trac-users@googlegroups.com
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
-~----------~----~----~----~------~----~------~--~---
