I am trying to use LogicalDOC as the document repository for an application in Java. I can properly connect to the CMIS Atompub interface, and query for document name. How do I build a query so it searches for document content as well? Also, how do I return search matching score?
For example, on Alfresco, I use the following syntax:
Also, on Apache CMIS Workbench, the query returns only a single column; I had to change it to "SELECT * FROM ..." to return other columns. Is this a bug?
Code: Select all
SELECT cmis:name, cmis:objectId, SCORE () FROM cmis:document WHERE IN_FOLDER('fld.folderID') AND (CONTAINS('keyword') OR cmis:name LIKE '%keyword%') ORDER BY SEARCH_SCORE DESC
Thanks for your attention.