AnsweredAssumed Answered

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

Question asked by paiyyavj13 on Feb 7, 2019
Latest reply on Feb 8, 2019 by paiyyavj13

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 query:
SELECT
nodes.UUID
FROM
alf_node nodes, alf_qname names
WHERE
nodes.type_qname_id=names.id 
AND names.local_name='customDocType';

 

This gives me a list of UUIDs across the repository-

 

Could any one let me know whether there is an additional query condition I could add to the above db query which would give me only the UUIDs of documents within a particular ACS site.

 

Thank You...

 

Regards.

Outcomes