We have a requirement wherein we need to create a VL with LEFT OUTER join type. The two vos participating in this vl are generated with declarative mode (SQL Mode=Declarative selected in the query panel of these vos). Problem is that ADFBC not allowing to add outer join type on vl (basically the query portion of the vl is greyed out) when the participating vos are of declarative type. When SQL Mode changed to "Normal" on vos then query portion in the vl gets enabled and we can add left outerjoin.
Can anyone tell how to create a VL with LEFT OUTER join between declarative mode vos?
Answered by Steve Muench
Here is the email response I got from Steve.
There is no way in ADF to mark a view link as a left-outer join type.
For your specific requirement, all need to be done is add a custom property on VL:
Property name: BI_JOINTYPE with either of these values.
LEFTOUTER | RIGHTOUTER | FULLOUTER | INNER
Edited by: Eshwar Mekala on Feb 8, 2010 1:58 PM
Edited by: Eshwar Mekala on Feb 8, 2010 2:03 PM
Edited by: Eshwar Mekala on Feb 8, 2010 2:06 PM
To add a custom property on a view link, open the link in the editor and scroll down in the General tab to custom properties. Click the green plus to add the property. This property is apparently an implicit property for view links.
Hope that helps,
We had a view link containing outer join syntax but it broke when we attempted to change the linked view to use ANSI joins because you can't combine the Oracle(+) syntax with ANSI "OUTER JOIN" join syntax. I'm guessing we can't use an outer join view link with a view configured to use ANSI joins. Is that the case?