Thanks a lot, that's exactly what i wanted. i have finally find a way to do it by only changing report_view file. i created a form which allows to get the two dynamics variable and pass them throught the URL. now i have a small problem with the date format (years are not considered into the comparaison).. I will look into the tickets to make my solution more efficient.
Thanks again On Jun 25, 3:11 pm, Erik Bray <[email protected]> wrote: > It's not entirely clear what the OP's end goal is, but it might be > possible to just do with a custom report, especially since #7293. > Have two dynamic variables for the dates, and make sure that in the > SQL the variables are wrapped in the appropriate datetime formatting > function for the DB backend. Not clear if that's what he wants > though. > > On Thu, Jun 25, 2009 at 3:48 AM, Noah Kantrowitz<[email protected]> wrote: > > > You would have to make a custom plugin to do this. > > > --Noah > > > On Jun 24, 2009, at 12:35 AM, zineb wrote: > > >> Hi all, > > >> I am trying to add a FORM to a report where user have to insert two > >> date times > >> Example: > > >> Choose delivery date between: DD/MM/YYY and DD/MM/ > >> YYYY Submit > > >> I would like to get those two values and insert them into the sql > >> query which permits to create the report. > > >> I tryed using this condition in my query : > >> AND (c10.value between 'date_start' and '.date_end' ) ( c10.value is > >> my the delivery date) > > >> But it doesn't work. > > >> Please could you help me????? > > >> Thanks, > > >> Zineb --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Trac Development" 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-dev?hl=en -~----------~----~----~----~------~----~------~--~---
