Designing Queries

This section explains how to design and build a BEA Liquid Data for WebLogic^TM query using the Data View Builder, and provides example walk-throughs of how to build some simple queries. The following topics are included:

• Designing a Query
• Building a Query

• Opening the Source Schemas for the Data Sources You Want to Query
• Adding a Target Schema
• Mapping Source and Target Schemas
• Setting Conditions
• Showing or Hiding Data Types
• Using Automatic Type Casting

• Examples of Simple Queries

• Example: Return Customers by Name
• Example: Query Customers by ID and Sort by State

• Understanding Scope in Basic and Advanced Views

• Where Does Scope Apply?
• Basic View (Automatic Scope Settings)
• Advanced View (Setting the Scope Manually)
• When to Use Advanced View to Set Scope Manually
• Task Flow Model for Advanced View Manual Scoping
• Returning to Basic View
• Saving Projects from Basic or Advanced View
• Scope Recursion Errors

• Understanding Query Design Patterns

• Target Schema Design Guidelines and Query Examples
• Source Replication

• Next Steps