- Lists can now be created from more than one database table (including sor...

ftimme

2013-06-28 7d5306ea268033b92cac8496c2d5efdb16b9f6c6

 interface/web/client/client_list.php

@@ -17,8 +17,8 @@

$app->uses('listform_actions');

$app->listform_actions->SQLOrderBy = 'ORDER BY company_name, contact_name, client_id';
$app->listform_actions->SQLExtWhere = "limit_client = 0";
$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();