Change History Subpanel

[mikesolomon]

I would like to change the history subpanel so that it displays an addittional date

To make it more complicated this date is different depending on the activity

tasks - date_due
calls - date_start
meetings - date_start
notes- date_entered
emails - date_entered

Is this possible?

At the moment the only way I can think to do it is to have 5 different history subpanels

[andopes]

Hi, Mike.

It is possible to do.
Fortunately you can do that in a Upgrade Safe way.
You have to extend the forHistory.php subpanel definition inside each modules which is included into the collection list of the SubPanel History.

For the field definition inside the ForHistory.php you have to do the following:

         'date_due'=>array(
            'vname' => 'LBL_LIST_DATE_DUE,
            'width' => '10%',
            'alias' => additional_date',
        ), 
  

This is a sample for the Task ForHistory.php subpanel definitions.
What does it say to Sugar: Show the field date_due but insert an alias in the query, this alias to additional_date.
So all the fields date you want to add must have the alias pointing to the same field, in this case: additional_date.

I hope it helped you.
Cheers.

[mikesolomon]

Hi, Mike.

It is possible to do.
Fortunately you can do that in a Upgrade Safe way.
You have to extend the forHistory.php subpanel definition inside each modules which is included into the collection list of the SubPanel History.

For the field definition inside the ForHistory.php you have to do the following:

         'date_due'=>array(
            'vname' => 'LBL_LIST_DATE_DUE,
            'width' => '10%',
            'alias' => additional_date',
        ), 
  

This is a sample for the Task ForHistory.php subpanel definitions.
What does it say to Sugar: Show the field date_due but insert an alias in the query, this alias to additional_date.
So all the fields date you want to add must have the alias pointing to the same field, in this case: additional_date.

I hope it helped you.
Cheers.

Andre - thats exactly what I needed to know

Now just to complicate things more is it possible to change it so that the order by is the new field?

At the moment it is ordered by date_modified

I'm presuming that it is doing a union statement so I guess if I change it so that instead of

'sort_by' => 'date_start',

I change it to

'sort_by' => '5', where 5 is the 5th field selected it might work

[mikesolomon]

Hi, Mike.

It is possible to do.
Fortunately you can do that in a Upgrade Safe way.
You have to extend the forHistory.php subpanel definition inside each modules which is included into the collection list of the SubPanel History.

For the field definition inside the ForHistory.php you have to do the following:

         'date_due'=>array(
            'vname' => 'LBL_LIST_DATE_DUE,
            'width' => '10%',
            'alias' => additional_date',
        ), 
  

This is a sample for the Task ForHistory.php subpanel definitions.
What does it say to Sugar: Show the field date_due but insert an alias in the query, this alias to additional_date.
So all the fields date you want to add must have the alias pointing to the same field, in this case: additional_date.

I hope it helped you.
Cheers.

Andre

Almost there

It almost worked

The problem comes for emails

'emails' => array(
'module' => 'Emails',
'subpanel_name' => 'ForHistory',
'get_subpanel_data' => 'emails',
),
'linkedemails' => array(
'module' => 'Emails',
'subpanel_name' => 'ForUnlinkedEmailHistory',
'get_subpanel_data' => 'function:get_unlinked_email_query',
'generate_select'=>true,
'function_parameters' => array('return_as_array'=>'true'),
),

Changing the email ForHistory makes no impact so I end up with an sql error

I commented out the lines above and it works which is ok for the time being but I will need emails in the future

any ideas?

[thancock]

Andre,

You say that this mod to ForHistory.php is upgrade safe. can you please explain how so? Does Sugar check for changes to these files?

I am on Sugar Pro 5f

Thanks for any help - you are one of the most helpful contributors to these forums - thank you

Tony

[Rust]

Is it possible to specify the font color of the field in the subpanel somehow? Say by the date?

[drxg7]

Andre

Almost there

It almost worked

The problem comes for emails

'emails' => array(
'module' => 'Emails',
'subpanel_name' => 'ForHistory',
'get_subpanel_data' => 'emails',
),
'linkedemails' => array(
'module' => 'Emails',
'subpanel_name' => 'ForUnlinkedEmailHistory',
'get_subpanel_data' => 'function:get_unlinked_email_query',
'generate_select'=>true,
'function_parameters' => array('return_as_array'=>'true'),
),

Changing the email ForHistory makes no impact so I end up with an sql error

I commented out the lines above and it works which is ok for the time being but I will need emails in the future

any ideas?

Hi,
I'm facing the same problem. Commented out those lines ok for now. Also need emails in the future.
Browse within forums found this:http://www.sugarcrm.com/forums/showthread.php?t=30336

Ok, so..
I was looking into this and found in \modules\Accounts\metadata\subpaneldefs.php the following:

 'linkedemails' => array(
       'module' => 'Emails',
       'subpanel_name' => 'ForUnlinkedEmailHistory',
       'get_subpanel_data' => 'function:get_unlinked_email_query',
       'generate_select'=>true,
       'function_parameters' => array('return_as_array'=>'true'),
), 
  

In particular I assume that

 'get_subpanel_data' => 'function:get_unlinked_email_query' 
  

is a method for retrieving data for Emails subpanels through a javascript function called get_unlinked_email_query that should be defined in <sugar-root>\include\SugarEmailAddress\SugarEmailAddress. js

I'm not sure but maybe you can use the same syntax with a custom function.

I'm pointing at:

through a javascript function called get_unlinked_email_query that should be defined in <sugar-root>\include\SugarEmailAddress\SugarEmailAddress. js

I couldn't find get_unlinked_email_query function within SugarEmailAddress.js.
Is this function really caused those emails couldn't passed to the details list? Do we need to define it? How we're going to do that?

Cheers

[danisan]

Hope to help;

I had the same error "cant find funcion" .....
Looking for this function in sugardev.net, I found that this "get_unlinked_email_query", is defined in class account.php, located at SugarCRM\modules\Accounts directory. Probably, a module installation replaced account.php with an incompatible version.

The workaround I found, for my sugar installation is to look for account.php in some other directory of my installation, and there was one, dated two days ago. So I renamed SugarCRM\modules\Accounts\account.php to "old" and copied the cached copy of account.php to modules\Accounts directory.

In my case, get it working ok inmediatly.

[blablaz]

Hello everyone,

I'm looking for a way to change the fields that appear in the subpanels in SugarCRM 6.1
I can't find the file "ForHistory.php"

Can anyone help??
Thanks in advance

[andopes]

The file ForHistory.php can be found at modules/<ModuleName>/metadata/subpanels/
Where <ModuleName> can be: Calls, Emails, Meetings, Notes, Tasks.

Cheers