select id,seccategory,docsubject as 题目,
accessorycount as 附件个数,doclastmoduserid as 编辑人,
doccreatedate as 发布日期,doccreatetime as 发布时间
from docdetail
where seccategory in (11,12,13,14,204) and docstatus in (1,2,5)
其中
seccategory 为所要展示的目录id,替换即可
docstatus为文档状态,这里只展示:
1:生效/正常(不需要审批,归档重新打开)
2: 生效/正常(审批后,发布后)
5:归档
泛微Ecology安装包
https://download.csdn.net/download/fwecology/18254654