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  

Send us your feedback: We are always looking for feedback to help improve our Knowledge Base! Please let us know if this article is helpful or provide feedback on how we can improve your experience by clicking here.