On Thu, 2004-06-17 at 16:12, Martin Edenhofer wrote:
Ok. Now. :)
Ok. This could be a problem if your database is case sensitive in where options. So you can remove lc() or add it to Kernel/System/Ticket.pm -> SearchTicket ~ line 1390 (so also all db customerid queries are lc). Ok, I see now. I think it's easier to remove the lc than add lower in SQL queries since they are spread all over - for example in Kernel/Modules/CustomerTicketOverView.pm, where you retrieve @ViewableTickets - this is where I started my exploration of the code.
PS: What database do you use?
Postgresql v 7.4.3
PS: The lc(id) in Ticket.pm is used to have unique customer_ids because perl is case sensitive. So as long as I'm sure there aren't conflicting (User / user / uSER) entries in LDAP I can take it out of there, right?
Jepp.
Ok, that clears it for me! Thanks, Iustin Pop ########################################### The information contained in this communication is confidential and may be legally privileged. It is intended solely for the use of the individual or entity to whom it is addressed and others authorized to receive it. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking action in reliance of the contents of this information is strictly prohibited and may be unlawful. Orange Romania SA is neither liable for the proper, complete transmission of the information contained in this communication nor any delay in its receipt. ###########################################