Scope/Environment:
WorldServer any version
Question:
Which query should be run to delete a Project or a Task from a WorldServer Database?
1- To remove a Project, refer to the Project ID (not the Project Group ID) displayed in the project page.
If you are working with an Oracle Database, use this stored procedure
exec spDeleteProject (projectID)
and make sure you (or the Database manager) does a commit; Here is an example:
exec spDeleteProject (224356) commit;
If you work with an SQL Database, the query to delete the project would be:
exec spDeleteProject projectID
2- To remove a Task from the Database, first find the Task Id. This might be mentioned in an error message, or you can find that by hoovering with your mouse cursor on the Task number as explained in this screenshot:
1- To delete a Task in an Oracle hosted environment access the Database and then run this query
1- To delete a Task in an Oracle hosted environment access the Database and then run this query
exec spDeleteTask (taskID) commit;
Replace taskID with the actual taskID, for instance
exec spDeleteTask (473914) commit;
On SQL Servers you can execute the Stored Procedure spDeleteTask and pass Task ID as parameter value. For instance:
exec spdeletetask 473914
Generated Image Alt-Text
[edited by: Trados AI at 3:43 AM (GMT 0) on 5 Mar 2024]