[NXP-15083] Explicit fulltext score in NXQL - Nuxeo Issue Tracker

XML

Word

Printable

Tags:
- fulltext
- nxRepoTeam
Upgrade notes:

Hide

New NXQL ecm:fulltextScore system property. It can be used in an ORDER BY clause, or in a SELECT clause when using queryAndFetch. It must be used in conjunction with a ecm:fulltext match in the WHERE clause.

Show
New NXQL ecm:fulltextScore system property. It can be used in an ORDER BY clause, or in a SELECT clause when using queryAndFetch. It must be used in conjunction with a ecm:fulltext match in the WHERE clause.

For full generality, add a way to express the fulltext score in NXQL:

SELECT ecm:fulltextScore, ... WHERE ecm:fulltext = 'foo'
SELECT ... WHERE ecm:fulltext = 'foo' ORDER BY ecm:fulltextScore DESC

This only applies if there a single fulltext match expression.

This is also needed for compatibility with CMISQL semantics.

depends on

NXP-14294 Supports select fields clause on Elasticsearch

is required by

NXP-7697 Make it possible to go back to relevance sorting on search results

NXP-14979 Implement CMISQL on top of NXQL

NXP-15084 MongoDB NXQL explicit fulltext score