Click these buttons for demos of how to use Liquid Data
to build and test queries. For more about using the Data View Builder
query-building tool to build, optimize and test queries see, Getting
Started and Building Queries and
Data Views. For more about using Liquid Data to generate a Web Service
from a stored query, see Generating
and Publishing Web Services in the Administration Guide.
|
Shows how to build the Customer Order Report
query, which fetches customer orders in both Broadband and Wireless
data sources for a given customer ID. Then, once the query is tested
and deployed, shows how to use WebLogic Workshop to build a web
application which displays the results of the query. A complete
description of how to build this query and web application is in the Getting Started guide.
|
|
Given first and last name for a customer, find
their orders in both Broadband and Wireless data sources. Demonstrates
use of two different join conditions. Includes examples of using
optimization hints. A complete description of how to build the
Simple Joins example query is in the Query
Cookbook.
|
|
For a given customer ID, find the number of
orders placed across two data sources. Uses a data view as one
of the data sources. Demonstrates use of the "count" function.
A complete description of how to build the Aggregates example query
is in the Query Cookbook.
|
|
Find out if a given customer has open orders
scheduled to ship before a specified date. Demonstrates use of "date-from-string-with-format" function.
Includes an example of setting scope for a condition. A complete
description of how to build the Date and Time Duration example
query is in the Query Cookbook.
|
|
For a given customer ID, find details on customer
orders across two data sources. Use a union to retrieve
results from subordinate queries on each data source and concatenate
the results. A complete description of how to build the Union example
query is in the Query Cookbook.
|
|
Create a minus relationship (A-B) that
returns all instances that are in data source "A" but not in data
source "B". Includes an example of setting scope. A complete description
of how to build the Minus example query is in the Query
Cookbook.
|
|
Shows how to use Liquid Data to generate a Web
service from a stored query. Also demonstrates how to test the
query in BEA WebLogic Workshop. For a complete description of how
to use Liquid Data to generate a Web service, see the topic Generating
and Publishing Web Services in the Administration Guide.
|
|
Shows how to use Liquid Data to access a database
stored procedure and use the stored procedure in a query. For a
complete description of how to use stored procedures with Liquid
Data, see the topic Defining
Stored Proecdures in Building Queries and Data Views.
|
|
Shows how to use Liquid Data to access a user-defined
complex parameter type in a query. The complex parameter type represents
a real-time data stream, such as an order currently being placed.
For a complete description of how to use complex parameter types
with Liquid Data,
see the topic Using Complex Parameter Types in Building
Queries and Data Views.
|