How to save the SUBJECT of an EMAIL DELIVERY with an Update Data activity

Hi,

It seems the copy / paste in html raw element is not well taken into account, so hereinafter as normal text:

// XML field not allowed in queryDef as where or node criteria

// so this is not allowed:

//        <node expr="mailParameters/@subject" alias="mailSubject" />

//var filterInternalName = "[@internalName] = '" + "DM3717" + "'";

var filterInternalName = "1 = 1";

//var filterDate = "@contactDate >= '" + PUT YOUR NEED CRITERIA

filterDate = "1 = 1";

// lineCount="5" if not enough restricting where clause, enough lines to test  

var query = xtk.queryDef.create(

    <queryDef schema="nms:delivery" operation="select" lineCount="5" >

      <select>

        <node expr="@id"/>

      </select>

      <where>

        <condition expr={filterInternalName} />

        <condition expr={filterDate} />

      </where>

    </queryDef>)

try

{

  var res = query.ExecuteQuery();

  logInfo("[WKF348] get the subject values of all deliveries selected");

  logInfo("[WKF348] Count of values = " + res.child("delivery").length());

}

catch(e)

{

  logWarning("[WKF348] Error in getting the subject values of all deliveries selected");

  logError("[WKF348] Error number: " + e); // or use logWarning if the treatment must go on despite this error

}

var delivery;

for each(var elt in res)

{

  delivery = NLWS.nmsDelivery.load(elt.@id)

  logInfo("[WKF348] delivery internal name = " + delivery.internalName + " | subject = " + delivery.mailParameters.subject);

}

Regards
J-Serge

Hi Jean-Serge,

I re-open this thread in order to make you a similar request respect to the previous one.

I tried your code for the DELIVERY SUBJECT, that is an XML field, and it worked pretty good!

Now I'm trying to retrieve the filtering condition of the query created in the current workflow.

The code I'm using is the following:

var query = <queryDef schema="xtk:workflow" operation="select">

        <select>

          <node expr="@id"/>

        </select>

        <where>

          <condition expr={ '@id = ' + instance.id }/>

        </where>

        </queryDef>

  var res = xtk.queryDef.create(query).ExecuteQuery();

  for each (wf in res){

    var workflow = NLWS.xtkWorkflow.load(wf.@id);

    logInfo("OPERATION: "+workflow.operation.id);

    vars.query = workflow.activities.query.humanCond; 

    logInfo("QUERY :"+vars.query);

  }

Output:
OPERATION: 0

QUERY: undefined

May you tell me what I'm doing wrong?

Thanks!
Salvatore

Jean-Serge Biron​

Hello salvdangelo,

check the xml of workflow by Edit -> Edit XML source.

Each activity is represented  array of objects as you can have more than one same type activity in workflow

So you need to loop over activity e.g.

var workflow = xtk.workflow.load("158380184");
for each (var item in workflow.activities.start)
  logInfo(item.name)
logInfo(workflow.activities.start.length)

Marcel

Hi Marcel,

I was trying to follow your suggestions but now I'm even more confused than before.

I need to extract the XML filed humandCond I should find in activities/query/humanCond (each of this element is an XML).

If I insert this script

    for each (var activity in workflow.activities ){

      logInfo(activity.name);

    }

output of 'activity.name' is always undefined

Furthermore, I cannot find any reference to 'query' element inside the XML source.

Could you help me, please?
Thanks,
Salvatore

Hello and sorry,

I edited my answer i thought it worked before that you can traverse all activities as array and if there is more activities of one type that  you could traverse those activities as another array aswell. But I  could not get it work

In your case if you have only one query activity in the worflow

var humanCond = workflow.activities.query[0].humanCond;

Marcel