Custom fields in history subpanels ver: 6.5.4

[mediabiz]

Hi All,

I have struggled for days to get custom categories visible in the History subpanel under Accounts. I have followed two great instructions from the Developer blog:
SugarCRM Developer Blog » Blog Archive » HOWTO: Making upgrade-safe changes to the History subpanel

SugarCRM Developer Blog » Blog Archive » Adding custom fields to the Activities or History subpanels but I can’t get any output in the History list.

Added the file “custom/Extension/modules/Accounts/Ext/Layoutdefs/history_change.php”
And loaded only history meetings for testing:
$layout_defs['Accounts']["subpanel_setup"]["history"]["collection_list"] = array(
'meetings' => array(
'module' => 'Meetings',
'subpanel_name' => 'ForHistory_mb',
'get_subpanel_data' => 'meetings',
),
);

Copied the original ForHistory file to “custom/modules/Meetings/metadata/subpanels/ForHistory_mb.php”

And all worked OK.

The I tried to get the custom categories in the History list and added

'categories' => array (
'force_blank' => true,
'force_exists' => true,
'vname' => 'LBL_LIST_CATEGORIES',
'force_default' => '(SELECT meetingcategories_c FROM meetings_cstm WHERE meetings_cstm.id_c=meetings.id) AS',
),

The columns heading for categories are visible but no data!
Pleas give me a hint.

Regards
John

[kbrill]

Could you go over exactly what you are looking for on the screen and where it comes from on your system. It appears that you want a custom field (meetingcategories_c) from meetings to show up, is this correct?

[kuske]

What about this blog:
SugarCRM Developer Blog » Blog Archive » Adding custom fields to the Activities or History subpanels

[khudabux]

Hi Dudes
first of all i am little bit confused how can i add new thread that's why i am adding in this way ...
I want to add a sub panel in account detail view(like contact), in which i want to show 4 columns(1,recently filed cases(5 days interval), 2-open cases,3-For Support cases, 4- Deploy able on cases)), means not whole data just number of recently filed cases, and number of open case (like 6 are open cases) , and on number a link should be when i click on number one popup appear and in popup open cases detail should be is it possible...? i am waiting for your replay..

[mediabiz]

Dear Mr Brill

Yes I want a custom field (meetingcategories_c) from meetings (db meetings_cstm) to show up, it is this correct?




Dear Mr Kuske

As you can see from my first post I have taken the cod from the article "Adding custom fields to the Activities or History subpanels"
But I do not get any custom data in the History column "Categories".

Do I need to declare the new array "categories" as a part of the array "subpanel_layout" some where else?

Thanks for help
John

[mediabiz]

Anwer to Kenneth Brill

Yes I want a custom field (meetingcategories_c) from meetings (db meetings_cstm) to show up, it is correct?



Anwer to Harald Kuske

As you can see from my first post I have taken the cod from the article "Adding custom fields to the Activities or History subpanels"
But I do not get any custom data in the History column "Categories" in my example.

Do I need to declare the new array "categories" as a part of the array "subpanel_layout" some where else?


What more confusing, when I made a similar test to get custom data from the Tasks module with same code the fist column "start_date" works OK but not the column "categorie"! Se the code below:

The date in second row comes from start_c in tasks_cstm but the data from categorie_c in same reccord does not turn up in next column "Kategori" (Swedish)!


File “custom/modules/Tasks/metadata/subpanels/ForHistory_mb.php”

      
       'date_start'=>array(
                'force_blank' => true,
                'force_exists' => true,
                'vname' => 'LBL_LIST_KATEGORI',
                'force_default' => '(SELECT start_c FROM tasks_cstm WHERE tasks_cstm.id_c=tasks.id) AS',
                   'vname' => 'LBL_DATE',
                        'width' => '10%',
        ),

       'categorie' =>  array (
             'force_blank' => true,
             'force_exists' => true,
             'force_default' => '(SELECT categorie_c FROM tasks_cstm WHERE tasks_cstm.id_c=tasks.id) AS',  
              'vname' => 'LBL_LIST_KATEGORI',
               ),

Does the datatype make a different maybee, varchar or date ?

Pleas help

[kbrill]

I'll look into this over the weekend.

[kbrill]

Can you set your log level to 'info' and send me a copy of your log after running the subpanel. I want to look at the generated SQL.

[mediabiz]

Tank you for your time!

The developmen server ara now SugarCRM Version 6.5.2 (Build 8410).
The case are to add custom categories to the History and Activities sub panels for Accounts and change date to start, sent and so on. The modules with custom categories are Meetings and Tasks.

When the customer implemented Tasks categories via studio the “date_start” suddenly was stored in “tasks_custm.start_c” .
( "tasks_cstm" structure = id_c, kategori_c, huskategori_c, vu_c, start_c, slut_c, medarbetare_c )

The following code fixed the date_start OK, but I could not get any data to the categories array.
From “custom/modules/Tasks/metadata/subpanels/ForHistory_mb.php”

       'date_start'=>array(
                 'force_blank' => true,
                 'force_exists' => true,
                 'force_default' => '(SELECT start_c FROM tasks_cstm WHERE tasks_cstm.id_c=tasks.id) AS',
                 'vname' => 'LBL_LIST_DATE',
                 'width' => '10%',
     ),
 

        'categories' =>  array (
                  'force_blank' => true,
                 'force_exists' => true,
                 'force_default' => '(SELECT kategori_c FROM tasks_cstm WHERE tasks_cstm.id_c=tasks.id) AS',   
                 'vname' => 'LBL_LIST_KATEGORI',
                 'width' => '15%',
                ),

And from “custom/modules/Meetings/metadata/subpanels/ForHistory_mb.php”

 'categories' =>  array (

                 'force_blank' => true,
                 'force_exists' => true,
                 'force_default' => '(SELECT meetingkategori_c FROM meetings_cstm WHERE meetings_cstm.id_c=meetings.id) AS',        
                 'vname' => 'LBL_LIST_KATEGORI',
                 'width' => '15%',
                         ),

( Table structure for "meetings_cstm" = id_c, meetingkategori_c, contact_id_c, user_id_c )


Some problems was solved when I changed the array names to “meetingkategori_c” and “kategori_c”!
But only one modules custom categories are visible at the same time. I get the Meeting categories if the module are defined first in the array $layout_defs['Accounts']["subpanel_setup"]["history"]["collection_list"]

In file “custom/Extensions/modules/Accounts/Ext/Layoutdefs/History_change.php”
And the same happens for the Activities subpanel.

Attachments: custom files and a log from loading an Account custom_subpanels.zipsugarcrm_log.zip

Best Regars
John

[kbrill]

I will try to look at these tonight and get back to you.