DevPortal

How do I use Query Viewer?


To open Query Viewer, click a bean node in Deploy Tool, select the Finder Queries tab, and click Import. This displays the Designed Queries and the Generated SQL for the same.

Choose the name of the desired query from Designed Queries. The query is displayed in the Generated SQL. It is a good idea to first define a set of queries that are likely to be used in finder methods. You can delete queries by clicking Delete.

How do I import Queries?

When you click Import in the Query Viewer panel, the Import Queries dialog box opens. Browse and import queries from a remote queries.props into the local props file that contains the query you want to import. This is useful for transferring queries written earlier to a deployment site or while relocating .ears.

Click OK. A query that is imported for the first time is displayed in blue in the Import Query dialog box along with the generated SQL statement.

Note: Duplicate queries cannot be imported into the Deploy Tool.

Related Topics:

© Pramati Technologies 2007 Runs on Pramati Server | Feedback | Legal