Update multiple tasks at once

, ,
1

Hello,

we have a requirement where we have to update a value in a lot of tasks. So we have the ids of the tasks we want to update and we need to e.g. set the lastModifiedDate of all these tasks to the same value.

The API in the WmTaskClient package does only allow us to update one task at a time. But I would like to avoid 1000 calls to pub.task.taskclient:updateTask when I want to update 1000 tasks in the same way. Is there another way to do this.

If the task table would be my own I would just issue an SQL Update like this.

UPDATE TASK SET LAST_UPDATED_DATE = ‘some value’ where TASK_ID IN (‘taskid1’, ‘taskid2’,…);

Any ideas?

Regards,
Mathias

2

Try this.

Create an adapter to run the following command on webMethods database:

UPDATE .T_TASK SET LAST_UPDATED_DATE = ? WHERE TASK_ID IN (<Task_List>)

Best regards.

3

Hello,

thanks for your response. Of course I could update the Task Engine DB directly. But I do not think it is a good idea. The db itself is not a public API and I would just take this way when Software AG proposes this to me. Usually I consider everything behind the API of the product as a black box.

Is there a somebody from Software AG around who has an opinion on this.

Regards,
Mathias