Which function can be used in the SELECT clause of a CMIS query to return a measure of the relevance of each row, in numerical format?

The SCORE() function is the standard function defined by the Content Management Interoperability Services (CMIS) specification to be used in the SELECT clause of a query. Its purpose is to return a numerical relevance score for each result row. This function is specifically designed to work in conjunction with the CONTAINS() predicate in the WHERE clause, which executes a full-text search. The returned score indicates how relevant each document is to the search criteria, allowing applications to rank or filter results accordingly.

A. VALUE() is not a standard CMIS function for returning a relevance score.

B. POS() is not a standard CMIS function and is not used for relevance scoring.

C. RANKING() is not a standard CMIS function for relevance scoring.

1. OASIS Content Management Interoperability Services (CMIS) Version 1.1. (23 May 2013). OASIS Standard.

Section 2.2.6.3.2.5 Functions: "The SCORE() function MAY be used in the SELECT list. This function returns a relevance score for each row, if the WHERE clause contains a CONTAINS() predicate. The values are numerical and greater than or equal to 0.0. A larger value indicates a better match."

2. Alfresco Content Services 5.2 Documentation.

Alfresco Full Text Search Reference > Search query syntax > CMIS query: The documentation details the use of CMIS-SQL for queries and confirms adherence to the CMIS standard, which includes the SCORE() function. An example query is often shown as: SELECT d., SCORE() FROM cmis:document AS d WHERE CONTAINS(d, 'search-term') ORDER BY SCORE() DESC. This explicitly demonstrates the function's usage for retrieving relevance.