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?
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.
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?