Thanks @arunpatidar , this has helped.  I am able to achieve the results using SQL Query.   Thanks,  Poovitha S

I am writing a query to search documents across folders, there is no tags or anything specifying category, Only difference is the parent folder of the documents. Across different business unit , documents were placed under specific folder name.  I want to search across those different units and get ...

Hi @Chandra_Hire ,  p.limit i am setting as -1.  "success": true, "results": 262, "total": 970, "more": false, "offset": 0,

I have added p.limit to the query still it is not matching.   Thanks, Poovitha S

I am using Query Builder API to query through the documents matching certain criteria, Here is the sample query from query debug tool, path=/content/dam/mchp/documentstype=dam:Assetproperty.and=true1_property=jcr:content/metadata/mchp:document-category1_property.value=documents:product-documents/cod...

Hi,  I am working on requirement to convert our site into MSM site, i have created structure using Microsoft Translator which is installed by default, To try out actual translation is it possible to do using existing translator settings or i need to purchase from actual translator and have them inte...

Hi, I am having requirement to add a custom folder properties , but my folder are created dynamically as nt:folder from backend.  Since folder schema only applies to sling:folder, wanted to check if we can change the folder primary type in JCR.