From d41111a065e532f3f65e4eee7fed189ef949ade3 Mon Sep 17 00:00:00 2001
From: mcramer <m.cramer@pixcept.de>
Date: Fri, 14 Dec 2012 12:16:27 -0500
Subject: [PATCH] Fixed: Sorting as client can lead to sql errors due to amigious column sys_userid (JOINs)

---
 interface/web/client/client_list.php |    1 +
 1 files changed, 1 insertions(+), 0 deletions(-)

diff --git a/interface/web/client/client_list.php b/interface/web/client/client_list.php
index 590da21..3eff65b 100644
--- a/interface/web/client/client_list.php
+++ b/interface/web/client/client_list.php
@@ -19,6 +19,7 @@
 
 $app->listform_actions->SQLOrderBy = 'ORDER BY company_name, contact_name, client_id';
 $app->listform_actions->SQLExtWhere = "limit_client = 0";
+$app->listform_actions->SQLExtSelect = ', client.country as countryiso';
 $app->listform_actions->onLoad();
 
 

--
Gitblit v1.9.1