I have my own custom module, and dashlet is also there for this module. Now i want to make changes in the dashlet page with custom query.
I have created many dashlet with custom functionality with DASHLET class.(where pagination no need)
But in this case i need pagination with custom functionality…
i did R & D on this many people suggest many things, But basically they are focusing on CUSTOM_WHERE or buidwhere functionality which i no need…
Plz any suggestion…
Guys i already check this things,
http://support.sugarcrm.com/02_Documentation/04_Sugar_Developer/Sugar_Developer_Guide_6.5/02_Application_Framework/Dashlets/01_Creating_Dashlets
http://forums.sugarcrm.com/f148/how-use-custom-query-dashlet-57780/
http://forums.sugarcrm.com/f6/problem-dashlet-custom-query-53216/
But its not happening.
I solve this issue…
by using process function ModuleDashlet.php file in dashlet folder.
Now i am facing one problem in pagination if you see, 1-5 of 0 is displaying it should bt 1-5 of 7.
if i click next its showing correct. 6-7 of 7
first page only it is showing like that,
Any solution guys …
:unsure:
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… 