2

Can Vault report on documents that have attachments?

Reporting Capability:

Is it possible to have a future enhancement for reports to list documents that has attachments?

THanks.

 

 

5 comments

  • Avatar
    Andrei Calopareanu

    Have you managed to get an answer for that?

    I have a few customers that are asking me the same thing.

  • Avatar
    Graham G

    Hi - thanks for letting us know this enhancement would be helpful. It is on our roadmap. Currently VQL supports finding all documents with attachments. Let me know if seeing a sample query would be helpful.

    Regards, Graham

  • Avatar
    Andrei Calopareanu

    Thank you for the answer Graham!

    A few basic instructions on how and where to use the VQL query would definitely be helpful. I have SQL knowledge and the VQL instruction page, just need to know where to apply it.

    Andrei

  • Avatar
    CIT_Veeva_Support_Notifications

    Yes I would also like to see an example of using VQL.

    Thanks.

    -Yuet Han.

  • Avatar
    Graham G

    Here is an example that should return all documents with an attachment (number and name):

    yourvault.com/api/v18.3/query?q=SELECT source__vr.document_number__v, source__vr.name__v FROM relationships WHERE relationship_type__v = 'attachments__v'

    I usually use the application Postman when making API calls. Let me know if you have any trouble. 

    Regards, Graham

Please sign in to leave a comment.