Oracle JDeveloper 11gR2 Cookbook

Setting the Queryable property of a view object attribute programmatically

The Queryable property, when set for a view object attribute, indicates that the specific attribute can appear on the view object's WHERE clause. This has the effect of making the attribute available in all search forms and allows the user to search for it. In an af:query ADF Faces component, for instance, a queryable attribute will appear in the list of fields shown when you click on the Add Fields button in the Advanced search mode. Declaratively you can control whether an attribute is queryable or not by checking or un-checking the Queryable checkbox in the view object Attributes | Details tab. But how do you accomplish this task programmatically and for specific ...