IBM FileNet P8, Version 5.2

Relational query syntax introduction

The SQL statement for a query begins with SELECT This, followed by the SQL commands for column definitions and search criteria. If the SQL statement includes a JOIN clause, the reference to This must be fully qualified with a table name, such as CustomObject.This.

Description Example

A query constructed in the Simple View tab

Table 1. SQL statement examples
Description	Example
A query constructed in the Simple View tab	`SELECT This, Creator, DateCreated, CurrentState FROM Document WHERE (DateCreated > 20010401 T000000Z AND Creator = 'Administrator')`
A query for documents	`SELECT This, ContentSize, Creator, Id FROM Document WHERE (ContentSize > 0 OR Creator = 'Administrator')`
A query for unfiled custom objects	`SELECT CustomObject.This, CustomObject.Name FROM CustomObject LEFT JOIN ReferentialContainmentRelationship rcr ON Cust`

SELECT This, Creator, DateCreated, CurrentState  
FROM Document  
WHERE (DateCreated > 20010401 T000000Z AND Creator = 'Administrator')

A query for documents

SELECT This, ContentSize, Creator, Id  
FROM Document  
WHERE (ContentSize > 0 OR Creator = 'Administrator')

A query for unfiled custom objects

SELECT CustomObject.This, CustomObject.Name  
FROM CustomObject  
LEFT JOIN ReferentialContainmentRelationship rcr ON Cust