Pattern matching in search/filter

[kartikbhat]

I need to change filter/search term "==" to "%LIKE%" kind of pattern matching while query;
Here I have comparison with "==" operator on themes field of products table

Code: Select all

$products = \Aimeos\Controller\Frontend::create( $context, 'product' )

				->sort( $sort ) // prioritize user sorting over the sorting through relevance and category

				->compare( '==', 'themes', $view->param( 'f_theme' ) )

I need to make this thing should work with %LIKE% kind of pattern (substring/subpart of value present at theme field of products table)

How can I modify above code to work it properly...

TIA

[aimeos]

Use the "~=" operator: https://aimeos.org/docs/latest/models/s ... r/#compare