Deleting personal tasks from the db

Vefa Gulecyuz shared this question 12 days ago
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.

Comments (1)

photo
1

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

photo
1

Hi Mark, that solves my problem! Thanks!

photo
1

Hi Vefa,

No problem, I am pleased I could help. Have a great day.

Regards,

Mark

photo