1

What i am trying to accomplish is that the online version of an email stays intact after the related dataextension used for sending is updated. Therefore i created the SendLog DataExtension and added a few fields that are commonly used in all dataextensions used for sending.

Currently i am pulling the field values from the dataextension by LookUp, but it seems lackluster to have like 10 LookUp Queries. Since i am uncertain how to pull data into LookUpRow or ClaimRow with a multi-column key as in SendLog (JobID, SubID,BatchID) i ask this question here. And when this is retrieved, how i get the data from the fields from this row.

Feel free to share links or any comment that might help me with sendlog and VAWP which might lead to problems or shows solutions to upcoming problems.

3
  • 1
    Too many diverse questions under one topic . Highly suggest splitting them
    – 0xsegfault
    May 23, 2018 at 6:01
  • I believe Marketing Cloud now caches the view as a webpage for emails that have been sent, so even if you clear a Data Extension the link will still work.
    – Amtera
    May 25, 2018 at 17:29
  • That is Not true amtera, every vawp will be destroyed if Updates Happen to the sending Data Extension. (If you use These values in the email like personalisation dynamic content etc May 26, 2018 at 14:08

1 Answer 1

1

To do a Lookuprows you should follow this guide.

But if you try to look into the sendlog DE and retrieve value based on several criteria, you can do it this way:

%%[
set @jobid = 13132277 /* a value from my sendlog DE */
set @subID = 93394271 /* a value from my sendlog DE */
set @rows = LookupRows("SendLog","JobID", @jobid,"SubID",@subID)
set @rowCount = rowcount(@rows)

if @rowCount > 0 then

for @i = 1 to @rowCount do

  var @Value1, @Value2
  set @row = row(@rows,@i) 
  set @Value1 = field(@row,"SubID")
  set @Value2 = field(@row,"Client") /* a custom attribute */

]%%

Value 1: %%=v(@Value1)=%%, Value 2: %%=v(@Value2)=%% <br>

%%[ 
next @i

else ]%%

No rows found

%%[ endif ]%%
3
  • Regarding the documentation LookUpRows only has one parameter to define the criteria, the second and third. Can i just concat them like forever like you did? Example like : LookupRows("SendLog","JobID", @jobid,"SubID",@subID, "senddate", Now(), "ContentKey", "123", "AnotherColumn", "value", "AnotherColumn2", "value" ) May 23, 2018 at 8:47
  • 1
    As you can see in my example, I was able to add more than 1 criteria. So I guess you can add more. You will have to test it. Good luck. May 23, 2018 at 9:01
  • 1
    Yes you can keep adding where clauses forever if you wish. Just keep in mind this is only 'AND' criteria, there is no 'OR' criteria. May 23, 2018 at 11:59

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .