APAC SD Team
Category
Data Sources
Product Version
7.3
Need fexibility to define Joins as per requirement
Idea Logged
Hi Team,
Couple of our customers are facing issue while creating view for some complex Reports,
The view need to be crated by using mixed join condition, Left Right and Inner, In current view builder once we define Left outer join to the Driving Table (Main Table) then we cannot define Further inner join or Right Outer Joins.
It throws an error Table not joined correctly: XYZ
Eg;
This type of joins basically require to avoid record duplication.
Request you to check this requirement and let us know its feasibility.
Thanks,
Abhijeet
I like this idea 
Hi Abhijeet,
Yup, unfortunately this is a current limitation of the view builder as listed in our wiki
I do however understand this is a requirement for a few clients, so the enhancement has been created and planned for review later next year, as we are going to enhance the view builder model page.
Unfortunately until late next year it's hard to comment further on this.
Hope the current view builder (keeping in mind freehand SQL views are an option) is something that can be worked with in the meantime.
Thanks,
David
Hi Abhijeet,
Yup, unfortunately this is a current limitation of the view builder as listed in our wiki
I do however understand this is a requirement for a few clients, so the enhancement has been created and planned for review later next year, as we are going to enhance the view builder model page.
Unfortunately until late next year it's hard to comment further on this.
Hope the current view builder (keeping in mind freehand SQL views are an option) is something that can be worked with in the meantime.
Thanks,
David
Replies have been locked on this page!