bea.com | products | dev2dev | support | askBEA |
![]() |
![]() |
|
![]() |
e-docs > Liquid Data for WebLogic > Building Queries and Data Views > Saving a Query |
Building Queries and Data Views
|
From the Test tab, you can save a query by choosing File—>Save Query from the menus or by clicking on the Save Query button on the toolbar.
You can save the query to a file on a local folder or other location on the network, or you can save the query to the Liquid Data server Repository in the stored_queries folder as described in the following section.
Note: Query files must be saved with a .xq extension. If you do not specify an extension, the Data View Builder automatically appends the .xq extension to the filename when the query file is saved.
Saving a Query to the Repository as a "Stored Query"
If the query is saved into the stored_queries folder in the Liquid Data server Repository, it becomes a stored query in Liquid Data. There is a performance benefit to using stored queries in Liquid Data in that the query plan is automatically cached in Liquid Data and you have the option to configure caching on the query result as well. For more information about using stored queries, see Stored Queries in Overview and Key Concepts.
To create a stored query do the following:
You can reload a stored query using the Data View Build File : Open Query command. You may need to navigate to the directory containing your stored queries.
Once a stored query has been loaded, it can be run. See Running the Query for details.
Naming Conventions for Stored Queries
(For information on how to generate a Web service from a stored query, see Generating and Publishing Web Services in the Liquid Data Administration Guide.)
![]() |
![]() |
![]() |
![]() |
||
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |