Forum Discussion

Former_Member's avatar
Former_Member
Accelerator III
8 years ago

AML Search for missing files

I have a situation whereby a unknown number of Document(s) produced from Word are missing associated PDF files.  Wondered if anyone had ever created a query that could find all ItemType Document that DID NOT have a related PDF file.  I know how to find related PDF files.  Just don't know how to do the opposite! Thanks in advance... Popeye

2 Replies

  • christopher_gillis's avatar
    christopher_gillis
    Community Manager
    8 years ago
    Hi Popeye, If you are looking for Document items that do not have any files attached, you can take advantage of the has_files property and run the first query in the sample below. To get all Documents that have a related file, but do not have a related PDF, run the second query in the sample below. Lastly, you can combine the two to get all Documents that do not have a related PDF. Chris __________________________________ Christopher Gillis Aras Labs Software Engineer  
  • Former_Member's avatar
    Former_Member
    Accelerator III
    8 years ago
    Chris, Thanks so much!  This is brilliant and yet simple.  I didn't realize you could combine searches like this. Peter (aka Popeye)