Category
Collaboration
Product Version
8.0
Deleting personal tasks from the db
Answered
Hi guys, a broadcast created many tasks (error messages) and we would like to delete these tasks in one go from the db. I could not find the related db table having these tasks.
Can you please tell me where I can find the table for these tasks?
Please see the attached ss for the tasks that I want to delete.
Files:
tasks.PNG
The same question 
Hi Vefa,
I hope all is well,
If you do not want to manually go through and resolve these tasks, it is possible to manually close these through the configuration database.
The majority of a task's definitions are stored in the "textentityparameter" table. For example to find out what tasks are currently assigned to you, you would look for all TextIds where TASKIPASSIGNED" = your user id from the person table.
To then see which of these are currently open, you can look for TASKSTATUS="ASSIGNED". To close these, switch the status to "CLOSED".
Hopefully this helps.
Regards,
Mark
Hi Vefa,
I hope all is well,
If you do not want to manually go through and resolve these tasks, it is possible to manually close these through the configuration database.
The majority of a task's definitions are stored in the "textentityparameter" table. For example to find out what tasks are currently assigned to you, you would look for all TextIds where TASKIPASSIGNED" = your user id from the person table.
To then see which of these are currently open, you can look for TASKSTATUS="ASSIGNED". To close these, switch the status to "CLOSED".
Hopefully this helps.
Regards,
Mark
Hi guys, i'm having the same issue. Is there a way I can delete all tasks without going into the database? I.e. in the admin sectin?
Hi guys, i'm having the same issue. Is there a way I can delete all tasks without going into the database? I.e. in the admin sectin?
HI James,
Unfortunately not, our only way to clean this up would be at DB level, however going forward this does sound like a good idea to have an option like this within the Task section or elsewhere. Would you be happy for me to go ahead and create this idea?
I look forward to your reply.
Regards,
Mark
HI James,
Unfortunately not, our only way to clean this up would be at DB level, however going forward this does sound like a good idea to have an option like this within the Task section or elsewhere. Would you be happy for me to go ahead and create this idea?
I look forward to your reply.
Regards,
Mark
Replies have been locked on this page!