Creating an SQL query to generate an export manifest

You can use an SQL query to generate a list of assets to add to an export manifest.

To construct an SQL query in FileNet® Deployment Manager:

1. In the navigation pane, navigate to the Search node of the object store from which you want to add assets to the export manifest. In the content pane, click the SQL Search tab.
2. In the text box, enter an SQL query. The query must contain the following properties in the SELECT clause: Id, ClassDescription.

   If the [Name] property is not available, the object's Id is displayed as its name.

   To enable meaningful information about each object to be displayed in the Search Results tab, include the following properties in the SELECT clause (as applicable to the particular type of object in the FROM clause):

   • Name
   • Creator
   • DateCreated
   • LastModifier
   • DateLastModified
   For example, to search for all documents whose document title is set, enter the following query:

   SELECT [Id], 
     [ClassDescription], 
     [Creator], [DateCreated], 
     [DateLastModified], 
     [LastModifier], 
     [Name] 
   FROM [Document] 
   WHERE [DocumentTitle] is not null

3. Click Run to run the query. The results are displayed in the Search Results tab. Validation errors are displayed in the Search Results tab. Syntax errors must be corrected before the query can run successfully.
4. In the Search Results tab, select one or more assets, and then click Add. When you finish adding assets, close the Add Assets window.
   Tips:

   • The Maximum result limit setting determines the maximum number of search results that the query can return. A value of zero indicates the default limit of 500 search results.
   • Click Add All to add all assets that are returned by the search criteria to the export manifest. If any returned asset is already listed in the export manifest, the duplication is automatically detected and the asset is not added a second time. Thus it is safe to rerun a search and use the Add All option to cause the system to add any assets that were created since the export manifest was originally populated.
   • Use the menu action Export Manifest > Refresh Assets to remove any deleted assets from the export manifest. However, because the refresh verifies each asset individually, the refresh can take a long time to process. For a large export manifest that was originally generated by using an SQL query, it might be more efficient to create a new export manifest and rerun the saved search to regenerate the export manifest contents.
   • If the number of assets that is returned by the search exceeds 500, click More Results to fetch the next 500 results to add to the search results table. The results are appended to the end of the table and the value for Results displayed is updated to indicate the cumulative total.
5. To save your changes to the export manifest, click File > Save.