Hi Renee,
sorry, did:
sub Param {
...
my %UserList = $Self->{UserObject}->UserList(
Type => 'Short',
Valid => 0,
);
push (@Params, {
Frontend => 'User',
Name => 'UserList',
Multiple => 0,
Size => 0,
#SelectedID => $U,
Data => {
%UserList,
},
},
);
}
sub Run {
...
my $User = $Param{UserList};
...
}
but it still doesn´t work... /var/log/otrs.log:
[Wed Aug 26 09:26:28
2009][Error][Kernel::System::Stats::Static::AccountingPerAgent::Run][145] You
have an error in your SQL syntax; check the manual that corresponds to your
MySQL server version for the right syntax to use near ')
)' at line 19, 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 ) = 7
AND year( ta.change_time ) =
2009
)
AND (
t.queue_id IN ( 5, 6, 8, 9, 10,
11, 12 )
)
AND (
u.login =
)
)'
-------- Original-Nachricht --------
> Datum: Wed, 26 Aug 2009 09:18:31 +0200
> Von: "Renee Bäcker" <[email protected]>
> An: "User questions and discussions about OTRS." <[email protected]>
> Betreff: Re: [otrs] Stats-Module and problems with @Params
> Hi Guenther,
>
> you already posted the code where you defined the Variable %UserList,
> but that is irrelevant. The important part for the HTML form creation is
> what's in @Params.
>
> There you have
>
> >
> > push (@Params, {
> > Frontend => 'User',
> > Name => 'User',
> > Multiple => 0,
> > Size => 0,
> > Data => {
> > %UserList,
> > },
> > },
> > );
>
>
> This adds a field to the form where the field has a label 'User'
> (Frontend => 'User'). The name of the field is also 'User' (Name =>
> 'User'). The is the name of the parameter that the request sends to the
> script.
>
> You have two ways to make your script work:
>
> Either
>
> push @Params, {
> Frontend => 'User',
> Name => 'UserList',
> ...
> }
>
> *OR*
>
> my $User = $Params{User};
>
>
> Cheers,
> Renée
>
>
> Please use the Bind mechanism I described in my last mail...
>
> --
>
> Perl-Magazin: http://perl-magazin.de
> Perl-Nachrichten: http://perl-nachrichten.de
> ---------------------------------------------------------------------
> OTRS mailing list: otrs - Webpage: http://otrs.org/
> Archive: http://lists.otrs.org/pipermail/otrs
> To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs
>
> NEW! ENTERPRISE SUBSCRIPTION - Get more information NOW!
> http://www.otrs.com/en/support/enterprise-subscription/
--
GRATIS für alle GMX-Mitglieder: Die maxdome Movie-FLAT!
Jetzt freischalten unter http://portal.gmx.net/de/go/maxdome01
---------------------------------------------------------------------
OTRS mailing list: otrs - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/otrs
To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs
NEW! ENTERPRISE SUBSCRIPTION - Get more information NOW!
http://www.otrs.com/en/support/enterprise-subscription/
