如何列出有关所有Alfresco文件的信息（Postgres SQL）？ [英] How to list information about all Alfresco's files (Postgres SQL)?

问题描述

Alfresco持久层中的文件节点表示形式：

A file node representation in Alfresco persistent layer:

• 内容存储在 ALFRESCO_HOME\alf_data\contentstore\ 文件夹


• 元数据存储在关系数据库中（默认值：PostgreSQL）


• 用于文本搜索的信息（Lucene）存储在Solr的文档数据库中

• content is stored in ALFRESCO_HOME\alf_data\contentstore\ folder
• metadata are stored in relational database (default: PostgreSQL)
• information for text searching (Lucene) are stored in Solr's document database

哪个Postgres表用于保存新上传文件的元数据？
如何列出有关所有Alfresco文件的信息（Postgres SQL）？

Which Postgres tables are used to keep metadata of new uploaded file? How to list information about all Alfresco's files (Postgres SQL)?

推荐答案

保存文件元数据的表：

The tables that keep files metadata:

SELECT 
  n.id, 
  npn.string_value as filename,
  cu.content_size,
  cu.content_url,   
  n.uuid, 
  n.audit_created
FROM alf_node as n
  join alf_node_properties npn on 
     (npn.node_id=n.id and npn.actual_type_n=6 and npn.qname_id in 
       (select id from alf_qname where local_name='name'))
  join alf_node_properties npc on 
     (npc.node_id=n.id and npc.actual_type_n=21 and npc.qname_id in 
       (select id from alf_qname where local_name='content'))
  join alf_content_data cd on (cd.id = npc.long_value)
  join alf_content_url cu on (cd.content_url_id = cu.id)
where 
  n.type_qname_id in (
    select id from alf_qname where local_name='content'
  )

这篇关于如何列出有关所有Alfresco文件的信息（Postgres SQL）？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！