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:
- 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.
- 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
- 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.
- 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 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.
- To save your changes to the export manifest, click .