if (method_exists($focus, "getListQuery")) { //Retreive the list from Database //<<<<<<<<<customview>>>>>>>>> if (isset($where) && $where != '') { $where = ' and ' . $where; } $listquery = $focus->getListQuery($where); } else { $listquery = getListQuery($currentModule); if (!empty($where)) { $listquery .= ' and ' . $where; } } $list_query = $oCustomView->getModifiedCvListQuery($viewid, $listquery, $currentModule); // echo $list_query; $list_sum_query = $oCustomView->getModifiedCollectListQuery($viewid, $listquery, $currentModule, $customviewdtls, 2); // echo $list_sum_query; $sum_result = $adb->query($list_sum_query); $allrecordtotal = $adb->query_result($sum_result, 0, $columnname . "_total"); if (empty($allrecordtotal)) { $allrecordtotal = 0; } //limiting the query $query_order_by = ""; if (isset($order_by) && $order_by != '') { if ($order_by == 'smownerid') { $query_order_by = 'user_name'; } else { $tablename = getTableNameForField($currentModule, $order_by); $tablename = $tablename != '' ? $tablename . "." : ''; $query_order_by = $tablename . $order_by;