Search customers with a given telephone number ...
I need to search the customer database table based on a given telephone
number.
However, I notice that the Kernel::System::CustomerUser object method
CustomerSearch() only supports one of the following search
possibilities:
Search, UserLogin and PostMasterSearch
Is there any easier way to accomplish this rather than having to make
lower level DBObject calls to search the 'customer_user' table based on
the 'phone' value, e.g.
$DBObject->Do( SQL => "SELECT * FROM customer_user WHERE phone =
'012345678'" );
I see that there is a non-trivial way to configure searches in general
to include more fields, but this is more complicated and will make the
changes globally, whereas I want to limit this search to a specific
situation.
Thanks in advance for the extra help.
Regards,
Kiffin
--
Kiffin Gish
Hi there, Am 23.07.2010 14:38, schrieb Kiffin Gish:
I need to search the customer database table based on a given telephone number.
However, I notice that the Kernel::System::CustomerUser object method CustomerSearch() only supports one of the following search possibilities:
Search, UserLogin and PostMasterSearch
Is there any easier way to accomplish this rather than having to make lower level DBObject calls to search the 'customer_user' table based on the 'phone' value, e.g.
...just add the telephone-number attribute to the customer backends search fields - e.g.: CustomerUserSearchFields => [ 'login', 'first_name', 'last_name', 'customer_id', 'telephonenumber' ], ...et voila - you're now able to search the customer by it's telephone number :-). regards, Torsten Thau -- Torsten Thau, Dipl. Inform. c.a.p.e. IT Labs GbR - Annaberger Str. 240 - D-09125 Chemnitz phone: +49 371 5347 623 cell: +49 176 66 680 680 personal pgp-key: 0x93E0A174 fax: +49 371 5347 625 http://www.cape-it.de
Yes indeed this is a possible solution. However, I want to search on the telephone number only and limited to the duration of the call. On Sat, 2010-07-24 at 09:22 +0200, Torsten Thau wrote:
Hi there,
Am 23.07.2010 14:38, schrieb Kiffin Gish:
I need to search the customer database table based on a given telephone number.
However, I notice that the Kernel::System::CustomerUser object method CustomerSearch() only supports one of the following search possibilities:
Search, UserLogin and PostMasterSearch
Is there any easier way to accomplish this rather than having to make lower level DBObject calls to search the 'customer_user' table based on the 'phone' value, e.g.
...just add the telephone-number attribute to the customer backends search fields - e.g.:
CustomerUserSearchFields => [ 'login', 'first_name', 'last_name', 'customer_id', 'telephonenumber' ],
...et voila - you're now able to search the customer by it's telephone number :-).
regards, Torsten Thau
--------------------------------------------------------------------- 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
NEW! ENTERPRISE SUBSCRIPTION - Get more information NOW! http://www.otrs.com/en/support/enterprise-subscription/
--
Kiffin Gish
Hi, Am 24.07.2010 17:43, schrieb Kiffin Gish:
Yes indeed this is a possible solution. However, I want to search on the telephone number only and limited to the duration of the call.
OK, this is some new information. Condition 1 could be met easily by adding an additional customer backend configuration with only one search field (phone) [1]. Condition 2 requires a more sophisticated solution and somehow depends on how the duration of the call is defined and meassured (automatically), regards, Torsten [1] Alternatively a similar function is implemented in KIX4OTRS (f.k.a. OTRS::CiCS) - it allows to configure "further search fields" which appear as separate inputs for customer user search - right now only in a customer history module (AgentCustomerHistory), but not in AgentTicketPhone or AgentTicketEmail. -- Torsten Thau, Dipl. Inform. c.a.p.e. IT Labs GbR - Annaberger Str. 240 - D-09125 Chemnitz phone: +49 371 5347 623 cell: +49 176 66 680 680 personal pgp-key: 0x93E0A174 fax: +49 371 5347 625 http://www.cape-it.de
participants (2)
-
Kiffin Gish -
Torsten Thau