Locate Documents

snufse-pujN6

Can someone help me with a dql string that let's me locate documents within folder and sub folders where the format is blank. We had pdf documents that got imported without pdf in the format. I have tried to use 'dm_format' and 'dos_extension' but cannot get it working. Thank you very much.

AshishSrivastava

Try below dql

select * from dm_document where folder('/System',descend) and a_content_type is nullstring

Change dm_document to the object type of your pdf documents and /System to folder path where you want to search. Remember it should start with /

Let me know if it helps

Kind Regards,

Ashish Srivastava