1

I'm using the below search Webscript in Alfresco one 5.1.

http://localhost:8080/alfresco/service/slingshot/node/search?q=@name:somename&store=workspace://SpacesStore&lang=lucene

It works fine with free text search & single named parameter.

1) Now how to incorporate more than one search parameter in the search query & include other custom fields (I've set the property's Index to - List of values - whole match to make it searchable)

2) How to specify to search only with in a particular folder in path ? If I specify the path in workspace://SpacesStore/MyPath I get an error message

Exception: 10010085 No solr query support for store workspace:

Thanks in advance.

Venkat
  • 1,264
  • 1
  • 12
  • 21

1 Answers1

5

Lucene language (short tutorial)

http://localhost:8080/alfresco/service/slingshot/node/search
   ?lang=lucene
   &store=workspace://SpacesStore
   &q=
     TYPE:"cm:folder" 
     AND PATH:"/app:company_home//*" 
     AND @cm\:name:"SOMETHING"

CMIS language

http://localhost:8080/alfresco/service/slingshot/node/search
   ?lang=cmis-alfresco
   &store=workspace://SpacesStore
   &q=
      SELECT * 
      FROM cmis:folder 
      WHERE 
        name:somename LIKE 'SOMETHING' 
        AND IN_FOLDER('workspace://SpacesStore/gfgdrdgdfg-rfew-sdfsdf-sfsdf-ssfsdfd')

or CMIS endpoint:

http://localhost:8080/alfresco/api/-default-/public/cmis/versions/1.1/browser/
   ?cmisselector=query
   &maxItems=10
   &skipCount=0
   &succinct=true
   &q=
      SELECT * 
      FROM cmis:folder 
      WHERE 
        name:somename LIKE 'SOMETHING' 
        AND IN_FOLDER('workspace://SpacesStore/gfgdrdgdfg-rfew-sdfsdf-sfsdf-ssfsdfd')

Test it, more info: https://community.alfresco.com/docs/DOC-5898-cmis-query-language

New Alfresco 5.2 Search REST API

The default search language is afts (Alfresco Full Text Search), but you can also specify cmis, and lucene.

curl -X POST --header 'Content-Type: application/json' --header 'Accept: application/json' --header 'Authorization: Basic *****' -d 
'{
    "query": {
       "language": "lucene",
       "query": "TYPE:\"cm:folder\" AND PATH:\"/app:company_home//*\" AND @cm\\:name:\"SOMETHING\""
    },
    "paging": {
      "maxItems": 5,
      "skipCount": 0
    }
}' 
'http://localhost:8080/alfresco/api/-default-/public/search/versions/1/search'
kinjelom
  • 6,105
  • 3
  • 35
  • 61