How to overwrite the SELECT query for dashlet

👨‍💻 Development Help
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: