topic Extract files infos from specific folders using SEARCH_API in Alfresco Forum

Extract files infos from specific folders using SEARCH_API

Bro — Wed, 15 Feb 2023 12:43:51 GMT

I created this query to find my folder location

{

"query": {"language": "lucene",

"query": "PATH:\"/app:company_home//*\" AND TYPE:\"cm:folder\" AND cm:name:\"my_folder\""},

"include": ["path"],

"paging":{"maxItems": my_item}

}

{

"query": {"language": "cmis",

"query": "SELECT * FROM cmis:folder WHERE cmis:name='my_folder'"},

"include": ["path"],

"paging":{"maxItems": my_item}

}

How can I return all contents from defined folder ? I've to avoid multiples requests.

Thanks

Re: Extract files infos from specific folders using SEARCH_API

angelborroy — Wed, 15 Feb 2023 12:48:01 GMT

Use CONTAINS clause combined with PATH expression.

https://pavelmakhov.com/2015/10/cmis-path-query/

Re: Extract files infos from specific folders using SEARCH_API

Bro — Wed, 15 Feb 2023 13:34:05 GMT

It returns error 500

{
"query": {"language": "cmis",
"query": "select * from cmis:document
where contains("PATH:\"/app:company_home/st:sites/cm:MySite/cm:documentLibrary//*\" AND TYPE:\"cm:folder\" AND cm:name:\"MyFolder\"")"}
}

Re: Extract files infos from specific folders using SEARCH_API

angelborroy — Thu, 16 Feb 2023 08:58:23 GMT

{
  "query": {
    "query": "select * from cmis:folder 
              where cmis:name='MyFolder' AND 
              contains('PATH:\"/app:company_home/st:sites/cm:MySite/cm:documentLibrary//*\"')",
    "language": "cmis"
  }
}

Re: Extract files infos from specific folders using SEARCH_API

Bro — Thu, 16 Feb 2023 12:03:47 GMT

Sorry, but it doesn't even run that query.

Is it possible to do that with lucene language ? From multiple folders ?

Thanks

Re: Extract files infos from specific folders using SEARCH_API

angelborroy — Mon, 20 Feb 2023 08:55:18 GMT

{
  "query": {
    "query": "select * from cmis:folder where cmis:name='MyFolder' AND contains('PATH:\"/app:company_home/st:sites/cm:MySite/cm:documentLibrary//*\"')",
    "language": "cmis"
  }
}

This is working from my side, what error are you getting?