The Enterprise Manager administration
application is useful tool for both examining details about deployed IBM® Enterprise
Records class and property schemas
and in providing the capacity to test SQL query statements.
Common IBM Enterprise
Records classes
The
following paths refer to the hierarchy displayed in the Enterprise Manager tree view. These paths
represent the more common IBM Enterprise
Records schema
classes used in report queries.
- Object Stores | <object store> | Document Class | Record
- This is the base class for all of the concrete IBM Enterprise
Records record classes.
- Object Stores | <object store> | Other Classes | Folder | RM
Folder
- This is the base class for all of the IBM Enterprise
Records record container classes
such as File Plan, Record Category, Record Folder and Volume. Record
Folder is further subclassed into several electronic and physical
record container types.
- Object Stores | <object store> | Other Classes | Link | RM
Link
- This is the base class for all of the IBM Enterprise
Records link related classes such
as Record Hold Link, RM Folder Hold Link, and others.
- Object Stores | <object store> | Other Classes | Custom Object
- Under this node reside many IBM Enterprise
Records custom
object classes such as Action, Disposal Schedule, Location, Phase,
Record Hold, Record Type, and others.
Using Enterprise Manager to
Test Report Queries
The Enterprise Manager Query Builder feature
is helpful in developing and testing P8 CM SQL query statements.
To
access the Query Builder feature
- In Enterprise Manager, right-click
the Object Stores | <object store> | Search
Results tree view node.
- Select New Search from the context menu.
- On the View menu, select SQL View to change
the Query Builder view to the free form SQL text entry form.
When using the
Enterprise Manager Query
Builder, the first SELECT statement item must be the "This" object
reference pertaining to the primary table involved in the query. For
example, the following report SQL statement:
SELECT ri.DocumentTitle, ri.DateCreated
FROM RecordInfo ri
WHERE ri.Format LIKE 'Regulator Data%'
must be
changed to:
SELECT ri.This, ri.DocumentTitle, ri.DateCreated
FROM RecordInfo ri
WHERE ri.Format LIKE 'Regulator Data%'
in order
to test the SQL statement with
Enterprise Manager Query
Builder. When supplying literal date/time values, P8 CM SQL syntax
requires the use of the ISO format YYYYMMDDhhmmss[,ffff]Z or the W3C
format YYYY-MM-DD[Thh:mm:ss[.ffff]][<timezone> as in:
WHERE ri.DateLastModified >= 20080324T112334Z
AND ri.DateLastModified <= 2009-02-12