Query block "user role" did not work when turnon on "frontend rendering"

would suggest you take a look the author report with this together:

Query Woocommerce Products by Author - Feature Requests - Cwicly

hopefully, can find some thing useful.