首页POST _opendistro/_sql { "query":"select archival_id,title,group_concat(s_object_id) from tdr_documents where s_object_path like'%接收管理库/馆藏档案%'and s_object_type in ('da_record','da_volume') and archival_id like 'J001-06%' and archival_id is not null and title is not null group by archival_id,title HAVING COUNT(s_object_id)>1 order by archival_id" }

POST _opendistro/_sql { "query":"select archival_id,title,group_concat(s_object_id) from tdr_documents where s_object_path like'%接收管理库/馆藏档案%'and s_object_type in ('da_record','da_volume') and archival_id like 'J001-06%' and archival_id is not null and title is not null group by archival_id,title HAVING COUNT(s_object_id)>1 order by archival_id" }

时间: 2024-04-07 15:31:31 浏览: 94

aspace_preservica_db：一个报告数据库，用于整理和处理ArchivesSpace和Preservica元数据

aspace_preservica_db 一个报告数据库，用于整理和处理ArchivesSpace和Preservica元数据桌子数据库中的表及其生成方式 archival_object 通过对ArchivesSpace数据库运行archival_object_table.sql查询来填充该表。柱子描述类型 ID 档案物件编号整型 repo_id 仓库ID 整型 root_record_id 父资源ID 整型 parent_id 父档案对象整型 ref_id 参考编号 varchar（255） component_id 组件唯一ID varchar（255）标题档案对象标题 varchar（8704）发布 1已发布，0未发布整型等级层次级别（即文件） varchar（255） preservica_collection_id 在

Thank you for providing the complete SQL query. It seems that you are querying the "tdr_documents" table and selecting the "archival_id", "title", and a concatenated list of "s_object_id" values. The query is filtering the results by the "s_object_path" column, selecting only the rows where the path contains the string '%接收管理库/馆藏档案%', and the "s_object_type" column, selecting only the rows where the type is either 'da_record' or 'da_volume'. The query is further filtering the results to only include rows where the "archival_id" column starts with 'J001-06', is not null, and the "title" column is not null. The results are then grouped by "archival_id" and "title" and only rows with a count of "s_object_id" greater than 1 are kept. Finally, the results are ordered by "archival_id". I hope this helps! Let me know if you have any further questions.

阅读全文