}
//<<<<<<<<customview>>>>>>>>>
if (!isset($where)) {
$where = "";
}
$url_string = '';
// assigning http url string
if (isset($_REQUEST['query']) && $_REQUEST['query'] == 'true') {
$queryGenerator->addUserSearchConditions($_REQUEST);
$ustring = getSearchURL($_REQUEST);
// we have a query
$url_string .= "&query=true" . $ustring;
$smarty->assign("SEARCH_URL", $url_string);
}
$list_query = $queryGenerator->getQuery();
$where = $queryGenerator->getConditionalWhere();
if (isset($where) && $where != '') {
$_SESSION['export_where'] = $where;
} else {
unset($_SESSION['export_where']);
}
if (isset($order_by) && $order_by != '') {
if ($order_by == 'smownerid') {
if ($adb->dbType == "pgsql") {
$list_query .= ' GROUP BY user_name';
}
$list_query .= ' ORDER BY user_name ' . $sorder;
} else {
$tablename = getTableNameForField('Contacts', $order_by);
$tablename = $tablename != '' ? $tablename . "." : '';
if ($adb->dbType == "pgsql") {
