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