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. The
SEARCHclause enables searching the full-text index.2. The keywords
SCOREandSUMMARYcan be used in the selected values list:a. The
SCOREkeyword 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 ofSCORE.b. The
SUMMARYkeyword 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...