Re: Search customers with a given telephone number ...

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

---------------------------------------------------------------------
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/

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.10 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/

iEYEARECAAYFAkxKlM8ACgkQvXo8m5PgoXQOJACfbXOUtE7ZopnGPdjMyZz2OMq+
gWwAnRe+RZ6kfRVsMrMwx8EAU8gWW+oR
=/sW8
-----END PGP SIGNATURE-----