[Solved] Search Index when using search for customer/customer user

[Snowmanko]

Hi,
I just want to ask what setting define which fields are searched when searching is triggered within "Customer - Customer Information Center" from main menu. There are two possibilities for search - Customer and Customer User.

I want to set only one column in DB that is indexed to search for. We have really huge DB of Customers and searching non indexed fields totally kills DB backend.

I can see in DB trace when I start typing Customer name it triggers queries like this: (this queries run in parallel)

SELECT DISTINCT(customer_id) FROM customer_user WHERE 1 = 1 AND valid_id IN (1) AND ((customer_id LIKE '123%' ) )
SELECT DISTINCT(customer_id) FROM customer_user WHERE 1 = 1 AND valid_id IN (1) AND ((customer_id LIKE '1234%' ) )
SELECT DISTINCT(customer_id) FROM customer_user WHERE 1 = 1 AND valid_id IN (1) AND ((customer_id LIKE '12345%' ) )
SELECT DISTINCT(customer_id) FROM customer_user WHERE 1 = 1 AND valid_id IN (1) AND ((customer_id LIKE '123456%' ) )

This is total overkill for DB. Parameter CustomerID => in $Self->{CustomerUser} will change column in DISTINCT(...), that is correct. But is it possible to set somehow minimal number of characters in search input before it will trigger these queries?

Thanks,
BR!

[Snowmanko]

Solved - viewtopic.php?f=62&t=23679&p=93381&hili ... ers#p93381
https://dev.ib.pl/ib/otrs/commit/7aa706 ... e13df67b18