select marketingActivityId, marketingActivityName from tbl_CRM_MarketingActivities where ownerId= 26 and ownerType = 'MFR' order by marketingActivityName select opr.territoryId, ter.name territoryName, opr.operatorId, opr.mdmId, opr.companyName, opr.address, opr.city, opr.state, i.interactionDate, i.interactionId, i.recordSource, 0 targetParticipantId, 0 targetOperatorId, 0 marketingActivityId, '' marketingActivityName, i.disposition from tbl_CRM_interactions i inner join tbl_OPR_ClientOperators opr on opr.operatorId = i.partnerId and opr.ownerId = i.ownerId and opr.mdmType = 'CBS' and opr.mdmId is not null inner join tbl_TER_Territories ter on ter.territoryId = opr.territoryId where i.participantId is null and i.partnerType = 'OPR' and i.ownerId = 26 and i.ownerType = 'MFR' -- and i.recordSource like 'Sales Call Import Batch%' and exists( select * from tbl_CRM_participants p inner join tbl_OPR_ClientOperators po on po.operatorId = p.operatorId and po.ownerId = p.ownerId and po.mdmType = 'CBS' where p.ownerId = i.ownerId and p.ownerType = i.ownerType and po.mdmId = opr.mdmId and po.territoryId = opr.territoryId and p.marketingActivityId = ) select p.participantId, p.operatorId, ma.marketingActivityId, ma.marketingActivityName, ma.startDate, ma.endDate from tbl_CRM_participants p inner join tbl_CRM_marketingActivities ma on ma.marketingActivityId = p.marketingActivityId inner join tbl_OPR_ClientOperators po on po.operatorId = p.operatorId and po.ownerId = p.ownerId and po.mdmType = 'CBS' where p.ownerId = 26 and p.ownerType = 'MFR' and po.mdmId = and po.operatorId <> and po.territoryId = and p.marketingActivityId = select * from qmd_nonParticipatingInteractions where targetParticipantId > 0 order by marketingActivityName, territoryName, operatorId, interactionDate

Nothing to display.

Live Data

Sandbox Data

The #lsnumberformat( qmd_nonParticipatingInteractions.recordCount )# interactions below are not tied to the selected objective, but duplicate operators with the same CBS id are.

Initiative: #htmleditformat( marketingActivityName )# (#lsDateformat( startDate, "MM/DD/YYYY" )# - #lsdateformat( endDate, "MM/DD/YYYY" )#)
Territory: #htmleditformat( territoryName )#
&##160;	Date	Operator	Source	Include
#_counter#	#lsdateformat( interactionDate, "MM/DD/YYYY" )# #interactionId#	#htmleditformat( companyName )# #htmleditformat( address )# #htmleditformat( city )# #htmleditformat( state )#	#htmleditformat( recordSource )# FinalizedPlanned