So I've got the backend customer database thing working in OTRS, nice. Unfortunately, in the http-link in the Mapping I don't know what other $Data{'variables'} are available other than CustomerID. I also don't know how to set the customerID as the email address from the DB, which is my unique ID as well as login. Can I set CustomerID to the email address, or can I access the email address from the ticket or the Customer within OTRS so I can pass the email address back to OTRS to get the customer history in a single click? My current config: $Self->{CustomerUser} = { Name => 'Company', Module => 'Kernel::System::CustomerUser::DB', Params => { DSN => 'DBI:mysql:database=mydb;host=myhost', User => 'otrs', Password => 'xxx', Table => 'users', }, # customer uniq id CustomerKey => 'email', # customer # CustomerID => 'email', CustomerUserListFields => ['email','fn', 'ln', 'id'], CustomerUserSearchFields => ['email', 'ln', 'id', 'fn'], CustomerUserSearchPrefix => '', CustomerUserSearchSuffix => '*', CustomerUserSearchListLimit => 250, CustomerUserPostMasterSearchFields => ['email'], CustomerUserNameFields => ['fn','ln'], CustomerUserEmailUniqCheck => 1, # just a read only source ReadOnly => 1, Map => [ # note: Login, Email and CustomerID needed! # var, frontend, storage, shown (1=always,2=lite), required, storage-type, http-link, readonly [ 'UserFirstname', 'Name', 'concat(fn," ",ln)', 1, 1, 'var', '', 0 ], [ 'UserEmail', 'Search Tickets', 'email', 1, 1, 'var', '$Env{"CGIHandle"}?Action=AgentTicketSearch&Subaction=Search&From=$Data{"CustomerID"}', 0 ], [ 'UserCustomerID', 'Admin ID', 'id', 1, 1, 'var', 'http://myadminsite/?query=$Data{"CustomerID"}', 0 ], [ 'UserLogin', 'Search Tickets', 'email', 0, 1, 'var', '$Env{"CGIHandle"}?Action=AgentTicketSearch&Subaction=Search&From=$Data{"CustomerID"}', 0 ], ], }; --------------------------------------------------------------------------- Peter Beckman Internet Guy beckman@angryox.com http://www.angryox.com/ --------------------------------------------------------------------------- ** PLEASE NOTE PurpleCow.com IS NOW AngryOx.com DO NOT USE PurpleCow.com ** ** PurpleCow.com is now owned by City Auto Credit LLC as of May 23, 2007 ** ---------------------------------------------------------------------------