topic ACS- DB query to get the UUIDs of all documents belonging to a particular site? in Alfresco Forum

ACS- DB query to get the UUIDs of all documents belonging to a particular site?

paiyyavj13 — Thu, 07 Feb 2019 21:32:15 GMT

Hi,I am trying to get all the UUID of the documents in a particular ACS site- All documents in the site are of a custom doctype(lets say: customDocType)-I am using the below db queryELECTnodes.UUIDFROMalf_node nodes, alf_qname namesWHEREnodes.type_qname_id=names.id AND names.local_name='customDocT

Re: ACS- DB query to get the UUIDs of all documents belonging to a particular site?

afaust — Fri, 08 Feb 2019 10:01:37 GMT

Querying documents for a specific site via the database is not possible using a simple query condition. You would need to create a stored procedure / function that is able to recursively iterate over the folder/file structure (via alf_child_assoc table) to do the actual query.

This is one of the main reasons that Alfresco cannot / does not support SITE or ANCESTOR queries as transactional metadata queries (TMQ) using Alfresco FTS.

Re: ACS- DB query to get the UUIDs of all documents belonging to a particular site?

paiyyavj13 — Fri, 08 Feb 2019 18:19:51 GMT

Thank you Axel...

So getting what I need from the DB queries is unlikely...

I am going to opt the JavaScript API to get what i need through a custom script-

siteDocLibNode.childFileFolders(files, folders, ignoreTypes, skipOffset, maxItems, requestTotalCountMax, sortProp, sortAsc, queryExecutionId);

Good day...

Regards.