[Trac] Re: Date Ranged queries

[Justus Pendleton]

Andy Lubel <lubela at ...> writes:
> I see that in the custom report section, there is a nice little report
> builder where you can select columns, would it be hard to include date
> ranges in that?  Has it already been done?  I am very new to SQLlite, so I
> don't know how possible it is.. Can anyone point me in the right direction?
> Do any of you users out there use this software to cut nasty overhead coming
> from SW-CMM requirements?

It sounds like what you want is a new report --
http://projects.edgewall.com/trac/wiki/TracReports -- and you can just hand
write the SQL for that.  If you log in with someone who has REPORT_CREATE
privileges you'll see a link in the report section for "New Report".

If you want a list of all files that have changed this month you'd use a SQL
statement like:

select distinct name from node_change where rev in (select rev from revision
where time >= (select strftime ("%s", "now", "start of month")));

A list of new tickets this month would be something like:

select id from ticket where time >= (select strftime ("%s", "now", "start of
month"));