One thing hard to get is "Quick campaign" report in Microsoft CRM 3.0, and after this litle example, you can work out and try to make a report like Campaign.
select fbo.subject, fap.activitytypecodename, *
from [companyname]_MSCRM.dbo.filteredbulkoperation fbo,
[companyname]_MSCRM.dbo.filteredactivitypointer fap
where fbo.operationtypecodename='Quick Campaign'
and fbo.activityid=fap.regardingobjectid
No comments:
Post a Comment