How to overwrite the SELECT query for dashlet

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,

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 …

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: