Help for Aimeos

Are you suggesting modifying the the aimeos core???
Is there any other way without modifying it?

Yap seems like but this is our requirements once a user search for id "1" it should be able to display id starting with 1.
From my sample screenshot sql statement, I wonder how to do this in Aimeos?

Ok this is the log output after searching "2" after searching 27 orders Time: 2.9537677764893ms Class: Aimeos\MShop\Order\Manager\Standard SELECT COUNT( DISTINCT mord."id" ) AS "count" FROM "mshop_order" AS mord LEFT JOIN "mshop_order_base" AS mordba...

ss1.jpg I am not sure where to set the loglevel = 7. Is that correct? I would like to emphasize that there were no error while searching using =~ in order.id but why it will only return one exact match? But if I tried it with string filter =~ to a string column would return the correct expect values.

I am using laravel 6.x, PHP 7.4, Docker desktop/Ubuntu and the Aimeos 2021 (aimeos-laravel: 2021.10.4 / aimeos-core: 2021.10.13) I would like to make a filter product.id using =~ like search for '1' should return like '1', '111', '123' etc. I tried $search = $manager->filter( false, true )->add( 'or...

Yap I found a way. Thank you.

Thank you that was working but not as I wanted because it only return an array of customerid and qty it exist.
I would like to get the rows of orderbase those customerid have existed?
Is there a way to filter orderbase table based from the returned aggregated values?

I am using laravel 6.x, PHP 7.4, Docker desktop/Ubuntu and the Aimeos 2021 (aimeos-laravel: 2021.10.4 / aimeos-core: 2021.10.13) I have a question about model manager filtering in https://aimeos.org/docs/2021.x/models/search-filter/ I would like to know how can I make a filter like a group by or DIS...

Thank you that works after we have to remove all of the products.
Seems like there is no other ways if we don't removed the saved products.

Thanks you..

Yes, I did those codes and more but I still have no luck. I believe that changeColumn() is to set the properties if not changing the data type and setType to change data type.
Any idea why this is causing issue or a solution to change data type?