I created an EAV attribute on product entity, this attribute named user_id
and has the ID of the user who's added the product.
After works, I crashed on this point, I need to join tables to get products added by a specific user.
So, I try with this code
->join(
array(
'product' => 'catalog_product_entity'),
'product.user_id = 2',
array()
);
but always I get this error Unknown column 'user_id'
is there any solution?