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