Search found 58 matches
- 25 Nov 2022, 12:01
- Forum: Laravel package
- Topic: filter product id by pattern matching =~
- Replies: 9
- Views: 1582
Re: filter product id by pattern matching =~
Are you suggesting modifying the the aimeos core???
Is there any other way without modifying it?
Is there any other way without modifying it?
- 24 Nov 2022, 03:38
- Forum: Laravel package
- Topic: filter product id by pattern matching =~
- Replies: 9
- Views: 1582
Re: filter product id by pattern matching =~
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?
From my sample screenshot sql statement, I wonder how to do this in Aimeos?
- 22 Nov 2022, 04:19
- Forum: Laravel package
- Topic: filter product id by pattern matching =~
- Replies: 9
- Views: 1582
Re: filter product id by pattern matching =~
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...
- 18 Nov 2022, 03:10
- Forum: Laravel package
- Topic: filter product id by pattern matching =~
- Replies: 9
- Views: 1582
Re: filter product id by pattern matching =~
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.
- 16 Nov 2022, 04:37
- Forum: Laravel package
- Topic: filter product id by pattern matching =~
- Replies: 9
- Views: 1582
filter product id by pattern matching =~
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...
- 11 Oct 2022, 10:13
- Forum: Laravel package
- Topic: Filter Group By or DISTINCT column
- Replies: 4
- Views: 844
Re: Filter Group By or DISTINCT column
Yap I found a way. Thank you.
- 06 Oct 2022, 08:15
- Forum: Laravel package
- Topic: Filter Group By or DISTINCT column
- Replies: 4
- Views: 844
Re: Filter Group By or DISTINCT column
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 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?
- 05 Oct 2022, 10:55
- Forum: Laravel package
- Topic: Filter Group By or DISTINCT column
- Replies: 4
- Views: 844
Filter Group By or DISTINCT column
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...
- 14 Sep 2022, 07:46
- Forum: Laravel package
- Topic: Make filter in back-end not case sensitive ?
- Replies: 16
- Views: 3268
Re: Make filter in back-end not case sensitive ?
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..
Seems like there is no other ways if we don't removed the saved products.
Thanks you..
- 12 Sep 2022, 06:16
- Forum: Laravel package
- Topic: Make filter in back-end not case sensitive ?
- Replies: 16
- Views: 3268
Re: Make filter in back-end not case sensitive ?
Yes, I did those codes and more but I still have no luck.
Any idea why this is causing issue or a solution to change data type?
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?