Suitecrm extend the dashlets Lead Module

[pgr]

A couple of solutions here (try first the one without code!)

Hidden converted Leads on Lead Dashlet

I need to make by code because I will use this for all Users as default filter. For this reason I created a New Custom Lead Dashlet to share this filter to all users.

And an extra way of doing it:

How to overwrite the SELECT query for dashlet

Hi jaydeep, You can customize you query in module class file in the following functoin. function create_new_list_query($order_by, $where,$filter=array(),$params=array(), $show_deleted = 0,$join_type=’’, $return_array = false,$parentbean=null, $singleSelect = false) { // Make your chagnes here. return parent::create_new_list_query($order_by, $where, $filter, $params, $show_deleted, $join_type, $return_array, $parentbean, $singleSelect); } Hope this helps…