Notifications
Clear all
Topic starter
Does anyone know where can I find the signed date in the documentation table?
Posted : January 18, 2016 5:42 am
It wont be found in the Document table, but rather in the Document Contributed table. Code is below, just add the SDID of your document.
SELECT CONTB_TIME, USERNAME, NOTES
FROM DOCCONTB
WHERE CONTB_ACTION IN (6,7,8) AND SDID = [INPUT DOCUMENT SDID HERE]
Posted : January 18, 2016 5:49 am
Topic starter
Thank you! What is the DOCCONTB table? How do I use this in Crystal reports?
Posted : January 18, 2016 7:13 am
the DOCCONTB table is the document contribute table, stores all the who made changes data. Nothing specific, but basic info. You can create a view in sql linking the SDID's together with the Document table the Document Contribute table and then in Crystal point it to your view, and filter as needed.
Posted : January 18, 2016 7:17 am
You can link the DOCCONTB table to the DOCUMENT table via the SDID in crystal as well - might be easier if you are not comfortable with SQL/creating views as ACantu suggests above (but that would work the same way effectively).
Posted : January 19, 2016 6:14 am
