Launch the Dynamic View Object page by selecting the Create button from the Model Personalization page.

Use the Dynamic View Object page to create a new or edit an existing dynamic view instance.

1. Specify a name for the view instance.

2. Enter the SQL query for the view instance. Any error in the SQL query will display once you tab out of the field. Correct the error before proceeding.

   Attention: The maximum length for a dynamic view object SQL query is 4000 characters.

3. The Where Clause Parameters table populates with bind indices if the SQL query contains bind parameters. You may specify the bind parameters using any of the supported Expression Language (EL) syntax described in the Personalizing EL-supporting Properties section of the Personalize Page. For example, to specify a simple bind parameter to a view attribute in a view instance, use the EL syntax:

   Example

   ${oa.<viewInstanceName>.<viewAttributeName>}

   Example

   as in

   ${oa.EMPVO1.Empno}

4. The View Attributes table displays each attribute's name and data type.

5. Check Enabled to allow the creation of the view instance. If the creation of the view instance causes a runtime error, you should uncheck Enabled so you can debug the error.

6. Check Execute Query to allow the framework to execute the view object query. If you want the view object query to be executed from custom code, you should uncheck Execute Query.

7. Select Apply to save the dynamic view instance and display the view instance information in the Model Personalization page.