RE: [Trac] How to write report SQL to group by day

2006-03-31 Thread ECKHART.CURT
Thanks for the response, but I'm having a little trouble with (formatting system may vary). Where is the documentation on how to format query output fields in Trac Sqlite? I can't find it anywhere. I tried several DB formatting syntaxes but it always returned Unknown function. Pointers anyone?

Re: [Trac] How to write report SQL to group by day

2006-03-30 Thread Jani Tiainen
ECKHART.CURT kirjoitti: Hi folks, I'm trying to write a TRAC report, and I'm stumped by a little thing. I'm closing out a project which we've controlled using TRAC and I need to begin monitoring items closed out each day. I tried a clause: time AS __group__ in the hopes of getting each

[Trac] How to write report SQL to group by day

2006-03-29 Thread ECKHART.CURT
Hi folks, I'm trying to write a TRAC report, and I'm stumped by a little thing. I'm closing out a project which we've controlled using TRAC and I need to begin monitoring items closed out each day. I tried a clause: time AS __group__ in the hopes of getting each day's tickets grouped by day.