Extract files infos from specific folders using SEARCH_API

[Bro]

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}

}

or 

{

        "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

[angelborroy]

Use CONTAINS clause combined with PATH expression.

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

[Bro]

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\"")"}
}

[angelborroy]

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

[Bro]

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

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

Thanks

[angelborroy]

{
  "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?