<rql-query>

<!ELEMENT rql-filter (<rql>,<param>*)>

Parent: <named-query>

Copyright © 1997, 2013 Oracle and/or its affiliates. All rights reserved. Legal Notices

ATG Repository Guide

Documentation Home

Contents
Search

loading table of contents...

Introduction
Repository API
- Repository Architecture
- Repository Items
- Item Descriptors
- MutableRepository
- Core Repository API Elements
- Cloning Repository Items
Repository Queries
- Repository Query API
  - atg.repository.QueryBuilder
  - atg.repository.QueryOptions
- Repository Query Examples
- Repository Queries in the ATG Control Center
- Repository Query Language
SQL Repository Overview
SQL Repository Architecture
- Repositories and Transactions
  - Managing Transactions
- Repository Definition Files
  - Default Values and XML File Combination
- SQL Repository Items
- SQL Repository Item Descriptors
SQL Repository Data Models
- Primary and Auxiliary Tables
- id Property
- Auxiliary Tables
  - References Constraints
- Properties and Database Columns
- One-to-Many Relationships: Multi-Valued Properties
- Operating on Multi-Valued Properties
- Many-to-Many Relationships
- Default Item Descriptor
- Cascading Data Relationships
- Item Descriptor Inheritance
- Derived Properties
- Repository Items and Session Backup
SQL Repository Item Properties
- Enumerated Properties
  - enumerated
  - enumerated String
- Required Properties
- Unique Properties
- Date and Timestamp Properties
  - Last-Modified Properties
- Null Properties
- Grouping and Sorting Properties
- Property Validation with a Property Editor Class
- Maintaining Item Concurrency with the Version Property
- Repository Items as Properties
- Transient Properties
- Assigning FeatureDescriptorValues with the <attribute> Tag
  - Attributes Used in the ACC
- Linking between Repositories
- SQL Types and Repository Data Types
- User-Defined Property Types
- Property Fetching
- Handling Large Database Columns
SQL Repository Queries
- Repository Filtering
  - <rql-filter>
  - filterQuery and rqlFilterString Properties
- Overriding RQL-Generated SQL
- Parameterized Queries
- Named Queries
  - Named Queries in an SQL Repository Definition File
  - Java Code Access to Named Queries
- Text Search Queries
  - Simulating Text Search Queries
- Wildcards in Queries
- Not Queries and Null Values
- Outer Joins
- Table Ownership Issues
  - Constraints
  - Setting Ownership at the Repository Level
- Unsupported Queries in the SQL Repository
Localizing SQL Repository Definitions
- Defining a Resource Bundle
- Localizing Properties
- Localizing Enumerated Properties
SQL Repository Caching
- Item and Query Caches
  - Item Caches
  - Query Caches
- Caching Modes
- Simple Caching
- Locked Caching
- Distributed Caching Modes
  - Simple versus Distributed Caching
  - Distributed Caching Mode Options
- Distributed TCP Caching
- Distributed JMS Caching
  - Distributed JMS Caching Setup
- Distributed Hybrid Caching
- Distributed External Caching
- Cache Configuration
- Monitoring Cache Usage
  - Weak Cache Hashtable
- Caching by Repository IDs
- Restoring Item Caches
- Preloading Caches
- Enabling Lazy Loading
- Cache Flushing
- Cache Invalidation Service
External SQL Repository Caching
- Choosing Repository Items for External Caching
- Configuring Repository Items for External Caching
- External Cache Naming
- External Caching Statistics
- Batch Mode for External Caching
  - Enabling Batch Mode for External Caching
  - Repository Configuration for Batch Mode
Developing and Testing an SQL Repository
- Adding Items
- Updating Items
- Removing Items
  - Removing References to Items
- Querying Items
- Importing and Exporting Items and DDLs
- startSQLRepository
- Using Operation Tags in the Repository Administration Interface
- Debug Levels
- Modifying a Repository Definition
SQL Repository Reference
- SQL Repository Definition Tag Reference
- DTD for SQL Repository Definition Files
- Sample SQL Repository Definition Files
- Configuring the SQL Repository Component
  - Registering a Content Repository
  - SQL Repository Component Properties
SQL Content Repositories
- Setting Up an SQL Content Repository
- Creating an SQL Content Repository Definition
- Content Repository Example
- Configuring an SQL Content Repository
Repository Loader
- Repository Loader Architecture
- Repository Loader Components
- Repository Loader Administration
- RLClient
- Importing Versioned Repository Data
- Repository Loader Example
Purging Repository Items
- Selecting Repository Items
- Related Conditions and Actions
- Purge Statistics
- Scheduling a Purge Operation
- Stopping a Purge Operation
- Asset Purge Error Handling
- Throttling and Performance
  - Configuring Throttle Settings for an Asset Purge Function
  - Configuring the Thread Count for an Asset Purge Function
- Using the Profile Asset Purge Function
- Creating and Configuring an Asset Purge Function
Repository Web Services
- GetRepositoryItem Web Service
- PerformRQLQuery Web Service
- PerformRQLCountQuery Web Service
- Repository Web Service Security
Composite Repositories
- Use Example
- Primary and Contributing Item Descriptors
- Item Inheritance and Composite Repositories
- Transient Properties and Composite Repositories
- Non-Serializable Items and Composite Repositories
- Property Derivation
- Configuring a Composite Repository
- Composite Repository Queries
- Composite Repository Caching
- Composite Repository Definition Tag Reference
- DTD for Composite Repository Definition Files
- Sample Composite Repository Definition File
Secured Repositories
- Features and Architecture
- Creating a Secured Repository
- Secured Repository Example
- ACL Syntax
  - Standard Access Rights
  - ACL Examples
- Secured Repository Definition File Tag Reference
- DTD for Secured Repository Definition File
- Performance Considerations
- Exceptions Thrown by the Secured Repository
LDAP Repositories
- Overview: Setting Up an LDAP Repository
- LDAP Directory Primer
- LDAP Repository Architecture
- Repository Views in the LDAP Repository
  - Repository View Definition
  - LDAP Repository View Example
- LDAP Repository Queries
  - ID Matching Queries
  - Unsupported Queries in the LDAP Repository
- Configuring LDAP Repository Components
- LDAP Repository Definition Tag Reference
- Sample LDAP Repository Definition File
- DTD for LDAP Repository Definition Files
Index

Search Terms