Help—Some DQL Queries

While this chapter focused on searching using Webtop, the DQL SELECT query is also used to perform searches. We have already seen SELECT queries in several chapters, so we will only look at the full-text support in DQL queries here. The following queries assume that an Index Server is present in the Documentum deployment.

While various aspects of full-text searches are supported in DQL, we will look at the following key aspects:

1. 1. The SEARCH clause enables searching the full-text index.

2. 2. The keywords SCORE and SUMMARY can be used in the selected values list:

   a. The SCORE keyword returns the document's relevance ranking as determined by the Index Server. A higher relevance ranking implies a better match. By default, the results are returned in descending order of SCORE.

   b. The SUMMARY keyword returns a summary of each document as determined by the Index Server.

The following query retrieves documents containing the word hiring in their content or metadata:

SELECT object_name...