Hello Prashant ,
You can refer following code to create dynamic view entity .
DynamicViewEntity dynamicView = new DynamicViewEntity();
dynamicView.addMemberEntity("PCM", "ProductCategoryMember");
dynamicView.addAliasAll("PCM", "")
dynamicView.addMemberEntity("PP", 'ProductPrice');
dynamicView.addAliasAll("PP" , "")
dynamicView.addViewLink("PCM", "PP", Boolean.TRUE,
ModelKeyMap.makeKeyMapList("productId"));
>
>
> pcm.product_id = pp.product_id AND price BETWEEN 15 AND 20)
> WHERE pcm.product_category_id IN ('100', '101')
For this put condition on dynamic view entity (for reference prefer
findParty service)
--
Awdesh Parihar