How to pick up current DELIVERY id in a DELIVERY report workflow

salvdangelo

22-09-2017

Hi everyone,

I am using a delivery report and in particular a query activity with a custom schema (containing delivery iDs in particular).
In "where condition" I would filter the records for the current delivery (SCHEMA.deliveryId = <currentDeliveryId>)

Someone could tell me how to do this?
Maybe it's a simple issue.


Thanks for helping!

Note: I am not using cube

Vipul RaghavAmit_Kumar

Jean-Serge Biron

Adhiyan

@nkur

Adobe Campaign

Replies

Highlighted

salvdangelo

06-10-2017

I finally solved this issue thanks to your help and after many attempts!

Here is my custom solution for anyone that might need:

Workflow.

ReportDelivery.JPG

1st query:

ReportDelivery2.JPG

2nd query:

ReportDelivery3.JPG

ReportDelivery4.JPG

It does work fine!