I think it would be a useful feature to have the date fields as filter
options in the custom filter, then you would be able to filter against
specific dates, or have an offset, such as -30 or -7 for relative
dates.
Once the code is in place, it would be simple to produce monthly
reports.
I'd be happy to look into this if someone could give me a little
guidance on how to add items to the filter list
Paresh
On Aug 7, 8:24 am, jtuchscherer <[EMAIL PROTECTED]> wrote:
> Hi there,
>
> julianday is not working for me on the MySQL database.
>
> I use this statement:
>
> select t.id as id, t.summary as title, t.changetime as modified from
> ticket t where unix_timestamp(DATE_SUB(CURDATE(),INTERVAL 2 DAY)) <=
> t.changetime;
>
> This works on MySQL.
>
> johannes
>
> On Aug 6, 11:50 pm, "Mike Kruger" <[EMAIL PROTECTED]> wrote:
>
> > How about something like this:
>
> > SELECT (CASE status
> > WHEN 'closed' THEN 'color: #777; background: #ddd; border-color:
> > #ccc;'
> > ELSE
> > (CASE owner WHEN '$USER' THEN 'font-weight: bold' END)
> > END) AS __style__,
> > id AS ticket, summary, status as _status,
> > time AS _time,reporter AS _reporter
> > FROM ticket t
> > WHERE ((julianday('now') - julianday('1970-01-01')) - changetime/86400) < 7
> > ORDER BY (status = 'closed'), changetime DESC
>
> > mike
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
