Results 1 to 3 of 3

Thread: Adding new Colums in My Open Tasks Dashlet

  1. #1
    CADIT is offline Member
    Join Date
    Sep 2008
    Location
    Belfast
    Posts
    11

    Question Adding new Colums in My Open Tasks Dashlet

    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.

  2. #2
    CADIT is offline Member
    Join Date
    Sep 2008
    Location
    Belfast
    Posts
    11

    Default Re: Adding new Colums in My Open Tasks Dashlet

    We have decided to just start a new database as we couldnt be sure if we would have more idduse in future by fudging a fix here.

  3. #3
    CADIT is offline Member
    Join Date
    Sep 2008
    Location
    Belfast
    Posts
    11

    Unhappy Re: Adding new Colums in My Open Tasks Dashlet

    Starting a new database has helped me figure out where the problem is.
    We have a company name as an account name. When they have an issue we create a case which has many tasks within it. What we would like is the Task related to a case name, but in the My Open Tasks dashlet a column that displays the account name.
    We can fudge this by using the code fromhttp://www.sugarcrm.com/forums/showt...=MyTaskDashlet and relating the task to an account, but we need tasks to be related to cases.
    I hope this reads ok and someone understands what im trying to get on my dashlet.

    Thanks,
    Dave

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 3
    Last Post: 2009-02-15, 07:41 AM
  2. Replies: 0
    Last Post: 2008-10-17, 05:19 PM
  3. Replies: 1
    Last Post: 2008-10-17, 01:43 AM
  4. Replies: 1
    Last Post: 2008-01-21, 09:49 AM
  5. Adding fields to My Open Tasks on Home Page
    By goldenmatt in forum General Discussion
    Replies: 0
    Last Post: 2006-01-31, 12:28 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •