IBM FileNet P8, Version 5.2.1

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.

About this task

Tip: As an optional alternative to JavaScript, you can code your handler definition in a Java™ code module.

You can write other custom search functions and handlers to populate dimension tables with level data. Here are some examples:

`NewRpt::UserRecord()`	User record. Stores an LDAP group as a column in a record table.
`NewRpt::ClassRecord()`	Class record. Stores the parent or top level class as an extra column in a custom root class table.
`NewRpt::DateRecord()`	Date record. Extracts and stores the day, month, and year as columns in a new custom root class table. Important: Extracting and storing the day might produce more rows than are needed.

Procedure

To see an example of a custom search function handler that populates a dimension table:

Install the FileNet® P8 5.2.1 Reporting Enablement AddOn add-on. For more information, see Installing an add-on feature to an object store.
Access the node for search function definitions in the administration console:
1. In the domain navigation pane, select the object store.
2. Expand the Events, Actions, Processes node.
3. Expand the Search Function Definitions node.
4. Click CmRpt::UserRecord.
5. In the details pane, click the Type subtab on the new tab.
Copy the text in the JavaScript text box into an editor for viewing.

What to do next

Use the custom search function in a background search expression. For more information, see Relational query syntax introduction.