search content
search content
How do I search document using keyword in the content?
Re: search content
1. The SEARCH clause enables searching the full-text index.
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 documentumforums in their content or metadata:
SELECT object_name, SCORE
FROM dm_document
WHERE SEARCH DOCUMENT CONTAINS 'documentumforums'
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 documentumforums in their content or metadata:
SELECT object_name, SCORE
FROM dm_document
WHERE SEARCH DOCUMENT CONTAINS 'documentumforums'