Re: [otrs] Stats-Module and problems with @Params

26 Aug 2009

      guenther.rasch@gmx.de schrieb:
...
Hi Renee,
short question, is that right (u.login = ?...):
Yes, that's correct.

I have used your module, made the changes I proposed and everything runs
fine. So there seems to be another problem.

Do you have replaced the old module for your installation? Does you OTRS
instance run under mod_perl? If so, can you force Apache to reload the
stats module?

Cheers,
Renée
...
$Self->{DBObject}->Prepare(SQL => "SELECT ta.create_by,
                                        ta.time_unit,
                                        ta.ticket_id,
                                        t.customer_id,
                                        u.login,
                                        t.title
                                        FROM ticket t, time_accounting ta, users u
                                        WHERE t.id = ta.ticket_id
                                                AND (ta.change_by = u.id
                                                        AND (
                                                                month( ta.change_time ) = $Month
                                                                AND year( ta.change_time ) = $Year
                                                        )
                                                        AND (
                                                                t.queue_id IN ( 5, 6, 8, 9, 10, 11, 12 )
                                                        )
                                                        AND (
                                                                u.login = ?
                                                        )
                                        )",
                                Bind => [ \$User ],
    );
Regards
Günther
-- 

Perl-Magazin: http://perl-magazin.de
Perl-Nachrichten: http://perl-nachrichten.de

Re: [otrs] Stats-Module and problems with @Params

Renee Bäcker