Finding objects with background search queries
You can run SQL queries as background search sweeps. As the name
suggests, the queries run in the background, and so you can run time-consuming queries without
inconveniencing your use of the system. These queries are also intended to support a wide variety
of reports, such as chargeback, capacity planning, business unit, and document age and usage
reports.
Creating custom search functions
A custom search function is a user-defined
function that can be included in a search expression. A function is
evaluated one time for each search result row.
Custom search function example
This JavaScript example of a CmRpt::UserRecord custom search function
creates and uses a custom root class to store dimension table data. Such data can be used for an
OLAP reporting tool such as IBM®
Cognos® Business Intelligence.
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.