How to overwrite the SELECT query for dashlet

👨‍💻 Development Help
1

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…

2

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.

3

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:

4

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… :slight_smile: