Click these buttons for demos of how to use Liquid Data to build and test queries.
For more about using the Data View Builder mapping 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 Order query featured in the Avitek Sample. For a given customer ID, view
customer orders in both Broadband and Wireless data sources. Introduces the concept of a join. Includes examples of using both a hard-coded constant and a query parameter for the customer ID.
A complete description of how to build this query 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.
|