[otrs] Stats-Module and problems with @Params

26 Aug 2009

      Hi,

I´m trying to get some static statistics working.
I want to select all the time an agent has accounted
within a specific time.

It works fine, if I don´t select the agent with this:
my $Select = "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 )
                                        )
                                )";

So, I just added "AND (u.login = $User)" to my statement,
before, I´ve added:

    my %UserList = $Self->{UserObject}->UserList(
        Type => 'Short',
        Valid => 0,
    );

    push (@Params, {
            Frontend => 'User',
            Name => 'User',
            Multiple => 0,
            Size => 0,
            Data => {
                %UserList,
            },

and in sub Run():

my $User = $Param{UserList};

but it fails, cause $User is empty, why?:
...
                                        AND (
                                                t.queue_id IN ( 5, 6, 8, 9, 10, 11, 12 )
                                        )
                                        AND (
                                                u.login =
                                        )
...

Regards 
Guenther

-- 
Neu: GMX Doppel-FLAT mit Internet-Flatrate + Telefon-Flatrate
für nur 19,99 Euro/mtl.!* http://portal.gmx.net/de/go/dsl02

[otrs] Stats-Module and problems with @Params

Petrucci