Thursday, May 29, 2025
fusion query to get file import and export details
SELECT DID,DDOCNAME,DDOCTYPE,DDOCTITLE,DDOCAUTHOR,ABSPARENTID processid
FROM revisions r
JOIN ESS_REQUEST_PROPERTY erp1 ON to_char(r.did)= erp1.value AND erp1.name = 'dID'
JOIN ESS_REQUEST_HISTORY erp2 ON erp1.requestid = erp2.requestid
WHERE
r.ddocaccount='prj$/projectCosting$/import$'
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment