view-entity subquery WHERE clauses supported?

Posted by Christian Carlow-OFBizzer on
URL: http://ofbiz.116.s1.nabble.com/view-entity-subquery-WHERE-clauses-supported-tp4643984.html

Does anyone know if it is possible to constrain joined view-entity
subqueries with their own WHERE clauses?

For example:

select * from tbl1 left join (select * from tbl2 where tbl2.col1 =
'someVal') tbl3 on tbl1.col1 = tbl3.col1