Avatar

Level 2

Below is the JS i have written ..

var query = xtk.queryDef.create( 

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

    <select>     

   <node alias="@d1"  expr="[Product1/@Description]"/>

   <node alias="@d2" expr="[Product2/@Description]"/>

   <node alias="@d3" expr="[Product3/@Description]"/>

   <node expr="@id"/>

    </select>    

  </queryDef>)

var responders  = query.ExecuteQuery();

for each (var responder in responders.enrich4){ 

    //logInfo(responder);

  var firstArray=["FOOD","BINS & LINERS","BEVERAGES AND SWEETNERS","CATERING SUPPLIES","BATHROOM & KITCHEN PAPER","CLEANING CHEMICALS & EQUIPMENT","APPLIANCES"];

    var secondArray = [];

    var numOne = responder.@d1;   

    var numTwo = responder.@d2;

    var numThree = responder.@d3;

    secondArray.push(numOne);  

    if (numTwo!=""){

    secondArray.push(numTwo);

  }

    if (numThree!=""){

    secondArray.push(numThree);

  }

  for (var i = 0; i < firstArray.length; i++) {

    var isPresent=false;

    for(var j=0;j< secondArray.length;j++)

    {

      if(secondArray[j] == firstArray[i] )

        isPresent= true;

    }

  

    if(isPresent==false)

    secondArray.push(firstArray[i]);

  }

  for(var j=0;j< secondArray.length;j++)

  { 

     document.writeln(secondArray[j]);

  }

   

   var des1 = secondArray[1];

   var des2 = secondArray[2];

  

   xtk.session.Write(<enrich4 xtkschema="temp:enrich4" _key="@id" id={responder.@id} > <Product2 description={secondArray[1]}/> <Product3 description={secondArray[2]}/></enrich4>);

   

    logInfo("id:"+ responder.@id);

  logInfo("secondArray[1]:"+ secondArray[1]);

  logInfo("responder.Product2.Description:" +des1);

  logInfo("secondArray[2]:" +secondArray[2]);

    logInfo("responder.Product3.Description:" +des2);

    

}