IBM FileNet P8, Version 5.2.1            

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.

About this task

View a demo: To view a short video that shows how to configure background searches and then create reports and charts to show the results, see https://www.youtube.com/watch?v=OBS7YIBodVo.
Here are some types of information that background search queries can generate:
  • Metrics such as the number of documents that were created or the amount of disk space that was used
  • Document categorization by class, containment, ownership, customer, policy, or account
  • Data aggregation by hour, day, week, and so on

A background search query can optionally retrieve data from another object store. This feature allows the processing load and search result storage to be isolated from the production database.

  • Creating background search queries
    To create a background search query, you create a template and a template-based sweep. Multiple sweeps can be created from the same template.
  • Editing background search queries
    You can edit a background search template. Changes to the template do not affect existing sweeps.
  • Creating IBM Cognos Business Intelligence reports
    Cognos® Business Intelligence can potentially consume the fact and dimension table output of background searches. The background search mechanism enables report generation to be customizable, powerful, and scalable.
  • Background search query syntax introduction
    With some exceptions, the syntax for background search queries must conform to the standard syntax for Content Platform Engine queries. The exceptions concern aliasing, parameter variables, and aggregate functions.
Parent topic: Finding objects with queries
Related concepts:
Background search sweeps

Last updated: March 2016
p8pcc261.htm

© Copyright IBM Corporation 2017.