Question:
Is it possible to report on the Attachments that are associated with a Call?
Answer:
Veeva CRM does not contain out-of-the-box functionality which marks a call as having an attachment. Without the associated data point, a standard Salesforce report cannot be built.
However, running Salesforce SOQL querys will return raw data that be parsed externally.
The query below can assist in retrieving Call-specific data:
SELECT Id, name, (Select Id,Name from Attachments) FROM Call2_vod__c where id = '<Call ID>'
Note: Replace <Call ID> with the 15-digit ID of the Call
The following will retrieve the attachments for all Call2_vod__c records:
SELECT Id,ParentId From Attachment WHERE Parent.type ='Call2_vod__c'
Note: The ParentID value is the ID value of the call:
Related Documentation:
CRM Help Documentation: N/A