Hi everyone,
Is there some way to include "Left Join" and "Inner Join" inside an expression rule with "a!queryEntity"?
Thanks,
Josue
Discussion posts and replies are publicly visible
Please go through below link. You will get basic understanding on how to create a view. www.w3resource.com/.../creating-view.php After creating the view , Create a Data type(CDT) for that view and map it to Data store. Create a Query entity based on your requirement.This would resolve your issue Thanks, Sindhu
I you don't want to create view between the tables we can achieve this using Execute Stored Procedure plugin where we can execute the SQL statements and it will return the result in dictionary.We can use this approach if the data volume is high.