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