Unable to fetch toOne attributes when using filterManyRaw for filtering

[cchjgood]

With this query, the items.material object is null/empty.

SaleOrderEntity saleOrder=dao.find(SaleOrderEntity.class)
.fetch("items")
.fetch("items.material")
.fetch("items.orderBExc")
.where()
.idEq(event.getData().getPrimaryKey())
.eq("dr","N")
.eq("cstatus", EBillStatus.APPROVE)
.filterManyRaw("items","orderBExc.num-orderBExc.sendnum-orderBExc.outstocknum>0")
.findOne();

[rbygrave]

Have you looked at the generated sql that is executed?
Does this produce 1 sql query or 2 sql queries? [Are the items fetched in a separate sql query?]
Does it look like the correct sql / sql that you expected?
When you run it manually does it produce the result you expect?