$emptyfolders = array(); if ($foldercount > 0) { for ($i = 0; $i < $foldercount; $i++) { $query = ''; $displayFolder = ''; $query = $focus->query; $list_query = ''; $list_query = $focus->query; $folder_id = $adb->query_result($result, $i, "folderid"); $query .= " and vtiger_notes.folderid = {$folder_id}"; $sorder = $focus->getSortOrderForFolder($folder_id); if (!is_array($_SESSION['NOTES_FOLDER_SORT_ORDER'])) { $_SESSION['NOTES_FOLDER_SORT_ORDER'] = array(); } $_SESSION['NOTES_FOLDER_SORT_ORDER'][$folder_id] = $sorder; $order_by = $focus->getOrderByForFolder($folder_id); if (!is_array($_SESSION['NOTES_FOLDER_ORDER_BY'])) { $_SESSION['NOTES_FOLDER_ORDER_BY'] = array(); } $_SESSION['NOTES_FOLDER_ORDER_BY'][$folder_id] = $order_by; if ($folder_id != $request_folderid) { $start[$folder_id] = 1; } if (isset($order_by) && $order_by != '') { $tablename = getTableNameForField('Documents', $order_by); $tablename = $tablename != '' ? $tablename . "." : ''; if ($adb->dbType == "pgsql") { $query .= ' GROUP BY ' . $tablename . $order_by; $list_query .= ' GROUP BY ' . $tablename . $order_by; $focus->additional_query .= ' GROUP BY ' . $tablename . $order_by; }