Notifications
Clear all
Topic starter
Does anyone know if it possible to search for a document in SQL or Crystal Reports based on the Doc ID that appears in CPS? I tried the DID and SDID column in the "DOCUMENT" table but this a long string and I am wanting to be able to search based on the 1-4 digit Doc ID that is visible in CPS.
Posted : June 11, 2020 7:38 am
Look for VISDOC.
Posted : June 11, 2020 7:45 am
Topic starter
THANK YOU!
I have been searching up and down for this and I, somehow, kept completely overlooking this whole column in the DOCUMENT table.
Posted : June 11, 2020 7:54 am
For CPS, the visible document id is DOCUMENT.VISDOCID.
This is the document number you can see in the upper, left corner of the document preview window or if you launch the viewer in the document or right-click to view a source document is in that window's title bar.
Posted : June 11, 2020 8:27 am
