Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn more

View all

Sign in to view all badges

Issue in the preview of delivery logs within Deliveries

nikitap46765450
Level 2
Level 2

Hi Team,

We have observed that within Deliveries for a custom Target Mapping, the query that gets generated in delivery logs preview is as follows:-

'SELECT  top 201 B0.tsLastModified, B0.iStatus, B0.sAddress, B1.iFailureReason, B1.sText FROM XYZBroadLogrcp B0 JOIN NmsBroadLogMsg B1 ON (B1.iBroadLogMsgId = B0.iMsgId) ORDER BY B0.tsLastModified DESC'

due to which in the preview we are able to view the delivery logs for the targeted audience till date from the custom recipient table.

Ideally the preview query should be as follows:-

'SELECT  top 201 B0.tsLastModified, B0.iStatus, B0.sAddress, B1.iFailureReason, B1.sText FROM XYZBroadLogrcp B0 JOIN NmsBroadLogMsg B1 ON (B1.iBroadLogMsgId = B0.iMsgId) WHERE ((B0.iDeliveryId = *****)) ORDER BY B0.tsLastModified DESC '

This issue is faced only in the custom target mapping and not in the default target mapping

Please help me with any solution for this issue.

Thanks

Nikita Pramanik.

0 Replies