Overdue Tasks

We are aware that overdue tasks are highlighted with a colour in Sugar, however we want to create a report ()that can be used on a Dashboard as well) that shows overdue tasks by assigned user.

We thought this would be easy until we looked at the filter options - there is no ability to specify before today - you can specify before today being todays date but tomorrow the report is wrong because it is now using before yesterdays date.

We considered creating a calculated Overdue field with a formula where if due date is before today, set the field to Yes, but the problem with that is that the calculated field won't update unless the record is accessed and saved.

We looked at List view - nope same filter options.

We also know we probably could build a workflow that triggers the user and the users manager to action the task. Thats fine as well.

And Yes - in an ideal world there should not be any overdue tasks, but in reality it happens.

All we want to do is create a simple Overdue Tasks Report (and maybe later on Overdue Calls and Meetings). Any ideas appreciated, without telling us we need to buy some further add on.

Hopefully we are missing the obvious, because this is pretty basic.

Parents
  • Hi Greg Barrass,

    Would use of the filter "Task > Due Date Last # Days" or any of the other "Last" filters work to serve your use case?

    The MySQL WHERE clause for a report filtered on Last 7 Days, run on Aug 16, looks like this:

    WHERE (((tasks.date_due >= '2019-08-10 00:00:00' AND tasks.date_due <= '2019-08-16 23:59:59'))) AND tasks.deleted=0

    The two issues with this I see impacting your stated use case are:

    1. This report returns Tasks due later today, and therefore not yet overdue.
    2. This report does not show Tasks due prior to the defined window of time.

    I hope this helps.

  • Patrick,

    Thanks very much - that gave me a clue on how to solve - with one limitation.

    I created a filter as you recommended using Last # and set the value to 999 (could be 365 etc etc) with Task Status not equal to Completed. Result - Overdue Task Report.

    The only limitation is that the system seemed to count back from today at 2pm (not sure why). User Profile Time Zone is correct unless system is using some other time zone when running reports.

    Regards

    Greg Barrass

Reply
  • Patrick,

    Thanks very much - that gave me a clue on how to solve - with one limitation.

    I created a filter as you recommended using Last # and set the value to 999 (could be 365 etc etc) with Task Status not equal to Completed. Result - Overdue Task Report.

    The only limitation is that the system seemed to count back from today at 2pm (not sure why). User Profile Time Zone is correct unless system is using some other time zone when running reports.

    Regards

    Greg Barrass

Children