Custom PO Print - Text Attachment Content on BI Publisher Report
Summary
We are creating a custom report where we need to display the Content of Text attachment for a Purchase Order. This information is not being stored in seeded Document tables but creating a file in UCMContent
We are creating a custom report where we need to display the Content of Text attachment for a Purchase Order. This information is not being stored in seeded Document tables but creating a file in UCM with .txt file.
Approach we Tried:
i) Create a SQL dataset “DocumentID” with the corresponding query:
SELECT FndDocumentsEO.dm_version_number AS "DOCUMENT_ID",
headers.po_header_id AS "PoHeaderId"
Tagged:
1