Hi all,
I have to get OTRS to work with a web-based asset register. Particularly, we
need to the ability to assign each OTRS ticket to an asset. My approach has
been to stuff the TicketFreeKey1 and TicketFreeText1 with AssetIDs from our
asset database from within Config.pm...
....
$Self->{"TicketFreeKey1"} = {
'AsssetID' => 'AssetID',
};
.... # connect to asset DB using DBI
while( $resptr = $rs->fetchrow_hashref() )
{
$Self->{"TicketFreeText1"}{ $row->{"AssetID"} } = $row->{"Desc"} ;
}
....
The trouble is that with 2000 rows in the table, there is a huge overhead on
every page hit for what is only needed on a few entry screens.
Can anyone please suggest a better place to put this code so that it only has
to run once for each users session, and where the variables
$Self->{"TicketFreeKey1"} and $Self->{"TicketFreeText1"} can still be 'seen'
in the necessary pages?
Many thanks!
Nigel
_______________________________________________
OTRS mailing list: dev - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/dev
To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/dev
