Hi, I wrote a small function selecting DISTINCT customer_id. It works just fine. I've written a module called "AgentTicketOverView.pm", now i want to replace QueueView as the default view when an Agent logs into OTRS. How? Can this be done by config or can change something simple in Interface.pm or index.pl? I really appreciate the help so far! regards, Simon Martin Edenhofer wrote:
Hi Simon,
Simon A. F. Lund wrote:
Thx for the reply! It works just fine now.
Fine!
I would also like to get a list of all the customers, i've tried with CustomerIDs but all i get there is customer logins. I need the actual CustomerIDs. The one from `customer_id`. Which function can i use?
There is no function to get all uniq CustomerIDs from the ticket table. Because customer_id and customer_user_id is just a link to a customer source (db backend, ldap backend or other backends).
Btw why is aren't there a table called `customers` where you could store the customers and let the customer_user.customer_id have a reference to this table? This is great when you integrate otrs with other software like CRM systems. Plus you could add some info about the customer (the address of the firm. primary contact, etc. ) and let the info in customer_user only be about the actual user.
It's because we want also to support different customer backends (DB, LDAP, SAP, ...).
But anyway, if you have a good idea/patch, feel free to discuss it. :-)
safl
Martin
-- ((otrs)) :: OTRS GmbH :: Norsk-Data-Str. 1 :: 61352 Bad Homburg http://www.otrs.de/ :: Manage your communication!
_______________________________________________ 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