nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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.

a query to retreive all files under a folder.

riteshp1

Hi.
I need to list all documents under a folder if the folder's properties match a search phrase. Can this be done with 1 query ? My current solution is to run 1 query and then use the objectId to fetch all the name of the files using IN_FOLDER(). My company is using Alfresco 3.3 enterprise.

Find more posts tagged with

Comments

afaust

Hello,

I think your request might be in the wrong sub-forum, since you are referring to a CMIS specific query.
If I understand correctly, you want all the documents of a variable number of folders but only if the properties of the folder match your search phrase. I don't think this is possible without using a JOIN and as far as I know, this is <a href="http://wiki.alfresco.com/wiki/CMIS#Query_Language">something Alfresco doesn't support via CMIS</a> (at least in 3.3).

Regards
Axel

riteshp1

Thanks for the quick response. I was hoping to find an alfresco specific extension to cmis-sql that could help me in getting the job done. Join works when relating objects to their aspects but my current problem is that not all the aspects are applied to each object so I have to run several queries and then combine the results in java code to get a complete list of documents which match the user's search phrase.