While maintaining some JAX-WS Web Services I built using ADF Business Components (such as View Objects, Entity Objects, Application Modules, etc), I found a way to edit a View Object’s query without having a connection to the JDeveloper project’s database. This is useful for me because I work from home and do not always have easy access to the databases we work with, but still want to get a bit of work done, but it’s not quite obvious you can do this without directly editing the XML file.
To edit a ViewObject’s query offline:
- Open the View Object
- Go to the Query side tab
- Click the pencil icon above the query to open the query (you’ll be told you’re not connected– click OK)
- Make your changes and press Apply or OK.
- Here you’ll be told you’re not connected again, close the window by pressing X, but don’t click ok.