Specify "Period" parameter when generating report export using xtk.report | Community
Skip to main content
I
IainOllerenshaw
Level 2
August 3, 2022
Question

Specify "Period" parameter when generating report export using xtk.report

  • August 3, 2022
  • 3 replies
  • 2778 views

Hello!

I'm automating some Message Center reports, using this as a basis:

https://experienceleague.adobe.com/docs/campaign-classic/using/automating-with-workflows/use-cases/monitoring/sending-a-report-to-a-list.html?lang=en

I'm specifically looking at the "Message Center Service Level" report, and I'm getting a basic PDF generated using this code:

var reportName = "messageCenterQualityOfService"; var path = "/home/customers/specsavers/incoming/Temp/mcqos.pdf"; var exportFormat = "PDF"; var _ctx = <ctx _context="global" _reportContext="messageCenterQualityOfService" /> var isAdhoc = 0; xtk.report.export(reportName, _ctx, exportFormat, path, isAdhoc);

This generates a report based on the default parameters, "Channel", "Execution Instance" and "Period".

Can someone help me set the "_ctx" parameter so that I can generate the report for different "Periods". e.g. "1 week view" via JavaScript?

Thank you!

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

3 replies

I
Adobe Employee
imicuAdobe Employee
Adobe Employee
August 3, 2022

Hello,

 

Is it possible to check the debug view to see the context elements/attributes (and so parameters/values) available?

I
IainOllerenshawAuthor
Level 2
August 5, 2022

Thank you, imicu.

 

I'm so sorry, how do I see the debug view of the report? It's an out-of-the-box report:

Many thanks!

I
IainOllerenshawAuthor
Level 2
August 5, 2022

I do not have that report in my sandbox, but what you can do it to go to Explorer > Administration > Configuration > Reports

 

From here you have 2 options:

  1. Select the report, go to Properties and variable Tab and note the XPath for that variable.
  2. Select the report, go to Preview, select Global and tick 'Enable debug mode' checkbox. Play around with Period dropdown (refresh after changing the period) confirm that period tag modifies under vars. In my case (may not apply to you), it was looking like this 
<vars>
<period>7</period>
</vars>

All the variables defined in the variables tab are accesible under the ctx.vars.yourVariable

Once you identify the variable, you can use it in JS script by accessing with: 

ctx.vars.period = <VALUE>

Hope this helps.


This is really helpful, thank you!

 

I've debugged, and have the parameter and value that I need to run the report for a 2-week period (period=336). However, after amending my JS I still get a default report (24-hour period).

 

var reportName = "messageCenterQualityOfService";
var path = "/home/customers/specsavers/incoming/Temp/mcqos.pdf";
var exportFormat = "PDF";
var _ctx = <ctx _context="global" _reportContext="messageCenterQualityOfService" />
_ctx.vars.period = 336;
var isAdhoc = 0;

xtk.report.export(reportName, _ctx, exportFormat, path, isAdhoc);

Is this code correct?

 

Sincere thanks for your help - I'm definitely having "a moment" here!

Sukrity_Wadhwa
Community Manager
Sukrity_WadhwaCommunity Manager
Community Manager
August 18, 2022

Hi @iainollerenshaw,

Were you able to resolve this query with the help of the given solutions or do you still need more help here? Do let us know. In case the given solutions were helpful, then kindly choose the one that helped you the most as the 'Correct Reply'.
Thanks!

Sukrity Wadhwa
I
IainOllerenshawAuthor
Level 2
August 24, 2022

No luck, unfortunately. I'm following this guide which makes use of a JavaScript activity. According to the documentation, there is no "ctx" object that I can use in this activity, yet that seems to be the recommended solution. I'm very new to this aspect of Campaign, so struggling a bit!

I
IainOllerenshawAuthor
Level 2
September 1, 2022

Any help here? I haven't been able to get any further with this.

Terms & ConditionsAccessibility statement

Loading footer...