Task Management - Select all

[Wayne Workman]

Any way to have a “select all” feature that will let me delete all tasks?

I’ve just been going into MySQL on the back-end and just deleting everything in the table - and I haven’t thought to ask for a feature till now.

[Tom Elliott]

Which tasks? (Running, or all)?

[Wayne Workman]

Um… all ?

the SQL I use is

delete from tasks where 1;

and that deletes everything.

[Wayne Workman]

It should be integrated into the “filter” for task management too.

[Tom Elliott]

@Wayne-Workman If you’re simply removing all entries, why not just run truncate table tasks

[Wayne Workman]

@Tom-Elliott Hanging here on the forums and chatting with people here trying to help, the truncate command doesn’t always work but the delete where 1 always does, so I just use that method out of habit.

[Tom Elliott]

@Wayne-Workman What do you mean?

[Wayne Workman]

@Tom-Elliott I’ve never brought it up before because it’s not a fog issue. It’s more a MySQL thing across distributions and versions.

[Junkhacker]

deleting the contents of the tasks table will also eliminate your task history
i’m finding that information more and more useful by the day

[Tom Elliott]

This has been added. You can delete tasks from the db after searching. Active tasks will be cancelled. Nice part is the checkboxes remain in their checked state even on subsequent updates. If you cancel it will first prompt. Hopefully this helps.