Hi,
I would like a colum in my My Open Tasks for the Account Name. I have read and tried the http://www.sugarcrm.com/forums/showt...=MyTaskDashlet but it only displays the Case name, not the Account Name.
I have copied the paragraph entries from other dashlets which display Account Name, but again these dont display anything.
I even built a new test Sugar installation which did exactly what I was looking for by running through http://www.sugarcrm.com/forums/showt...=MyTaskDashlet, however we have been using Sugar for 5 months and cant really start the database from scratch again.
I have exported the SQL database from a RPath VMware installation to a Debian Virtual Machine Ive built from scratch. I believe the problem to be label associated in the SQL database or with how PHP reads the database. This was giving the same problems in RPath, so I thought it would be fixed when I move to a debian box.
I find it strange that one paragraph in MyOpportunitiesDashlet.data.php doesnt work in MyTasksDashlet.data.php
Here are two bits of code ive tried, however I have tried a lot of variations, too numerious to put here.
'account_name' => array('width' => '29',
'id' => 'ACCOUNT_ID',
'link' => false,
'label' => 'LBL_LIST_ACCOUNT_NAME',
'sortable' => false),
'parent_id' => array(
'width' => '29',
'label' => 'LBL_LIST_ACCOUNT_NAME',
'sortable' => false,
'link' => true,
'id' => 'parent_id',
'ACLTag' => 'PARENT',
'related_fields' => array('parent_id', 'parent_type')
),
Hopefully someone can help explain where Sugar or PHP picks these values up from.
I do get a column to display, but its either blank, has a lot of numbers and letters (id) or has other info in it like case name, but never account name. If I change parent_id to parent_type it shows the word cases in the dashlet. I think this is where I am going wrong, but not sure.
I have to admit ive only been using Linux for about a year, and im a newbie with PHP etc. so any help would be greatly appriciated.
If you need any more details just ask.


LinkBack URL
About LinkBacks



Reply With Quote

Bookmarks