Contents for Liquid Data by Example
Understanding the Avitek Customer Self-Service Sample Application
About Avitek
Quick Start
Introduction
Case for an Avitek Self-Service Web Site
Design Requirements
Information Technology (IT) Comes On Board: The Moment of Truth
Search for an Alternative
A Solution
Anatomy of the Avitek SampleApp
Finding the Components
Analyzing the SampleApp Architecture
Steps Used in Developing the SampleApp
Available Data Sources
Avitek Customer Self-Service Sample Application Queries
Running the Avitek Customer Self-Service Sample Application in a Browser
SampleApp Home Page
Order Search
Viewing the Avitek Customer Self-Service Sample Application Source
WebLogic Workshop Components of the SampleApp
Liquid Data Control
Application Pages
Application Logic: Page Flow
Inter-page Navigation
Pagination
Data Binding
Ad Hoc Query
Page from the SampleApp
Summary
Where To Go From Here
Query Cookbook
Example 1: Simple Joins
The Problem
The Solution
View a Demo
Ex 1: Step 1. Verify the Target Schema is Saved in Repository
Ex 1: Step 2. Open Source and Target Schemas
Ex 1: Step 3. Map Nodes from Source to Target Schema to Project the Output
Ex 1: Step 4. Create a Query Parameter for a Customer ID to be Provided at Query Runtime
Ex 1: Step 5. Assign the Query Parameter to a Source Node
Ex 1: Step 6. Join the Wireless and BroadBand Customer IDs
Ex 1: Step 7. View the XQuery and Run the Query to Test it
Ex. 1: Step 8. Verify the Result
Example 2: Retrieving Information
The Problem
The Solution
Open Data Sources and Add a Target Schema
Map Elements from Source to Target Schema to Project Output
Join Two Sources
Specify the Order of the Result Using the Sort By Features
View and Run the Query
Example 3: Aggregates
The Problem
The Solution
View a Demo
Ex 3: Step 1. Configure the "AllOrders" Stored Query as a Data View
Ex 3: Step 2. Restart the Data View Builder and Find the New Data View
Ex 3: Step 3. Verify that the Target Schema is Saved in the Repository
Ex 3: Step 4. Open the Data Sources and Target Schema
Ex 3: Step 5. Map Source Nodes to Target to Project the Output
Ex 3: Step 6. Create Two Query Parameters to be Provided at Query Runtime
Ex 3: Step 7. Assign the Query Parameters to Source Nodes
Ex 3: Step 8. Add the Count XQuery Function
Ex 3: Step 9. Verify Mappings and Conditions
Ex 3: Step 10. View the XQuery and Test by Running the Query
Ex 3: Step 11. Verify the Result
Example 4: Date and Time Duration
The Problem
The Solution
View a Demo
Ex 4: Step 1. Verify the Target Schema is Saved in Repository
Ex 4: Step 2. Open Source and Target Schemas
Ex 4: Step 3. Map Source to Target Nodes to Project the Output
Ex 4: Step 4. Create Joins
Ex 4: Step 5. Create Two Query Parameters for Customer ID and Date to be Provided at Query Runtime
Ex 4: Step 6. Set a Condition Using the Customer ID
Ex 4: Step 7. Set a Condition to Determine if Order Ship Date is Earlier or Equal to a Date Submitted at Query Runtime
Ex 4: Step 8. Set a Condition to Include Only "Open" Orders in the Result
Ex 4: Step 9. View the XQuery and Run the Query to Test it
Ex 4: Step 9. Verify the Result
Example 5: Union
The Problem
The Solution
View a Demo
Ex 5: Step 1. Verify the Target Schema is Saved in Repository
Ex 5: Step 2. Open Source and Target Schemas
Ex 5: Step 3. Clone the Orders Element of the Target Schema
Ex 5: Step 4. Create a Query Parameter for a Customer ID
Ex 5: Step 5. Assign a Query Parameters
Ex 5: Step 6. Define Source Relationships
Ex 5: Step 7. Project the Output to the Target Schema
Ex 5: Step 8. View, then Run the Query
Ex 5: Step 9. Verify the Result
Example 6: Minus
The Problem
The Solution
View a Demo
Ex 6: Step 1. Verify the Target Schema is Saved in Repository
Ex 6: Step 2. Open Source and Target Schemas
Ex 6: Step 3. Find BroadBand and Wireless Customers with the Same Customer ID
Ex 6: Step 4. Find the Count of the Wireless Customers
Ex 6: Step 5. Set a Condition that Specifies the Output of "count" is Zero
Ex 6: Step 6. View the XQuery and Run the Query to Test it
Ex 6: Step 7. Verify the Result
Example 7: Complex Parameter Type (CPT)
The Problem
The Solution
View a Demo
Ex 7: Step 1. Verify the Availability of Schemas and Sample Data Stream
Ex 7: Step 2. Open the Target Schema and CO-CPTSAMPLE CPT
Ex: 7: Step 3. Create an orderLimit Query Parameter
Ex 7: Step 4. Save the Project
Ex 7: Step 5. Test Access to the Complex Parameter Source
Ex 7: Step 6: Determine the Total Amount of New Orders
Ex 7: Step 7. Create the Necessary Joins and Mappings to the Target Schema
Ex 7: Step 8. Determine the Amount of Currently Open Orders
Ex 7: Step 9: Determine the Total Amount of All Open and New Orders
Ex 7: Step 10: Test If Open Orders + New Orders Exceeds the Order Limit
Ex 7: Step 11: Determine If the Order is Accepted or Rejected
Ex 7: Step 12: View the XQuery
Ex 7: Step 13. Run the XQuery to Verify the Result
Samples Installed with Liquid Data
Simple Liquid Data Queries
DB-XML Sample Query
What This Query Demonstrates
How to Run the Query
If You Want to Recreate the Query ...
References
Data Transformation Sample Query
What This Query Demonstrates
How to Run the Query
If You Want to Recreate the Query ...
References
DB-DB Sample Query
What This Query Demonstrates
How to Run the Query
If You Want to Recreate the Query ...
References
Complex Parameter Type (CPT) Sample Queries
DB-CPT Sample Query
What This Query Demonstrates
How to Run the Query
If You Want to Create a Query that Uses a Complex Parameter Type (CPT)
References
DB-CPTCO Sample Query
What This Query Demonstrates
How to Run the Query
If You Want to Create a Query That Use a Complex Parameter Type
References
Data View Sample Queries
Simple Data View Sample Query
What This Query Demonstrates
How To Run the Query
If You Want to Recreate the Query ...
References
Parameterized Data View Sample Queries
pviewSample
pviewSample1
Application View Sample Queries
DB-AppView (Three Data Source) Sample Query
What This Query Demonstrates
How to Run the Query
If You Want to Recreate the Query ...
Reference
DB-AppView (Two Data Source) Sample Query
What This Query Demonstrates
How to Run the Query
If You Want to Recreate the Query ...
References
Miscellaneous Samples
Stored Procedure Sample Query
What This Query Demonstrates
How to Run the Query
If You Want to Create a Query That Uses Stored Procedures
References
Custom Functions (DB-UDF) Sample Query
What this Query Demonstrates
How to Run the Queries
If You Want to Recreate the Custom Functions and the Queries ...
If You Want to Build the Sample Source Code ...
DB-Web Service Sample Query
What This Query Demonstrates
How to Run the Query
If You Want to Recreate the Query ...
References
SQL_Call Sample Query
What This Query Demonstrates
How to Run the Query
If You Want to Recreate the Query ...
References
CSV-XML Sample Query
What This Query Demonstrates
How to Run the Query
If You Want to Recreate the Query ...
References
EJB API Sample
To build the EJBAPI testing classes
To run the ejbAPI test classes
To examine the code