Example Queries For LucidWorks Enterprise CMIS Connector Made by SHI | Blog von SHI Elektronische Medien GmbH

SHI Blog

Example Queries For LucidWorks Enterprise CMIS Connector Made by SHI

Documents being stored in a CMIS capable repository (e. g. Alfresco ECM, SharePoint, Documentum, etc.) and being indexed by the search platform LucidWorks Enterprise using the SHI CMIS Connector can be selected using a CMIS query. This is a very powerfull method to restrict the indexing of documents to particular parts of a repository. Some examples are shown below.

//Read all documents with ending 'doc' or 'docx'

SELECT * FROM cmis:document WHERE cmis:name = '*.doc*'

//Read all documents with ending 'doc'

SELECT * FROM cmis:document WHERE cmis:name = '*.doc'

//Read all documents with ending 'txt'

SELECT * FROM cmis:document WHERE cmis:name = '*.txt'

//Read all documents recursively by the given folder id

SELECT * FROM cmis:document WHERE IN_TREE('workspace://SpacesStore/525a5e3a-9d09-4366-8610-92e00ae1dabf')

//Read all documents that are in the given folder id (no subfolders are read!)

SELECT * FROM cmis:document WHERE IN_FOLDER('workspace://SpacesStore/e3407003-8730-4a0a-a64a-544348b6cefc')

//All docs that contain the word solr:

SELECT * FROM cmis:document WHERE CONTAINS('solr')

//Read all documents recursively where file ending is 'pdf'

SELECT * FROM cmis:document WHERE IN_TREE('workspace://SpacesStore/525a5e3a-9d09-4366-8610-92e00ae1dabf') AND WHERE cmis:name = '*.pdf'

Kategorie: Alfresco ECM, Lucene & Solr, LucidWorks Search, Tags: , .

Einen Kommentar hinterlassen