Hi,

In my db the customer login field is an integer, but apparently when otrs runs query on the customer_user table it uses the login field as text thus slowing down all the queries, for example:

WHERE LOWER(login) = LOWER('12345')'
How can i force otrs to use
WHERE login = 12345
?

Thanks


---------------------------------------------------------------------
OTRS mailing list: otrs - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/otrs
To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs

NEW! ENTERPRISE SUBSCRIPTION - Get more information NOW!
http://www.otrs.com/en/support/enterprise-subscription/

Reply via email to