Creation of variables from a list in Adobe | Community
Skip to main content
V
valentinn903812
August 7, 2018
Solved

Creation of variables from a list in Adobe

  • August 7, 2018
  • 5 replies
  • 2987 views

Hello everyone,

Does anybody know how to declare a variable on Adobe from a list ?

I have a list with 4 columns and I want to create a variable for each cells of the list : that means for each line there will be 4 variables (the final aim is to put the variables in a delivery ). I think I should use a Javascript but I don't know what to put inside...

Furthermore I have another question, I don't find in documentation if global variables exist. I mean a variable created in a workflow (A) that can be used/modified by the workflow (B) even if the WF (A) is not running.

Thanks for your help,

Regards,

Valentin

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

Hi Valentin,

  • Create an option under Administration > Platform > Options by the name of your choice say "MyWkfCount" and type text.
  • Add a JS activity right after the activity which is supposed to give your record count.
  • Keep this line of code setOption("MyWkfCount", vars.recCount);

For the List variables, best will be to use an array.

From the schema tab of query activity you can get the schema name, probably it will be temp:query

You can then use this code

var query = xtk.queryDef.create(

  <queryDef schema="temp:query" operation="select">

    <select>

      <node expr="@use"/>

      <node expr="@label"/>

      <node expr="@[D_1]"/>

      <node expr="@[D_2]"/>

      <node expr="@[D_3]"/>

      <node expr="@[D_4]"/>

      <node expr="@[D_5]"/>

    </select>

  </queryDef>);

var results = query.ExecuteQuery();

var data= [];

for each (var result in results) {

     data[0] = result.@use;

     data[0] = result.@label;

     data[0] = result.@[D_1];

     data[0] = result.@[D_2];

     data[0] = result.@[D_3];

     data[0] = result.@[D_4];

     data[0] = result.@[D_5];

}

5 replies

vraghav
Adobe Employee
vraghavAdobe Employee
Adobe Employee
August 7, 2018

Hi Valentin,

The term global variables is called as Options in Campaign.

If you are on ACC, you can set an option on one workflow calling setOption Javascript function and then on the other workflow use a getOption function.

vraghav
Adobe Employee
vraghavAdobe Employee
Adobe Employee
August 7, 2018

I'm not very clear of your first use case. Can you please elaborate more?

V
valentinn903812Author
August 8, 2018

Hi Vipul,

Thanks for your answer and your help. Do you have an example of script for the first case ? I want to store in a variable the number of sets in a workflow using vars.recCount. I don't know exactly how to use the function setOption with recCount.

For your second answer and my first point, I'll illustrate step by step what I want to do. So I would like to create as many variables as possible from a list read.

I mean I want to create 7 variables in this case (for each "cells").

Do you have any idea about how I can do that ?

Thanks for your time.

Regards,

Valentin

vraghav
Adobe Employee
vraghavAdobe EmployeeAccepted solution
Adobe Employee
August 9, 2018

Hi Valentin,

  • Create an option under Administration > Platform > Options by the name of your choice say "MyWkfCount" and type text.
  • Add a JS activity right after the activity which is supposed to give your record count.
  • Keep this line of code setOption("MyWkfCount", vars.recCount);

For the List variables, best will be to use an array.

From the schema tab of query activity you can get the schema name, probably it will be temp:query

You can then use this code

var query = xtk.queryDef.create(

  <queryDef schema="temp:query" operation="select">

    <select>

      <node expr="@use"/>

      <node expr="@label"/>

      <node expr="@[D_1]"/>

      <node expr="@[D_2]"/>

      <node expr="@[D_3]"/>

      <node expr="@[D_4]"/>

      <node expr="@[D_5]"/>

    </select>

  </queryDef>);

var results = query.ExecuteQuery();

var data= [];

for each (var result in results) {

     data[0] = result.@use;

     data[0] = result.@label;

     data[0] = result.@[D_1];

     data[0] = result.@[D_2];

     data[0] = result.@[D_3];

     data[0] = result.@[D_4];

     data[0] = result.@[D_5];

}

V
valentinn903812Author
August 9, 2018

Hello Vipul,

Thanks a lot for your help and your time.

I succeeded to use the global variables with setoption and getOption and I'm now tackling the issue on the list.

Regards,

Valentin

Terms & ConditionsAccessibility statement

Loading footer...