Additional columns of join table during search query

Help for integrating the Laravel package
Forum rules
Always add your Laravel, Aimeos and PHP version as well as your environment (Linux/Mac/Win)
Spam and unrelated posts will be removed immediately!
User avatar
dheeraj
Posts: 26
Joined: 02 Jan 2021, 08:47

Additional columns of join table during search query

Post by dheeraj » 09 Jun 2021, 07:45

Laravel : 8.12
Aimeos : 2021.04
PHP Version : 7.4.18
Environment : Windows


Hello there.

I am searching for stock items whose mshop_stock.stocklevel is below certain threshold (fixed value) but i also want to perform inner join on the products table ( on mshop_stock.prodid = mshop_product.id ) and include the columns mshop_product.code and mshop_product.label in the result so that i can know which stocks are referring to which product.
How can add these additional columns of join table during search query ??

Thanks

User avatar
aimeos
Administrator
Posts: 7926
Joined: 01 Jan 1970, 00:00

Re: Additional columns of join table during search query

Post by aimeos » 10 Jun 2021, 11:14

You are asking the almost the same question as in your previous thread regarding that topic and the answer is still the same:
help-f15/how-to-hide-unique-products-in ... t1104.html
Professional support and custom implementation are available at Aimeos.com
If you like Aimeos, Image give us a star

Post Reply