I have a view that diplays some orders with a filter by current user if he is owner of the order or not ..
If the current user is admin, i can see my orders with no problems. If im logged in with another role the view is always empty althought im ordering products with that user.
I doubt about the view access, or some modules permission (for example if this role has the permission to view his own orders or if he has permission to view his own product ...) I checked these permissions carefully, but the view result still empty.
when I debug the query I get inside where clause an additional condition that's applyed only for non admin users :
(AND 1 = 0)
as you know this condition returns always false, so that's why the result of the query is empty.
Is there a way to know from where is coming this condition when im logged in with a non admin role ?
Thanks in advance.