Hi
I would like to list all the containers that have any file with the "show" box unticked . Is there any table or view that has this information?
Please see file attached.
Thanks
Sarah
Hi Sarah,
Ron suggests:
SQL - select c.prefix,c.revision,c.title, b.copy_no, d.file_name from doc_copy_files a, document_copies b, documents c, doc_source d where a.view_sequence < 0 and a.copy_id = b.copy_id and b.document_id = c.document_id and a.file_id = d.pdm_file_id EQL - START WITH File SELECT Document.Code,Document.Revision, Document.Name, Copies.DocumentCopy.Code, Name WHERE Copies.Sequence < 0
Answer Verified By: Sarah Almonte
Hi Carma,
Thank you very much. This is exactly what I was looking for.
Kind regards,