On Tuesday 07 August 2007, Paresh wrote:
>
> 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,
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
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, "Mi
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
Surely someone knows how to do something like this.. All I need is the WHERE
clause. What can I write there to restrict to bugs modified in the past 7
days?
Thanks again,
Noam.
On 8/5/07, Noam Tamim <[EMAIL PROTECTED]> wrote:
>
> Hi,
> Does anyone have a recipe for a report that only shows ticket