Sending report via workflow

Hi Priyal,

The behavior is normal, because you defined the _context parameter with "global" value.

To be able to restrict/select to a or some deliveries, you must firstly allow your report properties not be only global but contextual:

Then, the report workflow must deal accordingly to you delivery/several deliveries/global context.
See for instance the factory report statisticsPerDelivery (with Test activity) in case of both global or selected deliveries behavior).

If only one or several deliveries are allowed (not global case) then refer for example to the factory deliverySending report.
In all cases the first Query activity should have the Filter with context checkbox selected:

Of course, in some scenarios (for example doing code in Javascript activity), you can manage the defined records to select programmatically.

By the way, if you could mark our replies as helpful and mark it as correct when completed and satisfactory, it would be appreciated so we can see in the forum list that the ticket is not to be dealt with.
Many thanks in advance.

Regards
J-Serge

Hi J-Serge,

Thanks for this - it's very helpful. What would be the other ctx variables you would use for these reports? Global is fairly obvious, what parameters would you use to pull a campaign level report or a delivery level report? Would the correct parameter for these be an exact copy of the selection type (Single-selection etc...) or something different.

This is of course assuming that your report is set up to allow this level of reporting.

Thanks!

Thanks Jean-Serge !

Super helpful, I am going to give it a try in next couple days and update here.

I am planning to duplicate one of deliveryFeedback and use single/multiselect and will try to call it from the workflow.

I think I get the point that, we could have report single/multiselect , instead of global it looks for "selection" context type, which I am not sure if possible from script, because the way I am trying to achieve is, from workflow standpoint, where the actual workflow is part of a campaign....so hypothetically the need to read current campaign (name/internal name) and/or delivery internalName, with the help of java script or variables. Eventually achieving those parameters passed to report, that should restrict/ pull stats for that particular campaign.

There are reports they look like they read these directly based on delivery selection(s), trying to evaluate those java scripts.

Please do share your opinions if my hypothesis is wrong or your suggestions.

Appreciate your help!!

Hi Priyal,

I am not sure if you can solve your problem with J-Serge's response, but if you are still looking for the same, please refer to below list of the variables you can use in context in your script fro standard reports.

Regards,

Amit

Thanks Amit!

I will try few of these to restrict the script of pass only few deliveries/folder.

Is there any other way you are ware of automating reports?

I am trying multiple ways if possibility to automate for campaigns.

Thanks!

Everyone,

This is working now, I will post more details once I validate few more things.

Thanks everyone for your help!

PB

Hi Priyal,

Can you please share here the script that worked out for you with the XLS option. Running OK for one of our customers but the workflow not stopping. I think there is an issue with the javascript.

Hi asjohnso,

Yes your workflow could take very long time to stop probably days if your customer has launched millions of emails from Campaign.

Since you are pulling as global context, its trying to capture all the emails that ever sent out from all campaigns/deliveries.

Here is the script you could use to limit via selection and pass delivery pk.

~~~~~~~~~~~~~~~~~~~

var reportName = "deliveryFeedback";

var path = '/usr/local/neolane/nl6/var/' + getOption('NmsTracking_Instance') + '/export/test3'+formatDate(new Date(), "%2D%2M%2Y")+'.xls';

logInfo(path);

var exportFormat = "XLS"; // export format

isAdHoc = false; // is ad hoc?

var _ctx = <ctx _context="selection" _reportContext={reportName} _selection= "24817905" />; //context selection and delivery Pk

xtk.report.export(reportName,_ctx,exportFormat,path,isAdHoc); //submit request

~~~~~~~~~~~~~~~~~~~

Hope this helps!

Thanks!