Finding objects with queries

You can run a SQL query as an interactive query or as a background search query. Both types of queries find objects within a single object store.

Finding objects with interactive queries
You can run SQL queries from the administration console. These queries are called interactive queries.
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.
Creating virtual tables
Setting case-insensitive search behavior for object store searches
You can configure the property value comparisons in query search conditions to be performed in a case-insensitive manner.
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.

Parent topic: Retrieving documents