Reporting of completed tasks

[kwurst]

Allow the user to report on completed tasks by category and/or time range. This would be useful for someone who needs to produce an annual report of what they did on the job, or on particular projects.

[jamesC311]

Would this also have to keep track of tasks that were explicitly deleted? Or would we just not count those?

[jhasenzahl]

I think the best way to do this would be to write an entry to a database whenever something has been completed. Task name, category, date of completion.

Deleting the task later shouldn't change the completion report.

[jamesC311]

Sounds reasonable, can probably add another field to account for if it is reoccurring or not so we don't need to add the completed task indefinitely, just update occurAmount or something along those lines.

[jhasenzahl]

You would want to add a new entry every time it is completed

[djorgji]

Google Tasks keeps tasks that have been completed and "deleted" already--they are simply kept with a "cleared" flag rather than actually deleted, I can query it by specifying in JSON for the "completed" tasks to include "cleared" (they don't send those by default). So give me next week after my finals this week, and I ll get to it; might have to figure out away to keep track of repeated tasks, also gtasks does have a "completion date" to keep track of when the task was marked complete, but I don't think that will be hard.

Once I have that list I can then just send it back to a google spreadsheet on google drive.

[kwurst]

Can't you just have an active/completed state for the task, change the
state to completed, add the completion date, and leave it in the database?

On 12/9/12 7:19 PM, Jonathan Hasenzahl wrote:

I think the best way to do this would be to write an entry to a database
whenever something has been completed. Task name, category, date of
completion.

Deleting the task later shouldn't change the completion report.

—
Reply to this email directly or view it on GitHub
#69 (comment).

--- Karl

---

Karl R. Wurst Email: [email protected]

[jamesC311]

@jhasenzahl

What I was thinking was...

task data in DB and has one more field for NumberOfTimesCompleted so as opposed to storing X amount of tasks that are identical it stores the task once and can increment each time it's completed.

I was thinking along the lines of saving space/access time considering it could reduce the number of tasks in the DB drastically if there are many reoccurring.

Did I not make that clear or am I just not right? haha

[djorgji]

@kwurst That is how gtasks does it, they are just flagged with "cleared" when the user deletes them, my suggestion is to just get the list of "completed"and "completed+cleared" from gtasks.

@jamesC311 You wont know when they were actually completed, just that they were completed X amount of times, Which probably wont be enough in terms of a report.