JQADM search with wildcard?

[columbo]

Hi,

is it possible to search for customers in the backend/jqadm using wildcards (*, %, etc.)?
(using PostgreSQL)

For example, a customer with a company name of "Super Test Company".

Search for "Super" (first term, correct case (S))
-> OK, result: "Super Test Company".

Search for:
"super" (s … case sensitive), or
'Test' (2nd term) , or
"Company" (3rd term)
-> no results

Are there any options to search for eg.: "%test%" in jqadm?

thank you!

[aimeos]

Overwrite the template in your own extension where you want to use a "%...%" based search and add "~=" as operator, e.g. here:
https://github.com/aimeos/ai-admin-jqad ... t.php#L191

Example:

Code: Select all

'customer.company' => ['op' => '~='],

This enables searching within the string but be aware that no index is used that it will be very slow when you have a lot of recoreds.