- Improved SQL query for displaying configuration errors.

ftimme

2013-08-08 2ea8e17f1486c7856cc0f56af2fa35ade32629dd

 interface/web/client/client_list.php

@@ -17,7 +17,9 @@

$app->uses('listform_actions');

$app->listform_actions->SQLOrderBy = 'ORDER BY company_name, contact_name, client_id';
$app->listform_actions->SQLOrderBy = 'ORDER BY client.company_name, client.contact_name, client.client_id';
$app->listform_actions->SQLExtWhere = "client.limit_client = 0";
$app->listform_actions->SQLExtSelect = ', client.country as countryiso';
$app->listform_actions->onLoad();