You can do following after selecting a where condition. To perform any of the following task, select a where condition and in the Where Condition Details page, click the respective button:
Generate View - To generate the database view. A complex definition might take little longer to generate the view. All the views that are generated take a prefix MV_WHERE_ followed by a sequence number.
-
If the view is not generated or is not valid, the where does not condition. Check the validity of the view in the View Status field.
-
Changes to the where condition make the view invalid. You must regenerate the view to validate by clicking Generate View button.
Drop View - To drop the view.
Count - To count the number of items found in the database that match the where condition. A complex Where condition might take little longer to generate the count.
Results - To look at the internal representation of the data in the result set.
Show SQL - To check the generated SQL command text for any errors encountered.