Searching by API

As we transition to the new Hyland Community, some post links may be temporarily disrupted as we finalize redirects. We apologize for the inconvenience and are working to resolve this as quickly as possible. Details.

srowsell

I'm trying to find the best way to do a search of the repository, returning the result set in some form (preferably JSON), ideally using something like SQL to form the query.  Most of what I've been doing so far have just been Lucene searches in javascript, and while those were fine for some applications I need to be a little more fine-tuned in my queries.  Some examples, especially showing how to handle custom properties, would be fantastic.

In a similar vein I did some digging (using Firebug) and found a link like this:

http://alf01:8080/alfresco/s/slingshot/search?site=&term=&tag=&maxResults=251&sort=&query={'prop_sts_acctNo':'100031','prop_sts_memberName':'','prop_sts_statementDate-date-range':'','prop_cm_name':'','prop_cm_title':'','prop_cm_description':'','prop_mimetype':'','prop_cm_modified-date-range':'','prop_cm_modifier':'','prop_sts_esid':'','prop_sts_branch':'','prop_sts_email':'','prop_sts_statementType':'','prop_sts_expirationDate-date-range':'','prop_sts_status':'','datatype':'sts:statement'}&repo=true&rootNode=alfresco://company/home&pageSize=50&startIndex=0&alf_ticket=TICKET_a12d8046f82a48b02288c214260f9f2a5ead6cdd

and that does more or less return what I want it to return.  Some of the name=value pairs in the query string don't work as I would expect them to work; I don't know what the "site" or "sort" values should be to do anything, as the values I've put into them (such as known values for sites for the "site", or "asc" for "sort") don't have any effect on the result set.  Is there a resource to look at what these search properties are supposed to mean?

Thanks muchly,

Steve

kaynezhang

First be aware that the

http://alf01:8080/alfresco/s/slingshot/search‍

is a webscript api not javascript api .Event if it is implemented using javascript search api ,it dose some encapsulation on parameter name and parameter format.and also it's purpose is for share ,co contain some parameter like site.
In this

/slingshot/search‍

webscript api :

      site the site identifier to search into, null for all sites
      term: search terms
      tag: search tag
      query: advanced search query json
      sort: sort field ,it's format is like this sort fied|sort order,default sort order is asc ,for example:@cm:name|true,@cm:name,TYPE|false
‍‍‍‍‍‍‍

I guess you want to do some field search using javascript search api ,it has different parameter name and parameter format ,here is an example

var sort1 = 
{ 
  column: "@cm:modified", 
  ascending: false 
}; 

var sort2 = 
{ 
  column: "@cm:name", 
  ascending: true
}; 

var paging = 
{ 
  maxItems: 20, 
  skipCount: 0 
}; 

var def = 
{ 
  query: "+PATH:\"/app:company_home/cm:TESTFOLDER1//*\" +@cm\:title:\"banana\"", 
  store: "workspace://SpacesStore", 
  language: "fts-alfresco", 
  sort: [sort1, sort2], 
  page: paging 
}; 

var results = search.query(def); 
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍