Custom Task Status not displaing in activity or history

[cballew]

Sugar 5.0

Normaly, when you create a task it will display in either the account history or activiy based on the status value.

I have created custom status values and the task will not display under activities.

How do i change the filter in the account activity report to include the custom status values.

Thank you in advance.

[andopes]

Hi, ciballew.

You can edit the script modules/Tasks/metadata/subpanels/forAccounts.php and add into it the new field.

But you will need to add the same field into subpanels forAccounts.php of all modules under Activities, other way the subpanel will die due a sql error (different number of columns in union).
Take a look into the code of forAccount.php subpanel and you will see an way to force a field to exists just for avoiding this kind of error.

A better way is to preserve the files inside modules and create new one under custom/modules and make the necessary changes for calling the new one and igoring the old one. This is done into extended layoutdefs of accounts.

Cheers

--
André Lopes
Lâmpada Global Services
Rua Bela Cintra, 299 conjunto. 51
São Paulo, SP 01415-000
tel1. 55 11 3237-3110
e-mail: info@lampadaglobal.com

[cballew]

I am not adding a new field, I just added a couple values to "task_status_dom" dropdown list.

I don't want to sound ungrateful, because I really do like what Sugar is doing here.
Unless I am missing something this fringes on broken and not a simple oversight?
Should I report this as a bug?

Under accounts you “should” be able to see EVERYTHING that has been associated with an account.
If the task is set to any “out of the box” value it will display under the “Activities” sub-panel.
Once the task has been marked as completed it moves to the “History” sub panel.
Shouldn’t the default behavior be such that if the status of a task is set to ANY value (other than completed) it is displayed in the “Activities” sub-panel?

I used the “Dropdown Editor” (as it was designed) to add a couple values to an existing “task_status_dom” dropdown list.
If a task is set with one of the new values then it will vanish from the “Activities” sub-panel and I have to go digging through the shared calendars to find it.
If the task does not have a start date then it won’t even show on a calendar. This makes it very difficult to answer questions when the customers call for a status update.

Why would I have to have to manipulate code by hand that stands a chance of getting over written with patches and service releases?

--Cballew

[andopes]

Hi, cballew

Sorry didn´t understand what you are trying to do.

It is pretty easy to fix.

Look at modules/Tasks/metadata/subpanels/
There are 2 files:
forActivities.php and forHistory.php.

Inside each one there is a key called 'where', which is filled with a where clause
You can override this where including your new fields.

If you don´t want to override this core script then you could create an extended layoutdefs under all modules which have activities and history subpanels changing the subpanel_name.
You create two new subpanel definitions from the forActivities and forHistory with the proper changes and refers these into extended layoutdefs.

Cheers

[clint]

Hi, ciballew.

You can edit the script modules/Tasks/metadata/subpanels/forAccounts.php and add into it the new field.

Put your customizations in custom/modules/Tasks/metadata/subpanels/forAccounts.php and custom/working/modules/Tasks/metadata/subpanels/forAccounts.php
to be upgrade safe!

[andopes]

Very thank you, Clint!!

I had not know it before!

Cheers