Changing View Link SQL

You can edit a view link definition to change the parametrized WHERE clause that will be appended to the destination view object's query. For more information, see About Oracle ADF View Links.

Warning: If you change view link SQL, you will not be able to make the view link bidirectional. That is, you will not be able to use it to make an instance of the source view object a detail of an instance of the destination view object. For more information, see the related topics list.

To change view link SQL:

Open the View Link Editor by doing one of the following:
- In the System or Application Navigator, right-click the view link definition and choose E dit.
- On a diagram, right-click the modeled view link and choose Properties. For more information on modeling business components, see About Modeling Business Components.
Select the View Link SQL node.
Enter the parametrized WHERE clause in the W here area. If you need further assistance, click Help.