bea.com | products | dev2dev | support | askBEA

Download Docs | Site Map | Glossary
Search

Building Queries and Data Views

Designing Queries

This section explains how to design and build a BEA Liquid Data for WebLogicTM 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