sqlExec issue

Hello viktorstarn​,

This can be done by more simple way or two:

1) With xtk.workflow.get() or xtk.workflow.load (difference is that in load has to be called save() method when finished and in get the changes are saved automatically)

You can directly change anything in the workflow by simple accessing the object:

//get
var wkf = xtk.workflow.get(id);
wkf.label = "new label";
..
..
//load 
var wkf = xtk.workflow.load(id);
wkf.label = "new label";
..
..
..
wkf.save();

2) By using xtk.session.write where your workflow id will be _key and _operation set as update

See the documentation on this topic:

Data oriented APIs

SOAP methods in JavaScript

3) Also you can combine xtk.queryDef()  with xtk.workflow.get() or load()

var query = xtk.queryDef.create(
  <queryDef schema="xtk:workflow" operation="select">
  <select>
  <node expr="@id"/>
  </select>
  </queryDef>
)
var res = query.ExecuteQuery()
for each (var w in res.workflow){
     var wkf = xtk.workflow.get(w.@id);
     //var = xtk.workflow.load(id);
     
     wkf.label = "new label";
     ...
     ...
    //wkf.save()
}

Hope this helps,

Marcel

Hello Marcel,

Thank you for your reply!

This way of changing properties of an entity (recipient, workflow etc.) seems straight forward and easy to use, but does it apply even if I'm aiming to change a certain detail in the xml-code of the wf (in the XML Memo) and then want to save it? What I want to do specifically is remove the <line>-tags in all of the <samleLines>-tags (if the wf contains any)...

...and then save the XML-code of the workflow (to get rid of example data). I've already encounter a few difficulties doing this, having had to split the XML-code-string into smaller substrings and append them to the database field in a loop to be able to save them using sqlExec() for example. But I think I've got it working now except for this last "$("-obstacle...

Can I save the XML Memo (even a very large one) using the methods you suggested? E.g.

1. //get 
2. var wkf = xtk.workflow.get(id); 
3. wkf.label = "new label"; 
4. wkf.data = variableContainingXMLmemo;

or

               By using xtk.session.write where your workflow id will be _key and _operation set as update (and adding something like "data = variableContainingXMLmemo")?

Thanks again,

Viktor

Great answer! Exactly what I needed! Thanks

Slimmed my script down from 240 lines to 40 ^^

Couldn't get it to work initially, "Object.keys(wkf.activities.fileImport).length" kept returning 0. But it started working when I added...

for (var key in wkf.activities.fileImport) {

    if (wkf.activities.fileImport.hasOwnProperty(key)) {

        logInfo("Key: " + key);

        logInfo("True");

    }

}

...before your for-loop while troubleshooting. Not sure why...

Also had to add the actual start- and end-tags and save function:

  for (var i = 0;i<Object.keys(wkf.activities.fileImport).length;i++) {

    wkf.activities.fileImport[i].source.dataSourceConfig.sampleLines = "<sampleLines></sampleLines>"; 

  }

  wkf.save();

Thanks again! Very helpful!!