Bug Tracker Incident #15631

Tested okay in 3.8 pre final demo db.

change metasql todolist-detail to have completed and completedonly filters check todoitem_status rather than todoitem_active

I am still seeing "Completed" To-Do's in lists. There is a new filter which when added would appear to tell the system to show completed To-Do's. That would make you think if you took it away, the list should not show any Completed To-Do's. There is no way to NOT show To-Do's. That is just too messy. Users need to be able to hide already completed tasks.

Revision: 12846
http://postbooks.svn.sourceforge.net/postbooks/?rev=12846&view=rev
Author: sunsetsolutions
Date: 2011-11-18 14:49:09 +0000 (Fri, 18 Nov 2011)
Log Message:
-----------
Issue #15631:fix typo in prjtask completed only filter

Modified Paths:
--------------
xtupleserver/trunk/dbscripts/metasql/todolist-detail.mql

change metasql todolist-detail and reapply the completedonly changes that were lost in a subsequent commit

I can see the added options in the To-Do list screen, however I cannot get the "Completed Only" filter to actually filter. It almost seems to have the opposite effect, as it is showing me the open To-Do items instead (no matter which combination of types I have selected). I have attached a screenshot to the incident.

An error is not generated within the client.

Revision: 12413
http://postbooks.svn.sourceforge.net/postbooks/?rev=12413&view=rev
Author: sunsetsolutions
Date: 2011-09-12 15:07:16 +0000 (Mon, 12 Sep 2011)
Log Message:
-----------
Issue #15631:add completedonly parameter

Modified Paths:
--------------
xtupleserver/trunk/dbscripts/metasql/todolist-detail.mql

I was expecting the Completed to show just those items completed. If we change the behavior, I am sure it will cause some users frustration that the application doesn't work as before. I believe there should be an option to "show completed only", as stated in my proposed business scenario.

Revision: 12405
http://postbooks.svn.sourceforge.net/postbooks/?rev=12405&view=rev
Author: sunsetsolutions
Date: 2011-09-09 20:21:16 +0000 (Fri, 09 Sep 2011)
Log Message:
-----------
Issue #15631:change todoitem active determination

Modified Paths:
--------------
xtupleserver/trunk/dbscripts/metasql/todolist-detail.mql

When only "Completed" is checked on the To-Do list, nothing shows up. "Completed" check box only seem to add completed to the sorted list. The desired result would be to have completed tasks/to-do's show up when Completed is checked. In this way, a manager can see the activity completed by assignee. Sales Manager would like to be able to assign tasks to sales people and then be able to see what they have done. It's an activity report for Manager types.