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

Avatar

Avatar
Validate 10
Level 4
richac96395021
Level 4

Likes

32 likes

Total Posts

86 posts

Correct Reply

1 solution
Top badges earned
Validate 10
Validate 1
Boost 5
Boost 3
Boost 25
View profile

Avatar
Validate 10
Level 4
richac96395021
Level 4

Likes

32 likes

Total Posts

86 posts

Correct Reply

1 solution
Top badges earned
Validate 10
Validate 1
Boost 5
Boost 3
Boost 25
View profile
richac96395021
Level 4

03-03-2019

Hi Team,

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

'SELECT  top 201 B0.tsLastModified, B0.iStatus, B0.sAddress, B1.iFailureReason, B1.sText FROM AmcBroadLogrcp 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 AmcBroadLogrcp B0 JOIN NmsBroadLogMsg B1 ON (B1.iBroadLogMsgId = B0.iMsgId) WHERE ((B0.iDeliveryId = 20512877)) ORDER BY B0.tsLastModified DESC '

We are facing the above issue when we have more than 2 custom target mappings. Can you please let me know any suggestions to resolve the same.

Furthermore, we have used below link as a reference to create custom target mapping.

Target mapping

with regards,

Richa Chaubey

Accepted Solutions (0)

Answers (0)