Information

Title	WorldServer - what do the values associated to 'completionstatus' in the Tasks table correspond to?

URL Name	000013042

Summary	Sometimes you would like to run some query in the WorldServer Database to find out more about the status of some project's tasks. While doing so, you will probably find the column completionstatus associated with different number/values. This article provides information about what each value stands for.

Scope/Environment	WorldServer

Question

Sometimes you would like to run some query in the WorldServer Database to find out more about the status of some project's tasks, for instance by running

Select * from tasks

where projectid = <insert projectid>

As a result, you will probably find the column completionstatus associated with different number/values. What does each value stand for?

Answer

Completionstatus 3 means that the Task has been completed successful (succeeded)
Completionstatus 5 means that the Task has been canceled
Completionstatus 4 means that the Task has failed
Completionstatus 1 means that the Task is still active

Reference

This article might be relevant:

WorldServer - Old WorldServer projects are not getting archived

Attachment 1

Attachment 2

Attachment 3

Attachment 4

Attachment 5

WorldServer - what do the values associated to 'completionstatus' in the Tasks table correspond to?

Information