Hi all, I have a view created via the DynamicViewEntity in a groovy script. This view of mine consist of few tables and another view which is declared in a entitymodel.xml in another module.
In one of the join, the link need to consist of relationship from 3 tables, i.e. select * from ((tableA a inner join tableB b on a.first_id = b.first_id ) inner join tableC c where a.one_id = c.one_id and b.two_id = c.two_id) Note that for the view link for the second inner join, i need to have alias for both tableA and tableB. I'd searched for a while and it seems that the workaround is by using entity-condition but in DynamicViewEntity there's no method for me to add that. Anyone has come across this issue before? Any advice or solution? Thanx FooShyn
