HOWTO: Custom Accounts Sugar 6.x dashlet that show records without related calls

sugarcrmdevelopers —  May 24, 2011 — 3 Comments

Here’s a great question that came out of the forums this week

Hey everyone,

I am trying to create a Dashlet that lists all Accounts that have no related Calls. In effect, I want to list all of the accounts that have never been called by our sales staff.

I have made many custom Dashlets before, but this is baffling me. Considering an account can have any number of calls related to it, I assume I would have to have some code that counts the number of related calls, and if this number == 0, then I can display this account record to the user in the dashlet list.

Is this even possible? How could I modify the overridden buildWhere() or process() functions for the generic dashlet? Is there someplace else I should be looking?

I am completely lost as to where to even begin. ANY help would be much appreciated.


I directed the poster to look at the overriding the process() method in that Dashlet’s class. After taking a look at the other examples we’ve done of this in the app ( modules/Calls/Dashlets/MyCallsDashlet/MyCallsDashlet.php is a good example ) the poster came back with a nice example of the code needed to do this, shown below:

All that’s needed is to set the various custom_ parameters that are passed to the ListViewSmarty class to add the extra query pieces needed to make this work.

3 responses to HOWTO: Custom Accounts Sugar 6.x dashlet that show records without related calls


    Hi John
    with the fabtools of david boris on sugarforge, i have make a custom dashlet for “not followed accounts”. The SQL is a great tutorial. 
    Maybe, how to add a search criteria for “last X month” will be great.



    Will this solution works for sugar 7.x versions ?

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s