On Jun 24, 4:42 pm, yoheeb <[email protected]> wrote:
> you can use a custom sql report, as mentioned above. but you don't
> need to install the datefield plugin. The datefield plugin is
> valuable. however, what you are trying to do has been done with sql
> and date functions:
>
> see this
> thread:http://groups.google.com/group/trac-users/browse_thread/thread/c3452e...
>
> It has a few different types of date based reports for you. closed
> the last month, closed THIS month..etc. I believe they are SQLlite
> examples, no guarantees on postgres or mysql.
>
> one of these is looking for tickets that transitioned to closed
> between 2 dates. The dates in this thread are hardcoded, but could be
> supplied as part of the url to the report to dynamic variables. in
> your case, you would only need half the equations the greater than
> date X part. Rather then between.
>
> you would send the date to the report by appending it to the report
> url like so: YourProjectPath/report/18?DATEONE=2009-03-24 or
> something, might have to escape for urls assuming you used DATEONE as
> your variable. then in place of the hardcoded date you just put
> DATEONE.
>
> The "downside" of this is if you click on the actual report link in
> "view tickets" it bonks, since you need to provide the dynamic
> variable. It's easy to provide the variable as part of a wiki link
> however. if you wanted to auto-fill in the date form a selection,
> you'd need a custom form, or template, or maybe something that uses
> the datepicker javascript plugin thingy with some custom page/template-
> fu somehow. I'm sure it's easy for people that understand css and
> templates etc. I just embed it as a link on a wiki page :D
If you get the sql working for you please add it here with "{{{" code
"}}}"
http://trac.edgewall.org/ticket/8354
Thanks,
Lucas
>
> hope this helps.
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
